Aims

At the end of this seminar, the student will master the main data management tools of SAS software and will be able to apply them on big data sets.

Main themes

- Basics of the SAS Language : basic SAS programming concepts, creation of SAS data sets, file importing and exporting, merging, formats definition, variables transformation, control statements (loops).
- Creation of data table summaries and basic graphics, report exportation in different formats (HTML, text...)
- Use of SQL as a data query tools in the SAS language.
- SAS Macro Language : design and structure of SAS macros, debugging and integrating SAS macros in SAS programs.
- Advanced SAS programming : efficient data storage and manipulation, memory and data space optimisation, efficient programming techniques
- Practical use of all tools on data sets.

Content and teaching methods

The main themes discussed in this course are :
- Basics of the SAS Language : basic SAS programming concepts, creation of SAS data sets, file importing and exporting, merging, formats definition, variables transformation, control statements (loops).
- Creation of data table summaries and basic graphics, report exportation in different formats (HTML, text)
- Use of SQL as a data query tools in the SAS language.
- SAS Macro Language : design and structure of SAS macros, debugging and integrating SAS macros in SAS programs.
- Advanced SAS programming : efficient data storage and manipulation, memory and data space optimisation, efficient programming techniques
- Practical use of all tools on data sets.

This course can only be followed by students of the' statistics, data mining and data managemen't orientation of the DEC of UCL. It is organised in two parts :
- Self treaning to the basics of SAS through the computer based SAS tutorial and presentation of the SAS certificate: 'SAS Core Concepts V8 'Exam'.
- Participation to 11 days of seminars at SAS in Brussels on :
- SQL Procession with the SAS System (2 days)
- SAS Macro Language ( 2 days)
- Advanced Programming and Eficiency Techniques ( 3 days)
- Hands-on-workshop and self assessment (4 days)

For more information:

http://www.stat.ucl.ac.be/cours/stat2560/index.html

http://www.stat.ucl.ac.be/cours/stat2560/index.html

Other credits in programs