This course is for users who want to learn how to write SAS programs to access, explore, prepare, and analyze data. It is the entry point to learning SAS programming for data science, machine learning, and artificial intelligence. It is a prerequisite to many other SAS courses.
By the end of this course, you will know how to use SAS Studio to write and submit SAS programs that access SAS, Microsoft Excel, and text data. You will know how to explore and validate data, prepare data by subsetting rows and computing new columns, analyze and report on data, export data and results to other formats, use SQL in SAS to query and join tables.
Prerequisites:
Learners should have experience using computer software. Specifically, you should be able to understand file structures and system commands on your operating systems and access data files on your operating systems. No prior SAS experience is needed.
Ce cours fait partie de la Spécialisation SAS® Programming
Getting Started with SAS® Programming
proposé par
Programme du cours : ce que vous apprendrez dans ce cours
Semaine
1Course Overview and Data Setup
In this module you learn about the course and you set up the data you need to do the practices in the course.
5 vidéos (Total 16 min), 4 lectures
5 vidéos
Demo: Programming in SAS7 min
Practicing in This Course35s
How to Set Up the Course Files in SAS OnDemand for Academics3 min
How to Set Up Course Files for SAS University Edition3 min
4 lectures
Learner Prerequisites10 min
Choosing and Setting Up SAS Software for this Course10 min
Need Help Setting Up Software?10 min
Using Forums and Getting Help10 min
Essentials
In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.
7 vidéos (Total 16 min), 2 lectures, 3 quiz
7 vidéos
Overview17s
SAS Programming Interfaces56s
Demo: Programming with SAS Studio4 min
SAS Program Structure2 min
SAS Program Syntax55s
Demo: Understanding SAS Program Syntax2 min
Demo: Finding and Resolving Syntax Errors4 min
2 lectures
Practice Using SAS Studio20 min
Syntax Review10 min
3 exercices pour s'entraîner
Activity 1.0110 min
Activity 1.0210 min
Essentials30 min
Semaine
2Accessing Data
In this module, you learn to identify the features of a SAS table, access data through SAS libraries, and import data into SAS.
14 vidéos (Total 27 min), 1 lecture, 9 quiz
14 vidéos
Overview33s
Types of Data1 min
What is a SAS Table?1 min
Required Column Attributes for SAS Tables2 min
Listing Table and Column Attributes1 min
Accessing Data in a Program1 min
Using a Library to Read SAS Data3 min
Automatic SAS Libraries1 min
Demo: Exploring Automatic SAS Libraries3 min
Using a Library to Read Other File Types2 min
Demo: Using a Library to Read Excel Files3 min
Importing Unstructured Data2 min
Demo: Importing a Comma-Delimited (CSV) File2 min
Importing an Excel File1 min
1 lecture
Syntax Review10 min
9 exercices pour s'entraîner
Question 2.015 min
Activity 2.0210 min
Activity 2.0310 min
Activity 2.04: Create a Library for This Course (Required)10 min
Activity 2.0510 min
Activity 2.0610 min
Level 1 Practice: Importing Excel Data from a Single Worksheet20 min
Level 2 Practice: Importing Data from a CSV File20 min
Accessing Data30 min
Semaine
3Exploring and Validating Data
In this module, you learn to use SAS procedures that provide insights about your data. You also learn to subset data so you can focus on particular segments, format data so you can easily understand it, and sort data to identify and resolve duplicate values.
16 vidéos (Total 41 min), 1 lecture, 14 quiz
16 vidéos
Overview42s
Exploring Data with Procedures1 min
Demo: Exploring Data with SAS Procedures6 min
Filtering Rows with the WHERE Statement1 min
Combining Expressions in a WHERE Statement58s
Demo: Filtering Rows with Basic Operators5 min
Using Special WHERE Operators1 min
Creating and Using Macro Variables2 min
Demo: Filtering Rows Using Macro Variables3 min
Formatting Data Values in Results1 min
Common Formats for Numeric Values1 min
Common Formats for Date Values26s
Demo: Formatting Data Values in Results3 min
Sorting Data1 min
Identifying and Removing Duplicates1 min
Demo: Identifying and Removing Duplicate Values5 min
1 lecture
Syntax Review10 min
14 exercices pour s'entraîner
Activity 3.0110 min
Level 1 Practice: Exploring Data with Procedures20 min
Level 2 Practice: Using Procedures to Validate Data20 min
Activity 3.0210 min
Activity 3.0310 min
Activity 3.0410 min
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20 min
Level 2 Practice: Using Macro Variables to Subset Data in Procedures20 min
Activity 3.0510 min
Activity 3.0610 min
Activity 3.0710 min
Level 1 Practice: Sorting Data and Creating an Output Table20 min
Level 2 Practice: Sorting Data to Remove Duplicate Rows20 min
Exploring and Validating Data30 min
Semaine
4Preparing Data
In this module, you learn how to do some common data manipulations, such as filtering rows and columns, computing new columns, and performing conditional processing.
13 vidéos (Total 28 min), 4 lectures, 16 quiz
13 vidéos
Overview47s
Using the DATA Step to Create a SAS Data Set1 min
DATA Step Processing1 min
Demo: Working with the DATA Step3 min
Demo: Using Expressions to Create New Columns3 min
Using Numeric Functions to Create Columns57s
Demo: Using Character Functions2 min
Demo: Using Date Functions3 min
Demo: Conditional Processing with IF-THEN3 min
Conditional Processing with IF-THEN/ELSE1 min
Creating Character Columns with the LENGTH Statement1 min
Processing Multiple Statements with IF-THEN/DO1 min
Demo: Processing Multiple Statements with IF-THEN/DO2 min
4 lectures
Common Summary Functions for Creating Columns5 min
Common Character Functions for Creating Columns2 min
Common Date Functions for Creating Columns2 min
Syntax Review10 min
16 exercices pour s'entraîner
Question 4.015 min
Question 4.022 min
Activity 4.0310 min
Level 1 Practice: Creating a SAS Table20 min
Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20 min
Activity 4.0410 min
Activity 4.0510 min
Activity 4.0610 min
Level 1 Practice: Creating New Columns20 min
Level 2 Practice: Creating New Columns with Character and Date Functions20 min
Activity 4.0710 min
Activity 4.0810 min
Activity 4.0910 min
Level 1 Practice: Processing Statements with IF-THEN/ELSE20 min
Level 2 Practice: Processing Statements Conditionally with DO Groups20 min
Preparing Data30 min
4.9
26 avis50%
a commencé une nouvelle carrière après avoir terminé ces cours
50%
a bénéficié d'un avantage concret dans sa carrière grâce à ce cours
Meilleurs avis
par RC•Jan 9th 2019
I like the learning structure with demo and exercises. It takes only few days to finish, friendly to beginner and you will have great basic concepts about sas.
par CM•Feb 15th 2019
Excellent foundation builder with brilliantly framed activities. Highly recommend this for SAS beginners.
Enseignant
Stacey Syphus
Senior ManagerEducation
À propos de SAS
Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.
À propos de la Spécialisation SAS® Programming
When you complete the SAS® Base Programming courses, you will have demonstrated skills in manipulating and transforming data, combining SAS data sets, creating basic detail and summary reports using SAS procedures and identifying and correcting data, syntax and programming logic errors. These skills prepare you for the SAS® Base Programmer certification exam.
Foire Aux Questions
Quand aurai-je accès aux vidéos de cours et aux devoirs ?
Une fois que vous êtes inscrit(e) pour un Certificat, vous pouvez accéder à toutes les vidéos de cours, et à tous les quiz et exercices de programmation (le cas échéant). Vous pouvez soumettre des devoirs à examiner par vos pairs et en examiner vous-même uniquement après le début de votre session. Si vous préférez explorer le cours sans l'acheter, vous ne serez peut-être pas en mesure d'accéder à certains devoirs.
À quoi ai-je droit si je m'abonne à cette Spécialisation ?
Lorsque vous vous inscrivez au cours, vous bénéficiez d'un accès à tous les cours de la Spécialisation, et vous obtenez un Certificat lorsque vous avez réussi. Votre Certificat électronique est alors ajouté à votre page Accomplissements. À partir de cette page, vous pouvez imprimer votre Certificat ou l'ajouter à votre profil LinkedIn. Si vous souhaitez seulement lire et visualiser le contenu du cours, vous pouvez accéder gratuitement au cours en tant qu'auditeur libre.
Quelle est la politique de remboursement ?
Une aide financière est-elle possible ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
Coursera propose un accès universel à la meilleure formation au monde,
en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.
© 2019 Coursera Inc. Tous droits réservés.
