SQL
Tips relating to the use of SQL, including comparing with Data Step.
We send out a regular newsletter communication to our customers which include our latest SAS tips. Sign up to the Amadeus Newsletter.
-
Automatic Filtering of User Data
- Date:
- February 2012
In some situations data might be user sensitive and locked down such that only the owner can view it. There is a quick method of automatically setting this up by using Data St...
-
Using Database-Specific SQL Features in SAS
- Date:
- May 2011
Pass-through mode in Proc SQL is most often used to improve efficiency, but that is not the only benefit it can bring. It can also make available to the SAS user SQL syntax wh...
-
The Monotonic() Function
- Date:
- December 2010
The Data Step environment has an internal counter that takes the form of an automatic variable named _N_. Within the SQL environment, the concept of internal iterations does n...
-
Using the ANY and ALL Operators in Proc SQL
- Date:
- December 2010
The ANY and ALL operators are Proc SQL operators which can be used to compare the result of a query expression against either ANY or ALL of the results returned from another.
