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.
Dieser Kurs ist Teil der Spezialisierung Spezialisierung SAS® Programming
Getting Started with SAS® Programming
4.9
(237 ratings)
8,655 bereits angemeldet!
von
Lehrplan - Was Sie in diesem Kurs lernen werden
Woche
11 Stunde zum Abschließen
Course 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 Videos (Gesamt 16 min), 4 Lektüren
5 Videos
Demo: Programming in SAS7m
Practicing in This Course35
How to Set Up the Course Files in SAS OnDemand for Academics3m
How to Set Up Course Files for SAS University Edition3m
4 Lektüren
Learner Prerequisites10m
Choosing and Setting Up SAS Software for this Course10m
Need Help Setting Up Software?10m
Using Forums and Getting Help10m
2 Stunden zum Abschließen
Essentials
In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.
7 Videos (Gesamt 16 min), 2 Lektüren, 3 Quiz
7 Videos
Overview17
SAS Programming Interfaces56
Demo: Programming with SAS Studio4m
SAS Program Structure2m
SAS Program Syntax55
Demo: Understanding SAS Program Syntax2m
Demo: Finding and Resolving Syntax Errors4m
2 Lektüren
Practice Using SAS Studio20m
Syntax Review10m
3 praktische Übungen
Activity 1.0110m
Activity 1.0210m
Essentials30m
Woche
23 Stunden zum Abschließen
Accessing 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 Videos (Gesamt 27 min), 1 Lektüre, 9 Quiz
14 Videos
Overview33
Types of Data1m
What is a SAS Table?1m
Required Column Attributes for SAS Tables2m
Listing Table and Column Attributes1m
Accessing Data in a Program1m
Using a Library to Read SAS Data3m
Automatic SAS Libraries1m
Demo: Exploring Automatic SAS Libraries3m
Using a Library to Read Other File Types2m
Demo: Using a Library to Read Excel Files3m
Importing Unstructured Data2m
Demo: Importing a Comma-Delimited (CSV) File2m
Importing an Excel File1m
1 Lektüre
Syntax Review10m
9 praktische Übungen
Question 2.015m
Activity 2.0210m
Activity 2.0310m
Activity 2.04: Create a Library for This Course (Required)10m
Activity 2.0510m
Activity 2.0610m
Level 1 Practice: Importing Excel Data from a Single Worksheet20m
Level 2 Practice: Importing Data from a CSV File20m
Accessing Data30m
Woche
35 Stunden zum Abschließen
Exploring 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 Videos (Gesamt 41 min), 1 Lektüre, 14 Quiz
16 Videos
Overview42
Exploring Data with Procedures1m
Demo: Exploring Data with SAS Procedures6m
Filtering Rows with the WHERE Statement1m
Combining Expressions in a WHERE Statement58
Demo: Filtering Rows with Basic Operators5m
Using Special WHERE Operators1m
Creating and Using Macro Variables2m
Demo: Filtering Rows Using Macro Variables3m
Formatting Data Values in Results1m
Common Formats for Numeric Values1m
Common Formats for Date Values26
Demo: Formatting Data Values in Results3m
Sorting Data1m
Identifying and Removing Duplicates1m
Demo: Identifying and Removing Duplicate Values5m
1 Lektüre
Syntax Review10m
14 praktische Übungen
Activity 3.0110m
Level 1 Practice: Exploring Data with Procedures20m
Level 2 Practice: Using Procedures to Validate Data20m
Activity 3.0210m
Activity 3.0310m
Activity 3.0410m
Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20m
Level 2 Practice: Using Macro Variables to Subset Data in Procedures20m
Activity 3.0510m
Activity 3.0610m
Activity 3.0710m
Level 1 Practice: Sorting Data and Creating an Output Table20m
Level 2 Practice: Sorting Data to Remove Duplicate Rows20m
Exploring and Validating Data30m
Woche
45 Stunden zum Abschließen
Preparing 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 Videos (Gesamt 28 min), 4 Lektüren, 16 Quiz
13 Videos
Overview47
Using the DATA Step to Create a SAS Data Set1m
DATA Step Processing1m
Demo: Working with the DATA Step3m
Demo: Using Expressions to Create New Columns3m
Using Numeric Functions to Create Columns57
Demo: Using Character Functions2m
Demo: Using Date Functions3m
Demo: Conditional Processing with IF-THEN3m
Conditional Processing with IF-THEN/ELSE1m
Creating Character Columns with the LENGTH Statement1m
Processing Multiple Statements with IF-THEN/DO1m
Demo: Processing Multiple Statements with IF-THEN/DO2m
4 Lektüren
Common Summary Functions for Creating Columns5m
Common Character Functions for Creating Columns2m
Common Date Functions for Creating Columns2m
Syntax Review10m
16 praktische Übungen
Question 4.015m
Question 4.022m
Activity 4.0310m
Level 1 Practice: Creating a SAS Table20m
Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20m
Activity 4.0410m
Activity 4.0510m
Activity 4.0610m
Level 1 Practice: Creating New Columns20m
Level 2 Practice: Creating New Columns with Character and Date Functions20m
Activity 4.0710m
Activity 4.0810m
Activity 4.0910m
Level 1 Practice: Processing Statements with IF-THEN/ELSE20m
Level 2 Practice: Processing Statements Conditionally with DO Groups20m
Preparing Data30m
29%
nahm einen neuen Beruf nach Abschluss dieser Kurse auf
40%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
17%
erhalten Sie eine Gehaltserhöhung oder Beförderung
Top-Bewertungen
This course offers a solid foundation to anyone who is interested in beginning to use SAS. I have found the demos, activites and practices to be fairly easy yet still required me to use my brain.
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.
Dozent
Stacey Syphus
Senior ManagerEducation
Über 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.
Über die Spezialisierung 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.
Häufig gestellte Fragen
Wann erhalte ich Zugang zu den Vorträgen und Aufgaben?
Sobald Sie sich für ein Zertifikat angemeldet haben, haben Sie Zugriff auf alle Videos, Quizspiele und Programmieraufgaben (falls zutreffend). Aufgaben, die von anderen Kursteilnehmern bewertet werden, können erst dann eingereicht und überprüft werden, wenn Ihr Unterricht begonnen hat. Wenn Sie sich den Kurs anschauen möchten, ohne ihn zu kaufen, können Sie womöglich auf bestimmte Aufgaben nicht zugreifen.
Was bekomme ich, wenn ich diese Spezialisierung abonniere?
Wenn Sie sich für den Kurs anmelden, erhalten Sie Zugriff auf alle Kurse der Spezialisierung und Sie erhalten nach Abschluss aller Arbeiten ein Zertifikat. Ihr elektronisches Zertifikat wird zu Ihrer Seite „Errungenschaften“ hinzugefügt – von dort können Sie Ihr Zertifikat ausdrucken oder es zu Ihrem LinkedIn Profil hinzufügen. Wenn Sie nur lesen und den Inhalt des Kurses anzeigen möchten, können Sie kostenlos als Gast an dem Kurs teilnehmen.
Wie erfolgen Rückerstattungen?
Ist finanzielle Unterstützung möglich?
Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..
Coursera arbeitet mit erstklassigen Universitäten und Organisationen zusammen, um Online-Kurse anzubieten und dadurch universellen Zugriff auf die weltweit beste Ausbildung zu ermöglichen.
© 2019 Coursera Inc. Alle Rechte vorbehalten.
