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
Adding Subqueries
Problem
You want to add one or more subqueries to an existing SQL query by using the
Designer tab of the properties window for the SQL Join transformation.
Solution
Use the Subquery object in the Designer window to add a subquery to an SQL query.
The sample job used in “Add a Subquery as an Input Table” on page 470 adds a
subquery to an input table. This subquery reduces the amount of data that is processed in
the main SQL query because it runs and subsets data before the SELECT clause is run.
“Add a Subquery to an SQL Clause” on page 473 covers adding a subquery to a
SELECT, WHERE, or HAVING clause in an SQL query.
Perform the ...
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