In Proc SQL, we can use multiple columns in where condition like other SQL databases.
For Example: If we want to select Names and salary of employees from different department belonging to different tables then we have to write two ANDs in where condition and not writing like:
where (department, wing, building) in
( Select department, wing, building
where <some condition> )
This type of query is not provided by SAS. One has to write two ANDs along with three select statements. This makes the performance poor.
SAS implements ANSI SQL. This is the base SQL language. Each database/software adds its own bits on top of that set. I don't think SAS will implement each feature found on all the other softwares platforms, purely logistically is would be difficult, not to mention re-inventing the wheel.
You can of do course do something like:
where catx('-',department,wing,building) in (select catx('-',department,wing,building) from sastmp.table2 where <some condition>)
There are also other methods for more situation specific which can be considered as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.