Skip to Main Content
SAS Data Integration Studio 4.9
book

SAS Data Integration Studio 4.9

by SAS Documentation
August 2014
Intermediate to advanced content levelIntermediate to advanced
808 pages
25h 30m
English
SAS Institute
Content preview from SAS Data Integration Studio 4.9
The View Data window appears, as shown in the following display:
Display 22.6 Insert Rows Results
Using the SQL Set Operators Transformation
Problem
You want to combine the results of table-based queries.
Solution
You can use the SQL Set Operators transformation in a SAS Data Integration Studio job.
This transformation generates a PROC SQL statement that combines the results of two
or more queries in various ways by using the following set operators:
UNION: Produces all unique rows from both queries
EXCEPT: Produces rows that are part of the first query only
INTERSECT: Produces rows that are common to both query results
OUTER UNION: Concatenates ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

A Gentle Introduction to Statistics Using SAS Studio in the Cloud

Ron Cody

Publisher Resources

ISBN: 9781629593098