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 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.)

Level= Intermediate

At the era of the big data, it's very common to have lot of variables to manipulate in blocks of variables. Arrays and Do loops are powerful data manipulation tools that help make code more efficient for repetitive operation.

Level= Intermediate

SAS Variable lists allows you to simplify the variable notations in your Data Step code. Very often we forget that capability of the SAS programing language which can be particularly useful when lot of variables have similar name and have to processed together.

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

SAS formats are instruction that SAS uses to write data values. You use formats to control the written appearance of data values, or, in some cases, to group data values together for analysis. You can create format manually with hardcoded values or from datasets, you can store them in permanent library, share them and also use build-in format (etc.) every thing you want to know about SAS format should be present in this tips and tricks.

The SAS hash object is meant to enable you to quickly and efficiently store, search, and retrieve data based on lookup keys , Conceptually, the hash object provides programmers the means to easily define and utilize a hash table within the Data Step.

Creating CSV from SAS can be done in Data Step, Proc export or using ODS CSV. When CSV are not simple line of records, it becomes impossible to use this technic and Data Step programming is required.

XML files are not simple line of records, they have a hierarchy and they are not easy to create programmatically. Sometimes software cannot create complex XML files and it becomes mandatory to pass through this step. In this tips and tricks, we will see how we can create XML in Data Step.