UCL - SAS advanced programming

[STAT2370]

[7.5h + 25h] 6 credits

This course is taught in the 2d semester.

Teacher(s): Bernadette Govaerts(coord.)

Language: French

Level: Second

Aims
Main themes
Other information (prerequisite, evaluation (assessment methods), course materials recommended readings, ...)

Aims

At the end of this training, the student will be trained to the various advanced SAS programming tools like SAS macros, SAS SQL and ETL Studio. He will be able to apply them on complex and multiple data bases.

Main themes

-Data bases handling in SAS: writing of SQL requests to other data base systems (Oracle). Use of the SQL language in SAS.
- Development of SAS macros: description of the SAS macro language, creation and use of macros, macro programming and debugging.
- SAS advanced and efficient programming: efficient storage and manipulation of big datasets, memory optimisation, efficient programming techniques.
- Application of all the tools on advanced case studies.

Other information (prerequisite, evaluation (assessment methods), course materials recommended readings, ...)

This course is only open to students of the masters in statistics having a good passive English knowledge and having succeeded in the " SAS Base programming " certificate (see course STAT2360).