SAS Programming for Enterprise Guide Users, Second Edition

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). ...