O'Reilly logo

SAS Programming for Enterprise Guide Users, Second Edition by Neil Constable

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Data Manipulation Part 1: Queries

  • Introduction 68

  • What Is SQL? 68

  • Basic Queries: What SAS Enterprise Guide Does Already 70

    • The Query Builder Task 70

    • The Delete Data Sets and Formats Task 76

    • The Append Data Task 76

  • Indexes: Creation and Usage 77

    • Index Creation 78

    • Index Usage 80

    • Good Index, Bad Index 82

  • Updating and Validating Data 82

    • Deleting Rows 83

    • Inserting Rows 84

    • Updating 86

  • Integrity Checks 87

  • Advanced SQL Queries 90

  • Summary 91

  • Where to Look for More Information 91

  • Exercises 92

Introduction

Now we get down to some specifics, with the first of two chapters looking at manipulating information.

SAS Enterprise Guide has a number of built-in methods of manipulating data. Behind the scenes, its primary tool for this task is Structured Query Language (SQL). ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required