SAS Tips and Tricks

Summary

SAS Tips and Tricks consists of half days/full days of knowledge transfer in SAS programming language and are organized by an experienced and motivated SAS consultant who combines theory and demonstration to helps you refreshing your SAS skills, discover news technics and meet other experts.

Organized for employees, sessions are organized in our business center (near Brussels-North train station) and, to guaranty an optimal quality, the number of participants is limited to 8 persons. Contact us to assist to a session (scheduled or not) or click the register button in the course details, we will recontact you with more informations.

You cannot find a topic you would like to follow or would like to follow the session individually at your best conveniance? Please Contact us in order to see if we could organize a SAS Coaching that suits perfectly your needs.

Topic list

Reading flat files in SAS Data Step gives you a lot of flexibility in terms of data quality and data manipulation. However, problem may arise when files are huge with poor data quality. In this tips and tricks we will have a look to the 'heart' of the Data Step manipulation and learn to do as much as we can do in this important step: applying data quality rules, creating error datasets, selecting good variables and records (etc.)

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.

SAS hash objects are super fast in-memory technic allowing you to perform join operation, lookup, data check (etc.) this technic can be used on datasets but also when flat files are read allowing you to do data validation during the load phase of your data.

Level= Intermediate

Indexes are special reference tables that the SAS engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. In this tips and tricks we will discuss how you can create and use SAS indexes.