Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Chapter 4. Data Manipulation Part 1: Queries
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
Where to Look for More Information 91
Exercises 92
