Data Management II : SAS ADVANCED PROGRAMMING

ldats2370  2020-2021  Louvain-la-Neuve

Data Management II : SAS ADVANCED PROGRAMMING
Due to the COVID-19 crisis, the information below is subject to change, in particular that concerning the teaching mode (presential, distance or in a comodal or hybrid format).
5 credits
15.0 h + 10.0 h
Q2
Teacher(s)
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.
 
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
SAS Macro
  • 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
Introduction to SAS Optimization Technics:
  • Identifying computer resources related to efficiency
SAS Viya
  • 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

Due to the COVID-19 crisis, the information in this section is particularly likely to change.

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.
Evaluation methods

Due to the COVID-19 crisis, the information in this section is particularly likely to change.

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


Programmes / formations proposant cette unité d'enseignement (UE)

Title of the programme
Sigle
Credits
Prerequisites
Aims
Master [120] in Data Science : Statistic

Certificat d'université : Statistique et sciences des données (15/30 crédits)

Advanced Master in Quantitative Methods in the Social Sciences

Master [120] in Mathematical Engineering

Approfondissement en statistique et sciences des données

Master [120] in Statistic: General

Master [120] in Statistic: Biostatistics