Seminar in data management: basic

Language

French

Prerequisites

Concepts and tools equivalent to those taught in the EU LSTAT2020 Basic notions of descriptive statistics, inference and statistical modeling

Main themes

Introduction to the SAS system, SAS tools and SAS/Base programming
Creating and manipulating data files in SAS (importing, defining formats, merging tables, manipulating, creating and transforming variables)
Preparing data summary tables, producing reports in various formats (text, html)
Performing basic statistical analyses: descriptive statistics, frequency tables, simple statistical procedures, basic graphics

Learning outcomes

At the end of this learning unit, the student is able to :
1	A. With regard to the AA framework of the Master's program in statistics, general orientation, this activity contributes to the development and acquisition of the following AAs: Primary: 5.3 Secondary: 1.3, 2.2, 3.3 With regard to the AA repository of the Master's program in statistics, biostatistics orientation, this activity contributes to the development and acquisition of the following AA: as a priority: 3.5 secondary: 1.3, 2.2, 3.3. B. At the end of this course, students will have learned to program with the BASE module of SAS software, and will be able to apply their skills to large databases.

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.
The lectures will be given in co-modal (simultaneous transmission of the course given in auditorium on Teams) and the practical work will be given in face-to-face only.

Evaluation methods

The examination of this course consists of a computer-based examination (multiple-choice questions and programming questions, computer-based examination). Students who wish to take the SAS Base Programming Certification instead of the January exam may do so.
SAS sponsors the first SAS BASE certification for students enrolled in the course. The following attempt will be charged at a reduced price (based on discounts available at the time).

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 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 ou a Master's degree in data sciences can only be made with the agreement of the course holder. This course is also available to students of the UCLouvain 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