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
Display 21.14 Sample Where Tab Settings
Note that the SQL code for the WHERE clause that is shown in the SQL field is
identical to the highlighted WHERE clause code that is displayed on the Code tab. To
highlight the code for a query object such as the Where object, right-click the object in
the Navigate pane and click Find In. Then, click Code in the submenu.
Note that WHERE conditions are not optimized for these types of conditions:
arithmetic operators
variable-to-variable condition
sounds-like operator
any function other than SUBSTR and TRIM
Adding a GROUP BY Clause and a HAVING
Clause
Problem
You want to group your results by a selected ...
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