Seminar in data management: basic

lstat2360  2019-2020  Louvain-la-Neuve

Seminar in data management: basic
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.
5 credits
15.0 h + 10.0 h
Q1
Teacher(s)
Bugli Céline;
Language
French
Main themes
- Introduction to the SAS system and to SAS/Base programming. - Creation and manipulation of datasets with SAS: importing and exporting datasets, format definition, table merging, variable manipulation, creation and transformation. - Preparation of summary tables, preparation of reports in different formats (txt, html...) - Presentation of the " SAS base programming " certificate.
Aims

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

1 At the end of this course, the student will master the programming in SAS/Base and will be able to apply its skills on big and complicated data sets.
 

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 Programming 1: Essentials
  • Use SAS Studio and SAS Enterprise Guide to write and submit SAS programs.
  • Access SAS, Microsoft Excel, and text data.
  • Explore and validate data.
  • Prepare data by subsetting rows and computing new columns.
  • Analyze and report on data.
  • Export data and results to Excel, PDF, and other formats.
  • Use SQL in SAS to query and join tables.
SAS Programming 2: Data Manipulation Techniques
  • understand and control DATA step processing
  • create an accumulating column and process data in groups
  • manipulate data with functions
  • convert column type
  • create custom formats
  • concatenate and merge tables
  • process repetitive code
  • restructure tables.
Teaching methods
In addition to the lectures and computer room exercises, much of the training is done autonomously using the syllabus, SAS documentation, and e-learning tools provided by SAS.
Evaluation methods
The examination of this course consists of passing the SAS Base Programming Certification (QCM).
Other information
A large part of the training is carried out autonomously using materials available on the SAS website (SCYP program). This course is only open to students enrolled in a master's degree in statistics and with a good command of passive English.
Online resources
https://moodleucl.uclouvain.be/course/view.php?id=8018
This course is open to all students from Belgian universities after enrolment in the academic programme (Master's or Doctoral students). However, as the number of places is limited, enrolment for students other than those in the Master's degree in statistics, general orientation or biostatistics can only be made with the agreement of the course holder. This course is also available to students of the UCL University Certificate in Statistics under certain conditions.
The course content is only available after official registration.
Bibliography
Syllabus du cours en vente au début du cours.
Accès à la documentation SAS.
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

Master [120] in Data Science : Statistic

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

Master [120] in Mathematical Engineering

Advanced Master in Quantitative Methods in the Social Sciences

Master [120] in Population and Development Studies

Master [120] in Statistic: Biostatistics

Master [120] in Actuarial Science

Master [120] in Biochemistry and Molecular and Cell Biology

Master [120] in Biomedical Engineering

Master [120] in Statistic: General