Data Management II : SAS ADVANCED PROGRAMMING

lstat2370  2017-2018  Louvain-la-Neuve

Data Management II : SAS ADVANCED PROGRAMMING
6 credits
7.5 h + 25.0 h
Q2
Teacher(s)
Legrand Catherine;
Language
French
Prerequisites

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
-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.
Aims

At the end of this learning unit, the student is able to :

1

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.

 

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”.
Other information
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).
Bibliography
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
Master [120] in Statistics: General

Master [120] in Mathematical Engineering

Master [120] in Statistics: Biostatistics

Master [120] in data Science: Statistic

Additionnal module in Statistics and data science