As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

SQL UNION operator

From sasCommunity
Revision as of 15:32, 27 July 2018 by Donh (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

As part of the decommissioning effort for this article/tip has been migrated to

The new home for this article/tip is SQL UNION operator (

The UNION operator in Proc SQL is used to append the rows of two or more SELECT statements having the same number of columns with similar data types. Similar columns in each SELECT statement should normally be in the same order, as the Union is done by position not by column name, except where appending dissimilar columns from a select statement is explicitly desired.

Usage notes

Note that, unlike using the SET statement with multiple datasets, the default behavior of the UNION operator is to remove duplicate rows, from the results of each SELECT statement as well as overall, resulting in only DISTINCT rows. If retention of duplicate rows is desired, either OUTER UNION must be specified, or else the ALL operator must be used on individual SELECT statements where duplicates are desired.


SELECT column_name(s) FROM table_name1
SELECT column_name(s) FROM table_name2