Acerca de este Curso
58,564 vistas recientes

Curso 2 de 3 en

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel intermedio

Aprox. 25 horas para completar

Sugerido: 17 hours/week...

Inglés (English)

Subtítulos: Inglés (English)

Curso 2 de 3 en

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Fechas límite flexibles

Restablece las fechas límite en función de tus horarios.

Nivel intermedio

Aprox. 25 horas para completar

Sugerido: 17 hours/week...

Inglés (English)

Subtítulos: Inglés (English)

Programa - Qué aprenderás en este curso

Semana
1
1 hora para completar

Course Overview and Data Setup

2 videos (Total 1 minutos), 4 lecturas
2 videos
Practicing in This Course35s
4 lecturas
Learner Prerequisites10m
Choosing and Setting Up SAS Software for this Course10m
Follow These Instructions to Set Up Data for This Course (REQUIRED)30m
Using Forums and Getting Help10m
3 horas para completar

Controlling DATA Step Processing

14 videos (Total 24 minutos), 1 lectura, 9 cuestionarios
14 videos
DATA Step Review30s
DATA Step Processing55s
DATA Step Processing: Compilation3m
DATA Step Processing: Execution1m
Demo: DATA Step Processing in Action6m
Viewing Execution in the Log1m
Controlling DATA Step Processing1m
Implicit and Explicit Output1m
Sending Output to Multiple Tables26s
Demo: Directing Row Output3m
Controlling Column Output30s
Demo: Directing Column Output3m
Columns in the PDV36s
1 lectura
Syntax Review10m
9 ejercicios de práctica
Activity 1.0110m
Activity 1.0210m
Practice: Using PUTLOG Statements to Examine Execution Steps20m
Activity 1.0310m
Activity 1.0410m
Question 1.055m
Level 1 Practice: Conditionally Creating Multiple Output Tables20m
Level 2 Practice: Conditionally Creating Columns and Output Tables20m
Controlling DATA Step Processing30m
Semana
2
3 horas para completar

Summarizing Data

10 videos (Total 19 minutos), 1 lectura, 11 cuestionarios
10 videos
Demo: Creating an Accumulating Column3m
Retaining Values in the PDV1m
Using the Sum Statement58s
Answering Questions about Groups42s
Processing Sorted Data in Groups1m
Demo: Identifying the First and Last Row in Each Group4m
Subsetting Rows in the Execution Phase2m
Demo: Creating an Accumulating Column within Groups2m
Using Multiple BY Columns1m
1 lectura
Syntax Review10m
11 ejercicios de práctica
Activity 2.0110m
Question 2.025m
Level 1 Practice: Producing a Running Total20m
Level 2 Practice: Producing Multiple Totals20m
Activity 2.0310m
Activity 2.0410m
Activity 2.0510m
Question 2.065m
Level 1 Practice: Generating an Accumulating Column within Groups20m
Level 2 Practice: Generating an Accumulating Column within Multiple Groups20m
Summarizing Data30m
Semana
3
5 horas para completar

Manipulating Data with Functions

24 videos (Total 40 minutos), 5 lecturas, 18 cuestionarios
24 videos
Review of Functions44s
Specifying Columns Lists1m
Using a CALL Routine to Modify Data1m
Using Numeric Functions1m
Demo: Using Numeric Functions2m
SAS Date, Datetime, and Time Values53s
Extracting Data from a Datetime Value30s
Calculating Date Intervals2m
Shifting Date Values50s
Demo: Shifting Date Values Based on an Interval3m
Useful Character Functions53s
Extracting Words from a String58s
Demo: Using Character Functions to Extract Words from a String3m
Searching for Character Strings51s
Replacing Character Strings27s
Handling Column Type35s
Converting Column Type1m
Converting Character Values to Numeric Values1m
Using a Generic Informat to Read Dates1m
Converting the Type of an Existing Column1m
Converting Numeric Values to Character Values1m
Demo: Using the INPUT Function to Convert Column Types7m
Demo: Using the PUT Function to Convert Column Types3m
5 lecturas
Using Numeric Functions to Change Precision10m
Removing Characters from a String10m
Identifying Character Positions10m
Building Character Strings10m
Syntax Review10m
18 ejercicios de práctica
Activity 3.0110m
Activity 3.0210m
Activity 3.0310m
Activity 3.0410m
Question 3.055m
Level 1 Practice: Using the LARGEST and ROUND Functions20m
Level 2 Practice: Working with Date/Time Values20m
Activity 3.0610m
Activity 3.0710m
Activity 3.0810m
Activity 3.0910m
Level 1 Practice: Using the SCAN and PROPCASE Functions20m
Level 2 Practice: Searching for Character Strings20m
Activity 3.1010m
Activity 3.1110m
Question 3.125m
Activity 3.1310m
Manipulating Data with Functions30m
Semana
4
3 horas para completar

Creating and Using Custom Formats

8 videos (Total 16 minutos), 1 lectura, 10 cuestionarios
8 videos
Formatting Data Values29s
Creating and Applying a Custom Format2m
Using Ranges1m
Demo: Creating and Using Custom Formats3m
Reading a Table of Values for a Format2m
Demo: Creating Custom Formats from Tables4m
Storing Custom Formats1m
1 lectura
Syntax Review10m
10 ejercicios de práctica
Activity 4.0110m
Activity 4.0210m
Activity 4.0310m
Level 1 Practice: Creating Custom Formats Based on Single Values20m
Level 2 Practice: Creating Custom Formats Based on a Range of Values20m
Activity 4.0410m
Activity 4.0510m
Level 1 Practice: Creating a Custom Format from a Table20m
Level 2 Practice: Using Conditional Processing to Create a Format from a Table20m
Creating and Using Custom Formats30m
4.8
30 revisionesChevron Right

33%

consiguió un beneficio tangible en su carrera profesional gracias a este curso

50%

consiguió un aumento de sueldo o ascenso

Principales revisiones sobre Doing More with SAS Programming

por RSAug 15th 2019

This course provided me with the know how needed to write SAS programs. I would definitely recommend this course for folks looking to get an insight on writing or understanding SAS codes.

por HRJul 11th 2019

Great second part of the 3 part SAS course. TIP: Print the syntax notes at the end of each week. They will help you take notes and keep track of what you are learning.

Instructor

Avatar

Stacey Syphus

Senior Manager
Education

Acerca de 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....

Acerca de Certificado profesional de SAS Programmer

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 Programmer

Preguntas Frecuentes

  • Una vez que te inscribes para obtener un Certificado, tendrás acceso a todos los videos, cuestionarios y tareas de programación (si corresponde). Las tareas calificadas por compañeros solo pueden enviarse y revisarse una vez que haya comenzado tu sesión. Si eliges explorar el curso sin comprarlo, es posible que no puedas acceder a determinadas tareas.

  • Cuando te inscribes en un curso, obtienes acceso a todos los cursos del Certificado y te darán un certificado cuando completes el trabajo. Se añadirá tu Certificado electrónico a la página Logros. Desde allí, puedes imprimir tu Certificado o añadirlo a tu perfil de LinkedIn. Si solo quieres leer y visualizar el contenido del curso, puedes auditar el curso sin costo.

¿Tienes más preguntas? Visita el Centro de Ayuda al Alumno.