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
  • PrintPrint

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.

UNIONadds all unique rows from both queries.
EXCEPTadds all the unique rows that are in the first query but not the second.
INTERSECTadds all the unique rows that are present in both queries.
OUTER UNIONconcatenates the queries (used in the Append Data task).



  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint