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
In the final example, a hash is used for the join:
sqxjhsh
sqxsrc( LOCAL.MYDATA )
sqxsrc( WORK.JOIN_DATA1 )
Adding a Column to the Target Table
Problem
You want to add a column to the target table for an SQL query that is used in a SAS
Data Integration Studio job.
Solution
You can use the Columns tab on the properties window for the target table to add a
column to the target table. (You can also add a column in the Select tab. To perform this
task, right-click in the Target table field and click New Column in the pop-up menu.)
Tasks
Add a Column with the Columns Tab for the Target Table
Perform the following steps to add a column to the target table: ...
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