Note from June 29, 2020
Although we do not yet know how long the social distancing related to the Covid-19 pandemic will last, and regardless of the changes that had to be made in the evaluation of the June 2020 session in relation to what is provided for in this learning unit description, new learnig unit evaluation methods may still be adopted by the teachers; details of these methods have been - or will be - communicated to the students by the teachers, as soon as possible.
Although we do not yet know how long the social distancing related to the Covid-19 pandemic will last, and regardless of the changes that had to be made in the evaluation of the June 2020 session in relation to what is provided for in this learning unit description, new learnig unit evaluation methods may still be adopted by the teachers; details of these methods have been - or will be - communicated to the students by the teachers, as soon as possible.
6 credits
15.0 h + 10.0 h
Q2
Teacher(s)
Kabacinski Christophe;
Language
French
Prerequisites
« Base SAS Programming » certificate or equivalent knowledge.
Basic English comprehension (a case study presented in English will be used during the evaluations, syllabus and exercises written in English).
The prerequisite(s) for this Teaching Unit (Unité d’enseignement – UE) for the programmes/courses that offer this Teaching Unit are specified at the end of this sheet.
Basic English comprehension (a case study presented in English will be used during the evaluations, syllabus and exercises written in English).
The prerequisite(s) for this Teaching Unit (Unité d’enseignement – UE) for the programmes/courses that offer this Teaching Unit are specified at the end of this sheet.
Main themes
- Utilization of the SQL language via SAS to access and write SAS tables or database tables (Oracle, Excel, MySQL…), report creation,
- Utilization of the SAS Macro language in order to automate the underlying SAS code,
- Introduction to SAS code optimization,
- Discovery of the latest SAS release : SAS Viya.
- Utilization of a Case Study to develop and improve practice.
Aims
At the end of this learning unit, the student is able to : | |
| 1 | A. Regarding the AA reference of the master in Statistics program, major “general” this activity contributes to the development and the acquisition of the following AA: With priority manner : 5.3 With secondary manner : 1.3, 2.2, 3.3 Regarding the AA reference of the master in Statistics program, major “Biostatistic” this activity contributes to the development and the acquisition of the following AA: With priority manner : 3.5 With secondary manner : 1.3, 2.2, 3.3. B. Specific formulation of this activity in the program: At the end of this course, the student will be familiar with different SAS advanced programming tools including the SAS macro language and SAS SQL language. He/she will moreover have an overview of the latest SAS release: SAS Viya. He/she will be able to use practically the various tools through a case study. Finally, he/she will learn 50% of the theory required to pass the « SAS Advanced Programming » certificate. |
The contribution of this Teaching Unit to the development and command of the skills and learning outcomes of the programme(s) can be accessed at the end of this sheet, in the section entitled “Programmes/courses offering this Teaching Unit”.
Content
SAS SQL
- query and subset data
- summarize and present data
- combine tables, including complex joins and merges
- create and modify table views and indexes
- replace multiple DATA and PROC steps with one SQL query
- perform text substitution in SAS code
- automate and customize the production of SAS code
- conditionally or iteratively construct SAS code
- use macro variables and macro functions
- Identifying computer resources related to efficiency
- Introduction to SAS Viya
- Loading data in SAS Viya via SAS Studio programming interface
- Accessing the data in other tools: Visual Analytics (VA) and Visual Data Mining and Machine Learning (VDMML)
- Integration of Python and R in SAS Viya
Teaching methods
This course is divided in 5 X 3 hours of lecture, 5 X 2 hours of exercise and 2 coaching sessions (full presentation and detailed correction of a case study).
A large part of the course is realized individually thanks to a syllabus, the SAS documentation and an E-learning modules delivered by SAS.
A large part of the course is realized individually thanks to a syllabus, the SAS documentation and an E-learning modules delivered by SAS.
Evaluation methods
The exam of this course consist on an end-to-end real life case study where the student will have to apply the advance programming technics learned in this course. The case study will be described in English.
Other information
This course is born from a partnership between the UCLouvain and the SAS Institute. It is open to all students issued from a Belgian university after inscription to the academic program (master students or Phd), who succeeded the Base SAS Programming certification(or who could demonstrate an equivalent knowledge). This course is also accessible to the students of the « Certificat Universitaire en Statistique » under certain conditions.
Online resources
Moodle
Teaching materials
- Syllabus du cours en vente au début du cours. Accès à la documentation SAS.
Faculty or entity
LSBA
Programmes / formations proposant cette unité d'enseignement (UE)
Title of the programme
Sigle
Credits
Prerequisites
Aims
Approfondissement en statistique et sciences des données
Advanced Master in Quantitative Methods in the Social Sciences
Master [120] in Mathematical Engineering
Master [120] in Data Science : Statistic
Master [120] in Statistic: Biostatistics
Certificat d'université : Statistique et sciences des données (15/30 crédits)