In this course, you learn advanced techniques within the DATA step and procedures to manipulate data.
Ce cours fait partie de la Nombre de SAS Advanced Programmer Certificat Professionnel
Offert par
À propos de ce cours
14,810 consultations récentes
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 3 sur 3 dans le
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Niveau intermédiaire
Approx. 17 heures pour terminer
Anglais
Sous-titres : Anglais
Enseignant
Certificat partageable
Obtenez un Certificat lorsque vous terminez
100 % en ligne
Commencez dès maintenant et apprenez aux horaires qui vous conviennent.
Cours 3 sur 3 dans le
Dates limites flexibles
Réinitialisez les dates limites selon votre disponibilité.
Niveau intermédiaire
Approx. 17 heures pour terminer
Anglais
Sous-titres : Anglais
Offert par
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.
Programme du cours : ce que vous apprendrez dans ce cours
1 heure pour terminer
Course Overview, Review, and Data Setup
In this module, you'll set up software and data for this course. Then you'll review the concepts of SAS DATA step processing and how to process data sets.
1 heure pour terminer
5 vidéos (Total 15 min), 4 lectures, 1 quiz
5 vidéos
Practicing in the Course2 min
DATA Step Processing3 min
Processing a Data Set2 min
Demo: Reviewing DATA Step Syntax and Processing6 min
4 lectures
Learner Prerequisites10 min
Using Forums and Getting Help10 min
Access SAS Software for this Course10 min
Set Up Data for This Course 30 min
1 exercice pour s'entraîner
Activity 1.0110 min
4 heures pour terminer
Using Advanced Functions
In this module, you'll use advanced functions to compare data between multiple rows in a SAS table, find and count substrings within a column, and clean and standardize data.
4 heures pour terminer
16 vidéos (Total 36 min), 1 lecture, 12 quiz
16 vidéos
Overview37s
Using Functions in SAS2 min
Using the LAG Function2 min
Demo: Retrieving Previous Values with the LAG Function2 min
Calculating a Moving Average49s
Best Practice for Calculating a Moving Average37s
Using COUNT Functions2 min
Using FIND Functions1 min
Demo: Counting and Finding Words with Character Functions3 min
What are Perl Regular Expressions?1 min
What are Metacharacters?3 min
PRXPARSE and PRXMATCH Functions3 min
Demo: Validating Data with the PRXMATCH Function4 min
PRXCHANGE Function2 min
Capture Buffers2 min
Demo: Standardizing Data with the PRXCHANGE Function3 min
1 lecture
Metacharacter Examples10 min
12 exercices pour s'entraîner
Activity 2.0110 min
Activity 2.0210 min
Activity 2.0310 min
Activity 2.0410 min
Practice Level 1: Using the LAG Function20 min
Practice Level 2: Using the COUNT and FINDW Functions20 min
Question 2.055 min
Activity 2.0610 min
Activity 2.0710 min
Practice Level 1: Using the PRXMATCH and PRXCHANGE Functions20 min
Practice Level 2: Using the PRXCHANGE Function with Capture Buffers20 min
Using Advanced Functions Review30 min
3 heures pour terminer
Defining and Processing Arrays
In this module, you'll learn how to use arrays to simplify your code. You'll use arrays to process repetitive code, rotate data, and perform table lookups.
3 heures pour terminer
18 vidéos (Total 35 min), 1 lecture, 11 quiz
18 vidéos
Overview25s
Processing Repetitive Code1 min
Using an Array2 min
Referencing an Array in a DO Loop1 min
Unknown Number of Array Elements57s
Creating Numeric Columns with an Array1 min
Specifying Lower and Upper Bounds1 min
Demo: Processing One-Dimensional Arrays: Part 13 min
Rotating Data1 min
Specifying Initial Values for Array Elements1 min
Creating Character Columns with an Array56s
Demo: Processing One-Dimensional Arrays: Part 22 min
Two-Dimensional Arrays28s
Performing a Table Lookup4 min
Demo: Processing Two-Dimensional Arrays: Part 13 min
Specifying Initial Values for Two-Dimensional Array Elements1 min
Loading a Two-Dimensional Array from a Table1 min
Demo: Processing Two-Dimensional Arrays: Part 22 min
1 lecture
Array Advantages and Disadvantages10 min
11 exercices pour s'entraîner
Activity 3.0110 min
Activity 3.0210 min
Activity 3.0310 min
Question 3.0410 min
Practice Level 1: Using One-Dimensional Arrays on Numeric Data20 min
Practice Level 2: Using One-Dimensional Arrays on Character Data20 min
Question 3.055 min
Activity 3.0610 min
Practice Level 1: Using a Two-Dimensional Array Based on Initial Values20 min
Practice Level 2: Using a Two-Dimensional Array Based on Loading a Table20 min
Defining and Processing Arrays Review30 min
4 heures pour terminer
Defining and Processing Hash Objects
In this module, you'll learn how to declare a hash object, instantiate or create an instance of the object, and initialize its lookup keys and data. You'll use the hash object to store and retrieve data, create an output table from the data in the hash object, and create a hash iterator object to process the data in a particular order.
4 heures pour terminer
19 vidéos (Total 30 min), 3 lectures, 10 quiz
19 vidéos
Overview43s
Performing a Table Lookup: Example 11 min
What is a Hash Object?1 min
Hash Object Process: Example 11 min
Declaring a Hash Object1 min
Using Hash Object Methods2 min
Demo: Declaring and Defining a Hash Object2 min
Performing a Table Lookup: Example 227s
FIND Method1 min
KEY Arguments50s
Demo: Performing a Table Lookup with the FIND Method3 min
Adding Data to a Hash Object1 min
Saving a Hash Object1 min
Demo: Creating a Table with the ADD and OUTPUT Methods3 min
Unique and Duplicate Key Components35s
What is a Hash Iterator Object?1 min
Creating the Hash Object and Hash Iterator Object1 min
Hash Iterator Object Methods46s
Demo: Reading Data in Forward and Reverse Direction2 min
3 lectures
Specifying the DATASET Argument10 min
Using Multiple Method Statements10 min
Hash Object Advantages and Disadvantages10 min
10 exercices pour s'entraîner
Activity 4.0110 min
Activity 4.0210 min
Practice Level 1: Performing a Table Lookup Using One Key20 min
Practice Level 2: Performing a Table Lookup Using Three Keys20 min
Activity 4.0310 min
Practice Level 1: Creating a Sorted Table from a Hash Object20 min
Practice Level 2: Eliminating a PROC SORT step by Creating a Sorted Table from a Hash Object20 min
Practice Level 1: Reading Data in Forward and Reverse Direction20 min
Practice Level 2: Reading Data in Forward and Reverse Directions20 min
Defining and Processing Hash Objects Review30 min
Avis
Meilleurs avis pour ADVANCED SAS PROGRAMMING TECHNIQUES
par MS14 nov. 2020
The Course goes through detailed examples and practices to clarify the techniques and concepts, useful and efficient.
par TG27 déc. 2020
Great course to deepen your practical skills in this field. Thank you SAS and Cousresa.org team for this opportunity.
par SW18 oct. 2020
Passed SAS adv exam after taking this course. It's very useful.
À propos du Nombre de SAS Advanced Programmer Certificat Professionnel
When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.
Foire Aux Questions
Puis-je prévisualiser un cours avant de m'inscrire ?
À quoi ai-je droit si je m'inscris ?
Quand recevrai-je mon Certificat de Cours ?
Pourquoi ne puis-je pas assister à ce cours en auditeur libre ?
D'autres questions ? Visitez le Centre d'Aide pour les Etudiants.
