4.8
estrellas
867 calificaciones

96 %

Stacey Syphus

26.433 ya inscrito

Ofrecido Por

SAS

Acerca de este Curso

60.060 vistas recientes

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.

Fechas límite flexibles

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

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Nivel intermedio

Aprox. 25 horas para completar

Inglés (English)

¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?

Prueba Coursera para negocios

Fechas límite flexibles

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

Certificado para compartir

Obtén un certificado al finalizar

100 % en línea

Comienza de inmediato y aprende a tu propio ritmo.

Nivel intermedio

Aprox. 25 horas para completar

Inglés (English)

¿Podría tu empresa beneficiarse de la capacitación de los empleados en las habilidades más demandadas?

Prueba Coursera para negocios

Instructor

Calificación del instructor

4,85/5 (166 calificaciones)

Stacey Syphus

Ofrecido por

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.

Mira cómo los empleados de las mejores empresas dominan las habilidades más demandadas

Obtén más información sobre Coursera para Empresas

Programa - Qué aprenderás en este curso

Calificación del contenido96%(3,386 calificaciones)

Semana

Semana 1

24 minutos para completar

Course Overview and Data Setup

24 minutos para completar

2 videos (Total 1 minutos), 3 lecturas

2 horas para completar

Controlling DATA Step Processing

2 horas para completar

14 videos (Total 23 minutos), 1 lectura, 9 cuestionarios

14 videos

Overview15s

DATA Step Review30s

DATA Step Processing55s

DATA Step Processing: Compilation3m

DATA Step Processing: Execution1m

Demo: DATA Step Processing in Action5m

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 Processing

Semana

Semana 2

3 horas para completar

Summarizing Data

3 horas para completar

10 videos (Total 19 minutos), 1 lectura, 11 cuestionarios

10 videos

Overview20s

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 Data50m

Semana

Semana 3

6 horas para completar

Manipulating Data with Functions

6 horas para completar

24 videos (Total 40 minutos), 5 lecturas, 18 cuestionarios

24 videos

Overview15s

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 Value29s

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 Functions50m

Semana

Semana 4

4 horas para completar

Creating and Using Custom Formats

4 horas para completar

8 videos (Total 16 minutos), 1 lectura, 10 cuestionarios

8 videos

Overview9s

Formatting Data Values28s

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 Formats50m

Semana

Semana 5

3 horas para completar

Combining Tables

3 horas para completar

14 videos (Total 28 minutos), 1 lectura, 10 cuestionarios

14 videos

Overview17s

Concatenating Tables with Matching Columns1m

Demo: Concatenating Tables3m

Handling Column Attributes45s

What is a Merge?1m

Processing a One-to-One Merge2m

Processing a One-To-Many Merge1m

Demo: Merging Tables3m

Merging Tables with Nonmatching Rows2m

Identifying Matches and Nonmatches1m

Demo: Merging Tables with Nonmatching Rows6m

Merging Tables with Matching Column Names1m

Merging Tables without a Common Column1m

DATA Step Merge and PROC SQL Join38s

1 lectura

Syntax Review10m

10 ejercicios de práctica

Activity 5.0110m

Level 1 Practice: Concatenating Like-Structured Tables20m

Level 2 Practice: Concatenating Unlike-Structured Tables20m

Question 5.025m

Activity 5.0310m

Question 5.045m

Activity 5.0510m

Level 1 Practice: Performing a One-to-Many Merge20m

Level 2 Practice: Writing Matches and Nonmatches to Separate Tables20m

Combining Tables50m

Semana

Semana 6

3 horas para completar

Processing Repetitive Code

3 horas para completar

11 videos (Total 25 minutos), 1 lectura, 7 cuestionarios

11 videos

Overview13s

Processing Repetitive Code50s

Iterative DO Loops2m

Demo: Executing an Iterative DO Loop2m

Output Inside and Outside the DO Loop2m

Demo: Using Iterative DO Loops5m

Conditional DO Loops1m

Checking the Condition1m

Demo: Using Conditional DO Loops4m

Combining Iterative and Conditional DO Loops1m

Demo: Combining Iterative and Conditional DO Loops3m

1 lectura

Syntax Review10m

7 ejercicios de práctica

Activity 6.0110m

Level 1 Practice: Using Nested Iterative DO Loops (DATA Step with No SET Statement)20m

Level 2 Practice: Using an Iterative DO Loop (DATA Step with a SET Statement)20m

Activity 6.0210m

Level 1 Practice: Using a Conditional DO Loop20m

Level 2 Practice: Using an Iterative and Conditional DO Loop20m

Processing Repetitive Code50m

Semana

Semana 7

3 horas para completar

Restructuring Tables

3 horas para completar

10 videos (Total 12 minutos), 1 lectura, 9 cuestionarios

10 videos

Overview14s

Understanding Table Structure46s

Restructuring Data36s

Demo: Creating a Narrow Table with the DATA Step2m

Creating a Wide Table with the DATA Step44s

The Transpose Procedure24s

Transposing Values within Groups48s

Demo: Creating a Wide Table with PROC TRANSPOSE4m

Creating a Narrow Table with PROC TRANSPOSE27s

Changing Column Names59s

1 lectura

Syntax Review10m

9 ejercicios de práctica

Question 7.015m

Activity 7.0210m

Level 1 Practice: Restructuring a Table Using the DATA Step: Wide to Narrow20m

Level 2 Practice: Restructuring a Table Using the DATA Step: Narrow to Wide20m

Activity 7.0310m

Activity 7.0410m

Level 1 Practice: Restructuring a Table Using PROC TRANSPOSE: Wide to Narrow20m

Level 2 Practice: Restructuring a Table Using PROC TRANSPOSE: Narrow to Wide20m

Restructuring Tables50m

Reseñas

4.8

150 reseña

5 stars
85,50 %
4 stars
12,65 %
3 stars
1,61 %
1 star
0,23 %

Principales reseñas sobre DOING MORE WITH SAS PROGRAMMING

por GG30 de jun. de 2021

Great step-by-step explanation of all concepts! I have to say that this course is much more difficult than the Introduction course (Getting Started with SAS Programming), but that is to be expected!

por VM9 de sep. de 2021

Excellent course, with short videos that were well made and detailed excercises, demos and activities. I very much enjoyed this course and it's the first coursera course I've actually finished!

por ZN25 de jun. de 2022

It was a good and informative course and I learned from it. However, soemtimes I felt that various compnents of the code were not being explained very well.

por AA17 de sep. de 2019

very professional, with good examples, the only thing it didn't have was MACROS. Other than that it's a perfect course

Ver todas las reseñas

Preguntas Frecuentes

¿Cuándo podré acceder a las lecciones y tareas?
El acceso a las clases y las asignaciones depende del tipo de inscripción que tengas. Si tomas un curso en modo de oyente, verás la mayoría de los materiales del curso en forma gratuita. Para acceder a asignaciones calificadas y obtener un certificado, deberás comprar la experiencia de Certificado, ya sea durante o después de participar como oyente. Si no ves la opción de oyente:
es posible que el curso no ofrezca la opción de participar como oyente. En cambio, puedes intentar con una Prueba gratis o postularte para recibir ayuda económica.
Es posible que el curso ofrezca la opción 'Curso completo, sin certificado'. Esta opción te permite ver todos los materiales del curso, enviar las evaluaciones requeridas y obtener una calificación final. También significa que no podrás comprar una experiencia de Certificado.
¿Qué recibiré si me suscribo a este Certificado?
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 Estudiante.

Desarrolla habilidades para tus empleados e impulsa los resultados de la empresa

Descubre Coursera para Empresas

Doing More with SAS Programming

Acerca de este Curso

Instructor

Stacey Syphus

Ofrecido por

SAS

Programa - Qué aprenderás en este curso

Course Overview and Data Setup

Controlling DATA Step Processing

Summarizing Data

Manipulating Data with Functions

Creating and Using Custom Formats

Combining Tables

Processing Repetitive Code

Restructuring Tables

Reseñas

Principales reseñas sobre DOING MORE WITH SAS PROGRAMMING

Preguntas Frecuentes

Comienza o impulsa tu carrera profesional

Cursos y certificaciones populares

Colecciones y artículos populares

Obtén un título de grado o un certificado en línea

Coursera

Comunidad

Más

Doing More with SAS Programming

Acerca de este Curso

Instructor

Stacey Syphus

Ofrecido por

SAS

Programa - Qué aprenderás en este curso

Course Overview and Data Setup

Controlling DATA Step Processing

Summarizing Data

Manipulating Data with Functions

Creating and Using Custom Formats

Combining Tables

Processing Repetitive Code

Restructuring Tables

Reseñas

Principales reseñas sobre DOING MORE WITH SAS PROGRAMMING

Preguntas Frecuentes

Coursera Footer

Comienza o impulsa tu carrera profesional

Cursos y certificaciones populares

Colecciones y artículos populares

Obtén un título de grado o un certificado en línea

Coursera

Comunidad

Más