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.
In this course you learn how to 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, and restructure tables. This course addresses Base SAS software.
Before attending this course, you should be able to write DATA step code to access data, subset rows and columns, compute new columns, and process data conditionally. You should also be able to sort tables using the SORT procedure and
apply SAS formats.
Este curso faz parte do Programa de cursos integrados SAS® Programming
Doing More with SAS® Programming
oferecido por
1,603 já inscritos!
Programa - O que você aprenderá com este curso
Semana
11 hora para concluir
Course Overview and Data Setup
In this module you get an overview of what you learn in this course and your set up for software and the data you use for activities and practices in the course.
2 vídeos (total de (Total 1 mín.) min), 4 leituras
4 leituras
Learner Prerequisites10min
Choosing and Setting Up SAS Software for this Course10min
Follow These Instructions to Set Up Data for This Course (REQUIRED)30min
Using Forums and Getting Help10min
3 horas para concluir
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.
14 vídeos (total de (Total 24 mín.) min), 1 leitura, 9 testes
14 videos
Overview15s
DATA Step Review30s
DATA Step Processing55s
DATA Step Processing: Compilation3min
DATA Step Processing: Execution1min
Demo: DATA Step Processing in Action6min
Viewing Execution in the Log1min
Controlling DATA Step Processing1min
Implicit and Explicit Output1min
Sending Output to Multiple Tables26s
Demo: Directing Row Output3min
Controlling Column Output30s
Demo: Directing Column Output3min
Columns in the PDV36s
1 leituras
Syntax Review10min
9 exercícios práticos
Activity 1.0110min
Activity 1.0210min
Practice: Using PUTLOG Statements to Examine Execution Steps20min
Activity 1.0310min
Activity 1.0410min
Question 1.055min
Level 1 Practice: Conditionally Creating Multiple Output Tables20min
Level 2 Practice: Conditionally Creating Columns and Output Tables20min
Controlling DATA Step Processing30min
Semana
23 horas para concluir
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.
10 vídeos (total de (Total 19 mín.) min), 1 leitura, 11 testes
10 videos
Overview20s
Demo: Creating an Accumulating Column3min
Retaining Values in the PDV1min
Using the Sum Statement58s
Answering Questions about Groups42s
Processing Sorted Data in Groups1min
Demo: Identifying the First and Last Row in Each Group4min
Subsetting Rows in the Execution Phase2min
Demo: Creating an Accumulating Column within Groups2min
Using Multiple BY Columns1min
1 leituras
Syntax Review10min
11 exercícios práticos
Activity 2.0110min
Question 2.025min
Level 1 Practice: Producing a Running Total20min
Level 2 Practice: Producing Multiple Totals20min
Activity 2.0310min
Activity 2.0410min
Activity 2.0510min
Question 2.065min
Level 1 Practice: Generating an Accumulating Column within Groups20min
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20min
Summarizing Data30min
Semana
35 horas para concluir
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.
24 vídeos (total de (Total 40 mín.) min), 5 leituras, 18 testes
24 videos
Overview15s
Review of Functions44s
Specifying Columns Lists1min
Using a CALL Routine to Modify Data1min
Using Numeric Functions1min
Demo: Using Numeric Functions2min
SAS Date, Datetime, and Time Values53s
Extracting Data from a Datetime Value30s
Calculating Date Intervals2min
Shifting Date Values50s
Demo: Shifting Date Values Based on an Interval3min
Useful Character Functions53s
Extracting Words from a String58s
Demo: Using Character Functions to Extract Words from a String3min
Searching for Character Strings51s
Replacing Character Strings27s
Handling Column Type35s
Converting Column Type1min
Converting Character Values to Numeric Values1min
Using a Generic Informat to Read Dates1min
Converting the Type of an Existing Column1min
Converting Numeric Values to Character Values1min
Demo: Using the INPUT Function to Convert Column Types7min
Demo: Using the PUT Function to Convert Column Types3min
5 leituras
Using Numeric Functions to Change Precision10min
Removing Characters from a String10min
Identifying Character Positions10min
Building Character Strings10min
Syntax Review10min
18 exercícios práticos
Activity 3.0110min
Activity 3.0210min
Activity 3.0310min
Activity 3.0410min
Question 3.055min
Level 1 Practice: Using the LARGEST and ROUND Functions20min
Level 2 Practice: Working with Date/Time Values20min
Activity 3.0610min
Activity 3.0710min
Activity 3.0810min
Activity 3.0910min
Level 1 Practice: Using the SCAN and PROPCASE Functions20min
Level 2 Practice: Searching for Character Strings20min
Activity 3.1010min
Activity 3.1110min
Question 3.125min
Activity 3.1310min
Manipulating Data with Functions30min
Semana
43 horas para concluir
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.
8 vídeos (total de (Total 16 mín.) min), 1 leitura, 10 testes
8 videos
Overview9s
Formatting Data Values29s
Creating and Applying a Custom Format2min
Using Ranges1min
Demo: Creating and Using Custom Formats3min
Reading a Table of Values for a Format2min
Demo: Creating Custom Formats from Tables4min
Storing Custom Formats1min
1 leituras
Syntax Review10min
10 exercícios práticos
Activity 4.0110min
Activity 4.0210min
Activity 4.0310min
Level 1 Practice: Creating Custom Formats Based on Single Values20min
Level 2 Practice: Creating Custom Formats Based on a Range of Values20min
Activity 4.0410min
Activity 4.0510min
Level 1 Practice: Creating a Custom Format from a Table20min
Level 2 Practice: Using Conditional Processing to Create a Format from a Table20min
Creating and Using Custom Formats30min
Semana
53 horas para concluir
Combining Tables
In this module, we take a comprehensive look at combining tables by using the DATA step. You learn to concatenate tables, merge tables, and identify matching and nonmatching rows.
14 vídeos (total de (Total 28 mín.) min), 1 leitura, 10 testes
14 videos
Overview17s
Concatenating Tables with Matching Columns1min
Demo: Concatenating Tables3min
Handling Column Attributes45s
What is a Merge?1min
Processing a One-to-One Merge2min
Processing a One-To-Many Merge1min
Demo: Merging Tables3min
Merging Tables with Nonmatching Rows2min
Identifying Matches and Nonmatches1min
Demo: Merging Tables with Nonmatching Rows6min
Merging Tables with Matching Column Names1min
Merging Tables without a Common Column1min
DATA Step Merge and PROC SQL Join38s
1 leituras
Syntax Review10min
10 exercícios práticos
Activity 5.0110min
Level 1 Practice: Concatenating Like-Structured Tables20min
Level 2 Practice: Concatenating Unlike-Structured Tables20min
Question 5.025min
Activity 5.0310min
Question 5.045min
Activity 5.0510min
Level 1 Practice: Performing a One-to-Many Merge20min
Level 2 Practice: Writing Matches and Nonmatches to Separate Tables20min
Combining Tables30min
Semana
63 horas para concluir
Processing Repetitive Code
In this module, you learn to save time by taking advantage of iterative processing with DO loops. First you learn to create an iterative DO Loop, then you learn to create conditional DO loops.
11 vídeos (total de (Total 25 mín.) min), 1 leitura, 7 testes
11 videos
Overview13s
Processing Repetitive Code50s
Iterative DO Loops2min
Demo: Executing an Iterative DO Loop2min
Output Inside and Outside the DO Loop2min
Demo: Using Iterative DO Loops5min
Conditional DO Loops1min
Checking the Condition1min
Demo: Using Conditional DO Loops4min
Combining Iterative and Conditional DO Loops1min
Demo: Combining Iterative and Conditional DO Loops3min
1 leituras
Syntax Review10min
7 exercícios práticos
Activity 6.0110min
Level 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)20min
Level 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement)20min
Activity 6.0210min
Level 1 Practice: Using a Conditional DO Loop20min
Level 2 Practice: Using an Iterative and Conditional DO Loop20min
Processing Repetitive Code30min
Semana
73 horas para concluir
Restructuring Tables
In this module, you learn techniques that can be used to transpose or restructure a table. First you learn to restructure data with the DATA step. Then you learn to restructure data by using the TRANSPOSE procedure.
10 vídeos (total de (Total 12 mín.) min), 1 leitura, 9 testes
10 videos
Overview14s
Understanding Table Structure46s
Restructuring Data36s
Demo: Creating a Narrow Table with the DATA Step3min
Creating a Wide Table with the DATA Step44s
The Transpose Procedure24s
Transposing Values within Groups48s
Demo: Creating a Wide Table with PROC TRANSPOSE4min
Creating a Narrow Table with PROC TRANSPOSE27s
Changing Column Names59s
1 leituras
Syntax Review10min
9 exercícios práticos
Question 7.015min
Activity 7.0210min
Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow20min
Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20min
Activity 7.0310min
Activity 7.0410min
Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow20min
Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide20min
Restructuring Tables30min
Melhores avaliações
I love the way the course content builds on itself in such a systematic way, and welcome the variety of exercises and practices.
e\n\nx\n\nc\n\ne\n\nl\n\nl\n\ne\n\nn\n\nt\n\nh\n\na\n\nn\n\nd\n\ns\n\no\n\nn\n\ne\n\nx\n\np\n\ne\n\nr\n\nI\n\ne\n\nn\n\nc\n\ne
Instrutores
Stacey Syphus
Senior ManagerEducation
Sobre 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.
Sobre o Programa de cursos integrados 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.
Perguntas Frequentes – FAQ
Quando terei acesso às palestras e às tarefas?
Ao se inscrever para um Certificado, você terá acesso a todos os vídeos, testes e tarefas de programação (se aplicável). Tarefas avaliadas pelos colegas apenas podem ser enviadas e avaliadas após o início da sessão. Caso escolha explorar o curso sem adquiri-lo, talvez você não consiga acessar certas tarefas.
O que recebo ao me inscrever nesta Especialização?
Quando você se inscreve no curso, tem acesso a todos os cursos na Especialização e pode obter um certificado quando concluir o trabalho. Seu Certificado eletrônico será adicionado à sua página de Participações e você poderá imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, você poderá frequentá-lo como ouvinte sem custo.
Qual é a política de reembolso?
Existe algum auxílio financeiro disponível?
Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.
O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.
© 2019 Coursera Inc. Todos os direitos reservados.
