SAS Tips and Tricks consists of half days/full days of knowledge transfer in SAS programming language and are organized by an motivated SAS Expert 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 on a monthly basis 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.
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.)
At the era of the big data, its very common to have lot of variables to manipulate in blocks of variables. Arrays, Do loops and variable lists are powerful data manipulation tools that help make code more efficient for repetitive operation.
Creating or reading flat files from SAS can be done in several ways in SAS: proc import, proc export are common examples. When flat files are not simple line of records, it becomes impossible to use default technics and Data Step programming becomes required.
SAS macro language allows you to process dynamically all the files of a directory or all the files of a library . Different technic exist depending on the nature of the files. This tips and tricks discuss the case when your files are datasets present in a single library and discuss the case when we manipulate flat files in a folder structure.
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.
In this tips and tricks we will have a look to the merge statement of the SAS DataStep in order to combine datasets.
Base SAS contains couple of very nice procedures to create reports on your data . This tips and tricks shows you an overview of the most popular including The Proc Tabulate which is one of the most powerful SAS reporting Procedure.
SAS has more than 190 of built-in functions allowing you to perform a variety of programming tasks. It would be a burden to explain them all in an half day, that is the reason why we selected the most useful one in this tips and tricks.
Macro variables are tools that enable you to dynamically modify the text in a SAS program through symbolic substitution. You can assign large or small amounts of text to macro variables, when you reference the variable afterward the text that it contains will substitute the variable name.
Macro programs or Macros are compiled line of codes referred by a name that you can call anywhere in a SAS program using that name. This allows you to create SAS toolbox of code which can be used in different codes, using different parameters, using Conditional processing....