SAS Tips and Tricks

SAS Proc SQL

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 .

Details

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.

Prerequisites

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

Quick Facts

  • Scheduled date: Session not yet scheduled.
  • Duration :3 Hours
  • Fee :210 Euros (VAT Exclusive)
  • Language: French/English
  • Included: Coffees, tips and tricks material

Christophe Kabacinski

click here to get more information about this teacher.

Course Location

This course will be organized at : Lodge.co Boulevard Simon Bolivar 34 1000 Bruxelles


Go back to your selection


This site uses cookies. .

By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.