Informações sobre o curso

160,827 visualizações recentes

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.

Curso 1 de 3 no

SAS Programmer

100% on-line

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Nível iniciante

Aprox. 25 horas para completar

Sugerido: 15 hours/week...

Inglês

Legendas: Inglês

Curso 1 de 3 no

SAS Programmer

100% on-line

Comece imediatamente e aprenda em seu próprio cronograma.

Prazos flexíveis

Redefinir os prazos de acordo com sua programação.

Nível iniciante

Aprox. 25 horas para completar

Sugerido: 15 hours/week...

Inglês

Legendas: Inglês

Programa - O que você aprenderá com este curso

Semana

1

1 hora para concluir

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 vídeos (Total 16 mín.), 4 leituras

5 videos

Welcome to the Course!1min

Demo: Programming in SAS7min

Practicing in This Course35s

How to Set Up the Course Files in SAS OnDemand for Academics3min

How to Set Up Course Files for SAS University Edition3min

4 leituras

Learner Prerequisites10min

Choosing and Setting Up SAS Software for this Course10min

Need Help Setting Up Software?10min

Using Forums and Getting Help10min

2 horas para concluir

Essentials

In this module you learn how to use SAS programming tools and the fundamentals of SAS program structure and syntax.

7 vídeos (Total 16 mín.), 2 leituras, 3 testes

7 videos

Overview17s

SAS Programming Interfaces56s

Demo: Programming with SAS Studio4min

SAS Program Structure2min

SAS Program Syntax55s

Demo: Understanding SAS Program Syntax2min

Demo: Finding and Resolving Syntax Errors4min

2 leituras

Practice Using SAS Studio20min

Syntax Review10min

3 exercícios práticos

Activity 1.0110min

Activity 1.0210min

Essentials30min

Semana

2

3 horas para concluir

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 vídeos (Total 27 mín.), 1 leitura, 9 testes

14 videos

Overview33s

Types of Data1min

What is a SAS Table?1min

Required Column Attributes for SAS Tables2min

Listing Table and Column Attributes1min

Accessing Data in a Program1min

Using a Library to Read SAS Data3min

Automatic SAS Libraries1min

Demo: Exploring Automatic SAS Libraries3min

Using a Library to Read Other File Types2min

Demo: Using a Library to Read Excel Files3min

Importing Unstructured Data2min

Demo: Importing a Comma-Delimited (CSV) File2min

Importing an Excel File1min

1 leituras

Syntax Review10min

9 exercícios práticos

Question 2.015min

Activity 2.0210min

Activity 2.0310min

Activity 2.04: Create a Library for This Course (Required)10min

Activity 2.0510min

Activity 2.0610min

Level 1 Practice: Importing Excel Data from a Single Worksheet20min

Level 2 Practice: Importing Data from a CSV File20min

Accessing Data30min

Semana

3

5 horas para concluir

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 vídeos (Total 41 mín.), 1 leitura, 14 testes

16 videos

Overview42s

Exploring Data with Procedures1min

Demo: Exploring Data with SAS Procedures6min

Filtering Rows with the WHERE Statement1min

Combining Expressions in a WHERE Statement58s

Demo: Filtering Rows with Basic Operators5min

Using Special WHERE Operators1min

Creating and Using Macro Variables2min

Demo: Filtering Rows Using Macro Variables3min

Formatting Data Values in Results1min

Common Formats for Numeric Values1min

Common Formats for Date Values26s

Demo: Formatting Data Values in Results3min

Sorting Data1min

Identifying and Removing Duplicates1min

Demo: Identifying and Removing Duplicate Values5min

1 leituras

Syntax Review10min

14 exercícios práticos

Activity 3.0110min

Level 1 Practice: Exploring Data with Procedures20min

Level 2 Practice: Using Procedures to Validate Data20min

Activity 3.0210min

Activity 3.0310min

Activity 3.0410min

Level 1 Practice: Filtering Rows in a Listing Report Using Character Data20min

Level 2 Practice: Using Macro Variables to Subset Data in Procedures20min

Activity 3.0510min

Activity 3.0610min

Activity 3.0710min

Level 1 Practice: Sorting Data and Creating an Output Table20min

Level 2 Practice: Sorting Data to Remove Duplicate Rows20min

Exploring and Validating Data30min

Semana

4

5 horas para concluir

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 vídeos (Total 28 mín.), 4 leituras, 16 testes

13 videos

Overview47s

Using the DATA Step to Create a SAS Data Set1min

DATA Step Processing1min

Demo: Working with the DATA Step3min

Demo: Using Expressions to Create New Columns3min

Using Numeric Functions to Create Columns57s

Demo: Using Character Functions2min

Demo: Using Date Functions3min

Demo: Conditional Processing with IF-THEN3min

Conditional Processing with IF-THEN/ELSE1min

Creating Character Columns with the LENGTH Statement1min

Processing Multiple Statements with IF-THEN/DO1min

Demo: Processing Multiple Statements with IF-THEN/DO2min

4 leituras

Common Summary Functions for Creating Columns5min

Common Character Functions for Creating Columns2min

Common Date Functions for Creating Columns2min

Syntax Review10min

16 exercícios práticos

Question 4.015min

Question 4.022min

Activity 4.0310min

Level 1 Practice: Creating a SAS Table20min

Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table20min

Activity 4.0410min

Activity 4.0510min

Activity 4.0610min

Level 1 Practice: Creating New Columns20min

Level 2 Practice: Creating New Columns with Character and Date Functions20min

Activity 4.0710min

Activity 4.0810min

Activity 4.0910min

Level 1 Practice: Processing Statements with IF-THEN/ELSE20min

Level 2 Practice: Processing Statements Conditionally with DO Groups20min

Preparing Data30min

Semana

5

4 horas para concluir

Analyzing and Reporting on Data

In this module, we concentrate on summarizing data by using the SAS procedures that we touched on for data exploration. You also learn how to use titles, column labels, footnotes, and macro variables to enhance your reports and make them more meaningful.

11 vídeos (Total 25 mín.), 2 leituras, 11 testes

11 videos

Overview46s

Using Titles and Footnotes1min

Using Macro Variables and Functions in Titles and Footnotes31s

Applying Temporary Labels to Columns1min

Segmenting Reports39s

Demo: Enhancing Reports4min

Applying Permanent Labels to Columns20s

Demo: Creating Frequency Reports and Graphs7min

Demo: Creating Two-Way Frequency Reports4min

Demo: Creating a Summary Statistics Reports4min

Creating an Output Summary Table22s

2 leituras

Examples of Procedures that Analyze Data5min

Syntax Review10min

11 exercícios práticos

Activity 5.0110min

Activity 5.0210min

Activity 5.0310min

Activity 5.0410min

Level 1 Practice: Creating One-Way Frequency Reports20min

Level 2 Practice: Creating Two-Way Frequency Reports20min

Activity 5.0510min

Activity 5.0610min

Level 1 Practice: Producing a Descriptive Statistics Report20min

Level 2 Practice: Creating an Output Table with Custom Columns20min

Analyzing and Reporting on Data30min

Semana

6

2 horas para concluir

Exporting Results

In this module, you learn to export SAS tables and results to Excel, Microsoft Word, and PDF files.

8 vídeos (Total 18 mín.), 3 leituras, 6 testes

8 videos

Overview28s

Exporting Data1min

Demo: Exporting Data to an Excel Workbook3min

Using the SAS Output Delivery System1min

Exporting Results to CSV26s

Demo: Exporting Results to Excel5min

Exporting Results to PowerPoint and Microsoft Word30s

Demo: Exporting Results to PDF4min

3 leituras

Create a Macro Variable (REQUIRED)10min

Activity: Create PowerPoint and RTF Files1min

Syntax Review10min

6 exercícios práticos

Activity 6.0110min

Activity 6.0210min

Activity 6.0310min

Level 1 Practice: Creating an Excel File Using ODS EXCEL20min

Level 2 Practice: Creating a Document with ODS RTF20min

Exporting Results30min

2 horas para concluir

Using SQL in SAS

In this module, you learn to use the SQL procedure to read and filter data. You also learn to create and join tables by using SQL.

10 vídeos (Total 17 mín.), 1 leitura, 5 testes

10 videos

Overview35s

SQL and SAS1min

PROC SQL Syntax1min

Filtering and Sorting Output1min

Demo: Reading and Filtering Data with SQL4min

Creating and Deleting Tables in SQL32s

Creating Inner Joins in SQL2min

Demo: Joining Tables with PROC SQL4min

Using Table Aliases26s

You've Finished the Course!25s

1 leituras

Syntax Review10min

5 exercícios práticos

Activity 7.0110min

Activity 7.0210min

Activity 7.0310min

Activity 7.0410min

Using SQL in SAS30min

Instrutores

Stacey Syphus

Senior Manager

Education

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 para este certificado?
Quando você se inscreve em um curso, ganha acesso a todos os cursos no certificado e obtém um certificado quando completar o trabalho. Seu certificado eletrônico pode ser adicionado à sua página de Participações, de onde você pode imprimi-lo ou adicioná-lo ao seu perfil no LinkedIn. Se quiser apenas ler e assistir o conteúdo do curso, pode participar como ouvinte sem custo.
Qual é a política de reembolso?

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

Getting Started with SAS Programming

Curso 1 de 3 no

100% on-line

Prazos flexíveis

Nível iniciante

Aprox. 25 horas para completar

Inglês

Curso 1 de 3 no

100% on-line

Prazos flexíveis

Nível iniciante

Aprox. 25 horas para completar

Inglês

Programa - O que você aprenderá com este curso

Course Overview and Data Setup

Essentials

Accessing Data

Exploring and Validating Data

Preparing Data

Analyzing and Reporting on Data

Exporting Results

Using SQL in SAS

23%

28%

11%

Principais avaliações do Getting Started with SAS Programming

Instrutores

Stacey Syphus

Sobre SAS

Sobre Certificado Profissional SAS Programmer

Perguntas Frequentes – FAQ