Informações sobre o curso
5.0
1 classificações
Programa de cursos integrados
100% online

100% online

Comece imediatamente e aprenda em seu próprio cronograma.
Prazos flexíveis

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.
Nível intermediário

Nível intermediário

Horas para completar

Aprox. 27 horas para completar

Sugerido: 10 hours/week...
Idiomas disponíveis

Inglês

Legendas: Inglês
Programa de cursos integrados
100% online

100% online

Comece imediatamente e aprenda em seu próprio cronograma.
Prazos flexíveis

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.
Nível intermediário

Nível intermediário

Horas para completar

Aprox. 27 horas para completar

Sugerido: 10 hours/week...
Idiomas disponíveis

Inglês

Legendas: Inglês

Programa - O que você aprenderá com este curso

Semana
1
Horas para completar
1 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....
Reading
2 vídeos (total de (Total 1 mín.) min), 4 leituras
Video2 videos
Practicing in This Course35s
Reading4 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
Horas para completar
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....
Reading
14 vídeos (total de (Total 24 mín.) min), 1 leitura, 9 testes
Video14 videos
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
Reading1 leituras
Syntax Review10min
Quiz9 exercícios práticos
Activity10min
Activity10min
Practice: Using PUTLOG Statements to Examine Execution Steps20min
Activity10min
Activity10min
Question5min
Level 1 Practice: Conditionally Creating Multiple Output Tables20min
Level 2 Practice: Conditionally Creating Columns and Output Tables20min
Controlling DATA Step Processing30min
Semana
2
Horas para completar
3 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. ...
Reading
10 vídeos (total de (Total 19 mín.) min), 1 leitura, 11 testes
Video10 videos
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
Reading1 leituras
Syntax Review10min
Quiz11 exercícios práticos
Activity10min
Question5min
Level 1 Practice: Producing a Running Total20min
Level 2 Practice: Producing Multiple Totals20min
Activity10min
Activity10min
Activity10min
Question5min
Level 1 Practice: Generating an Accumulating Column within Groups20min
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20min
Summarizing Data30min
Semana
3
Horas para completar
5 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....
Reading
24 vídeos (total de (Total 40 mín.) min), 5 leituras, 18 testes
Video24 videos
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
Reading5 leituras
Using Numeric Functions to Change Precision10min
Removing Characters from a String10min
Identifying Character Positions10min
Building Character Strings10min
Syntax Review10min
Quiz18 exercícios práticos
Activity10min
Activity10min
Activity10min
Activity10min
Question5min
Level 1 Practice: Using the LARGEST and ROUND Functions20min
Level 2 Practice: Working with Date/Time Values20min
Activity10min
Activity10min
Activity10min
Activity10min
Level 1 Practice: Using the SCAN and PROPCASE Functions20min
Level 2 Practice: Searching for Character Strings20min
Activity10min
Activity10min
Question5min
Activity10min
Manipulating Data with Functions30min
Semana
4
Horas para completar
3 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....
Reading
8 vídeos (total de (Total 16 mín.) min), 1 leitura, 10 testes
Video8 videos
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
Reading1 leituras
Syntax Review10min
Quiz10 exercícios práticos
Activity10min
Activity10min
Activity10min
Level 1 Practice: Creating Custom Formats Based on Single Values20min
Level 2 Practice: Creating Custom Formats Based on a Range of Values20min
Activity10min
Activity10min
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

Instrutores

Avatar

Stacey Syphus

Senior Manager
Education

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....
SAS® Programming

Perguntas Frequentes – FAQ

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, 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.

Mais dúvidas? Visite o Central de Ajuda ao Aprendiz.