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.
Este curso faz parte do Programa de cursos integrados SAS® Programming
Getting Started with SAS® Programming
oferecido por
Programa - O que você aprenderá com este curso
Semana
11 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 de (Total 16 mín.) min), 4 leituras
5 videos
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 de (Total 16 mín.) min), 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
23 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 de (Total 27 mín.) min), 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
35 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 de (Total 41 mín.) min), 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
45 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 de (Total 28 mín.) min), 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
33%
comecei uma nova carreira após concluir estes cursos
33%
consegui um benefício significativo de carreira com este curso
Melhores avaliações
This course offers a solid foundation to anyone who is interested in beginning to use SAS. I have found the demos, activites and practices to be fairly easy yet still required me to use my brain.
I like the learning structure with demo and exercises. It takes only few days to finish, friendly to beginner and you will have great basic concepts about sas.
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.
