Reading assignment: Chapter 26

Structured query language (usually pronounced sequel), offers an alternative way to the DATA step for querying and combining SAS data sets. Some Basics. Table lists SAS terms and corresponding SQL terms: SAS Term SQL Equivalent Data set Table. Observation Row. Variable Column. Syntax: PROC SQL; SELECT col1, col2, …, colk. FROM table ................
................