What is SAS programming

SAS programming II

Seminar / training SAS programming II

SAS resource measurement - Measure resource consumption - I / O consumption and main memory usage - SAS DATA step processing - Controlling I / O operations - Views - Compressing SAS files

Access to rows of data - Samples - index SAS files

Arrays in DATA Steps - Lookup Techniques - Arrays

Hash and hit objects in the DATA step - Methods for hash objects - Load hash objects from a SAS file - Hiter object in the DATA step

Linking data - Merge in DATA Step - Join with PROC SQL - Indices when linking data -
Link totals and detail data Conditional links

SAS Advanced Programming Techniques - User-defined functions - FORMAT procedure

Macro variables - Overview - Automatic macro variables - Referencing of macro variables - User-defined macro variables - Separator for macro variable referencing - Macro functions

DATA Step and SQL interface - Macro variables in the DATA Step - Indirect referencing to macro variables

Macro programs - Definition and call - Macro parameters - Conditional processing - Validation of the parameters - Iterative processing - Global and local symbol tables

Storage of macros - Compiled macros - Autocall functionality

Masking special characters - Constant text - resolved values

Table lookup techniques -Macro Variables - Formats

Validation of user input -Macro parameters - macro window

SAS files - Data-driven macro calls - SAS I / O functions

External data - Importing CSV files and Excel files