SAS Tips and Tricks

Data Step VS Proc SQL: really different?

It's not always easy to choose between Proc SQL and Data Step programming. In this tips and tricks, we will see the big differences between Proc SQL and Data Step and list the pro's and the con's of both of them.

Details

In SAS, you can choose between Proc SQL and Data Step when you do data manipulation. Do the two methods generate the same results? Are they both efficient in terms of data processing or ease of use? When should I use one technic or the other technic?
In this tips and tricks, we will compare both methods on the basis of the following:

  • Read one input and create one or several output
  • Read several input and create one output or several
  • Code complex algorithms implying lot of variables
  • Aggregate results
  • Create simple or complex report
  • Read non SAS files (flat or database)

Prerequisites

You are a SAS beginner or used SAS long time ago in the past and would like to refresh your skills.

Quick Facts

  • Scheduled date: Registrations are now closed for this session.
  • Duration :3 Hours
  • Fee :240 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