Structured Query Language (SQL) is a very known language used to query relational database. Since 1986, this langage is fully integrated in SAS and can be used via the Proc SQL .

Creating or accessing tables using SQL syntax have lot of advantages for Data Step programmer, this tips and tricks covers everything you have to know concerning the usage of the SQL into SAS. Table of contents:

• select variables and observations,
• add label and format to your report,
• create variables conditionally,
• Use binary expression to count records having specific pattern,
• subquery in where clause,
• aggregate values,
• filter aggregated values,
• create table and view,
• join tables,
• concatenate tables.

You don't have any SAS experience and would like to understand the basic terminology of the SAS proc SQL.