This course is for business analysts and SAS programmers who want to learn data manipulation techniques using the SAS DATA step and procedures to access, transform, and summarize data. The course builds on the concepts that are presented in the Getting Started with SAS Programming course and is not recommended for beginning SAS software users.
Dieser Kurs ist Teil der Spezialisierung SAS Programmer Zertifikat über berufliche Qualifikation
von
Über diesen Kurs
121,187 kürzliche Aufrufe
Karriereergebnisse der Lernenden
33%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
50%
erhalten Sie eine Gehaltserhöhung oder Beförderung
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Kurs 2 von 3 in
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Stufe „Mittel“
Ca. 24 Stunden zum Abschließen
Englisch
Untertitel: Englisch
Karriereergebnisse der Lernenden
33%
ziehen Sie für Ihren Beruf greifbaren Nutzen aus diesem Kurs
50%
erhalten Sie eine Gehaltserhöhung oder Beförderung
Zertifikat zur Vorlage
Erhalten Sie nach Abschluss ein Zertifikat
100 % online
Beginnen Sie sofort und lernen Sie in Ihrem eigenen Tempo.
Kurs 2 von 3 in
Flexible Fristen
Setzen Sie Fristen gemäß Ihrem Zeitplan zurück.
Stufe „Mittel“
Ca. 24 Stunden zum Abschließen
Englisch
Untertitel: Englisch
von
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.
Lehrplan - Was Sie in diesem Kurs lernen werden
1 Stunde zum Abschließen
Course Overview and Data Setup
In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.
1 Stunde zum Abschließen
2 Videos (Gesamt 1 min), 4 Lektüren
4 Lektüren
Learner Prerequisites10m
Choosing and Setting Up SAS Software for this Course10m
Follow These Instructions to Set Up Data for This Course (REQUIRED)30m
Using Forums and Getting Help10m
3 Stunden zum Abschließen
Controlling DATA Step Processing
In this module, we dig deeper into the DATA step. You learn how the DATA step processes data behind the scenes. Then you use this knowledge to control when and where the DATA step outputs rows to new tables.
3 Stunden zum Abschließen
14 Videos (Gesamt 24 min), 1 Lektüre, 9 Quiz
14 Videos
Overview15
DATA Step Review30
DATA Step Processing55
DATA Step Processing: Compilation3m
DATA Step Processing: Execution1m
Demo: DATA Step Processing in Action6m
Viewing Execution in the Log1m
Controlling DATA Step Processing1m
Implicit and Explicit Output1m
Sending Output to Multiple Tables26
Demo: Directing Row Output3m
Controlling Column Output30
Demo: Directing Column Output3m
Columns in the PDV36
1 Lektüre
Syntax Review10m
9 praktische Übungen
Activity 1.0110m
Activity 1.0210m
Practice: Using PUTLOG Statements to Examine Execution Steps20m
Activity 1.0310m
Activity 1.0410m
Question 1.055m
Level 1 Practice: Conditionally Creating Multiple Output Tables20m
Level 2 Practice: Conditionally Creating Columns and Output Tables20m
Controlling DATA Step Processing30m
3 Stunden zum Abschließen
Summarizing Data
In this module, you learn new syntax that enables you to alter the default behavior of the DATA step to solve a problem. First you learn to create an accumulating column, or in other words generate a running total. Then you learn to process data in groups, so you can perform an action when each group begins or ends.
3 Stunden zum Abschließen
10 Videos (Gesamt 19 min), 1 Lektüre, 11 Quiz
10 Videos
Overview20
Demo: Creating an Accumulating Column3m
Retaining Values in the PDV1m
Using the Sum Statement58
Answering Questions about Groups42
Processing Sorted Data in Groups1m
Demo: Identifying the First and Last Row in Each Group4m
Subsetting Rows in the Execution Phase2m
Demo: Creating an Accumulating Column within Groups2m
Using Multiple BY Columns1m
1 Lektüre
Syntax Review10m
11 praktische Übungen
Activity 2.0110m
Question 2.025m
Level 1 Practice: Producing a Running Total20m
Level 2 Practice: Producing Multiple Totals20m
Activity 2.0310m
Activity 2.0410m
Activity 2.0510m
Question 2.065m
Level 1 Practice: Generating an Accumulating Column within Groups20m
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20m
Summarizing Data30m
5 Stunden zum Abschließen
Manipulating Data with Functions
In this module, you learn to use some new functions that enable you to manipulate numeric, date, and character values. In addition, you learn to use functions that change a column from one data type to another.
5 Stunden zum Abschließen
24 Videos (Gesamt 40 min), 5 Lektüren, 18 Quiz
24 Videos
Overview15
Review of Functions44
Specifying Columns Lists1m
Using a CALL Routine to Modify Data1m
Using Numeric Functions1m
Demo: Using Numeric Functions2m
SAS Date, Datetime, and Time Values53
Extracting Data from a Datetime Value30
Calculating Date Intervals2m
Shifting Date Values50
Demo: Shifting Date Values Based on an Interval3m
Useful Character Functions53
Extracting Words from a String58
Demo: Using Character Functions to Extract Words from a String3m
Searching for Character Strings51
Replacing Character Strings27
Handling Column Type35
Converting Column Type1m
Converting Character Values to Numeric Values1m
Using a Generic Informat to Read Dates1m
Converting the Type of an Existing Column1m
Converting Numeric Values to Character Values1m
Demo: Using the INPUT Function to Convert Column Types7m
Demo: Using the PUT Function to Convert Column Types3m
5 Lektüren
Using Numeric Functions to Change Precision10m
Removing Characters from a String10m
Identifying Character Positions10m
Building Character Strings10m
Syntax Review10m
18 praktische Übungen
Activity 3.0110m
Activity 3.0210m
Activity 3.0310m
Activity 3.0410m
Question 3.055m
Level 1 Practice: Using the LARGEST and ROUND Functions20m
Level 2 Practice: Working with Date/Time Values20m
Activity 3.0610m
Activity 3.0710m
Activity 3.0810m
Activity 3.0910m
Level 1 Practice: Using the SCAN and PROPCASE Functions20m
Level 2 Practice: Searching for Character Strings20m
Activity 3.1010m
Activity 3.1110m
Question 3.125m
Activity 3.1310m
Manipulating Data with Functions30m
3 Stunden zum Abschließen
Creating and Using Custom Formats
In this module, you learn to create and use custom formats to enhance the way your data is displayed in a table or report.
3 Stunden zum Abschließen
8 Videos (Gesamt 16 min), 1 Lektüre, 10 Quiz
8 Videos
Formatting Data Values29
Creating and Applying a Custom Format2m
Using Ranges1m
Demo: Creating and Using Custom Formats3m
Reading a Table of Values for a Format2m
Demo: Creating Custom Formats from Tables4m
Storing Custom Formats1m
1 Lektüre
Syntax Review10m
10 praktische Übungen
Activity 4.0110m
Activity 4.0210m
Activity 4.0310m
Level 1 Practice: Creating Custom Formats Based on Single Values20m
Level 2 Practice: Creating Custom Formats Based on a Range of Values20m
Activity 4.0410m
Activity 4.0510m
Level 1 Practice: Creating a Custom Format from a Table20m
Level 2 Practice: Using Conditional Processing to Create a Format from a Table20m
Creating and Using Custom Formats30m
Bewertungen
Top-Bewertungen von DOING MORE WITH SAS PROGRAMMING
von RS14. Aug. 2019
This course provided me with the know how needed to write SAS programs. I would definitely recommend this course for folks looking to get an insight on writing or understanding SAS codes.
von VP16. Apr. 2020
Very good course. The instructor is one of the greatest I found when dealing with online courses. It is easy to understand, and you will definitely use it throughout your codes. Take it!
von MK3. März 2019
There is a lot to unpack in this course, and at times I fear my memory might let it slip. It would be nice, if there were exercises, which combined skills learned in previous weeks.
von MM1. Dez. 2019
The course is very informative and interactive. Challenging and exciting, as it balances between theory and practicals. Looking forward to the last course of the series.
Über den SAS Programmer Zertifikat über berufliche Qualifikation
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 Programming Specialist certification exam.
Häufig gestellte Fragen
When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
What is the refund policy?
If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.
Haben Sie weitere Fragen? Besuchen Sie das Hilfe-Center für Teiln..
© 2020 Coursera Inc. Alle Rechte vorbehalten.
