An Idea Exchange for SAS software and services

Comments
by Super User
on ‎05-20-2015 05:09 AM

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.

Idea Statuses
Top Liked Authors