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 > Advanced SQL Queries
Advanced SQL Queries
You have now seen the majority of the SQL syntax supported by SAS. A few variations on the set or union operators enable you to include or exclude rows or columns in the tables to be joined.
| UNION | adds all unique rows from both queries. |
| EXCEPT | adds all the unique rows that are in the first query but not the second. |
| INTERSECT | adds all the unique rows that are present in both queries. |
| OUTER UNION | concatenates the queries (used in the Append Data task). |
