Este curso forma parte de Programa especializado: Distributed Programming in SAS® Viya® for Data Analysts

Peter Styliadis +1 instructores más

Ofrecido Por

Programa especializado: Distributed Programming in SAS® Viya® for Data AnalystsSAS

Acerca de este Curso

3467 vistas recientes

Welcome to the CASL Programming for Distributed Computing in SAS Viya course. SAS Viya is an AI, analytic and data management platform running on a scalable, distributed, cloud-native architecture. 
In this course you will learn how how to use the native CAS programming language (CASL) to leverage SAS Cloud Analytics Services (CAS), the high-performance, in-memory analytics and distributed computing engine in SAS Viya . You will learn how to use CASL to access, explore, prepare, analyze, and summarize data in the CAS server's massively parallel processing environment.

This is an advanced course, intended for learners with at least one year of programming experience with a modern language: (SAS, R, Python, SQL, and so on), and at least one year of experience working with data.  To be successful in this course,  you should have a general understanding of fundamental computer programming concepts and the data analytics lifecycle.

By the end of the course, you will be able to:
- Understand and use various SAS Viya servers.
- Connect to the CAS server to access and manage data. 
- Use CASL to explore, prepare and analyze data.
- Create reports and visualizations using SAS Viya.

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.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 2 de 3 en

Programa especializado: Distributed Programming in SAS® Viya® for Data Analysts

Nivel avanzado

You should have an understanding of fundamental computer programming concepts, and at least one year of programming and data analysis experience.

Aprox. 29 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

Qué aprenderás

Connect to the CAS server to access and manage data.
Use CASL to prepare and analyze data.
Create reports and visualizations using SAS Viya.

Habilidades que obtendrás

SAS Studio
Data Manipulation
CASL
Data Analysis
SAS Viya

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.

Laboratorios de Coursera

Incluye proyectos de aprendizaje prácticos.

Obtén más información sobre los laboratorios de Coursera

Curso 2 de 3 en

Programa especializado: Distributed Programming in SAS® Viya® for Data Analysts

Nivel avanzado

You should have an understanding of fundamental computer programming concepts, and at least one year of programming and data analysis experience.

Aprox. 29 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

Instructores

Peter Styliadis

Senior Technical Training Consultant

SAS Education

13.987 alumnos

5 cursos

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

Semana1

Semana 1

1 hora para completar

Course Overview and Logistics

1 hora para completar

2 videos (Total 3 minutos), 3 lecturas, 1 cuestionario

1 hora para completar

Introduction to SAS Viya and CAS

1 hora para completar

8 videos (Total 13 minutos)

Semana2

Semana 2

5 horas para completar

CAS Language (CASL) Fundamentals

5 horas para completar

27 videos (Total 65 minutos), 1 lectura, 15 cuestionarios

27 videos

Module Overview1mSubmitting Code to CAS58sCASL Programming Components4mRunning CASL Code from SAS37sIntroduction to CAS Actions32sCAS Action Sets40sCAS Actions Syntax1mDemo: Executing CAS Actions2mCreating Numeric and String Variables52sWorking With Numeric Data1mWorking With String Data2mDemo: Creating and Using String and Numeric Variables8mIntroduction to CASL Arrays2mAccessing Array Elements1mUsing an Array in a CAS Action1mIterating Through an Array2mDemo: Using an Array with CAS Actions3mArray Operators3mUsing Array Functions1mIntroduction to CASL Dictionaries1mCreating a Dictionary in CASL3mAccessing and Modifying a Dictionary1mUsing a Dictionary in a CAS Action2mDemo: Using Dictionaries with CAS Actions6mCAS Actions Return a Dictionary1mDemo: Working with CAS Action Results5mIterating Through a Dictionary1m

1 lectura

Summary of CAS Language (CASL) Fundamentals30m

14 ejercicios de práctica

Activity: Use the CAS API15mActivity: Find the EXISTS Built-In Function15mActivity: Find the loadTable CAS Action15mActivity: Create and Print a CASL Variable15mActivity: Use Variables in CAS Actions15mActivity: Create and Access an Array15mActivity: Iterate Over an Array15mActivity: Find the UNIQUE Built-In Function15mActivity: Create and Describe a Dictionary15mActivity: Access a Dictionary Value15mActivity: Use a Dictionary in a CAS Action15mActivity: Store the Results of a CAS Action15mActivity: Iterate Over a Dictionary15mReview of CASL Fundamentals30m

Semana3

Semana 3

5 horas para completar

Connecting to CAS and Accessing Data

In this module you will learn to connect to the CAS server and access it's data. You will begin by making a connection to CAS and exploring the connection options. Then you will begin to learn more about Caslibs by exploring their attributes, data source files and in-memory tables and creating a user defined Caslib. Lastly you will learn about managing in-memory tables by loading, saving, promoting and deleting tables.

5 horas para completar

22 videos (Total 66 minutos), 1 lectura, 10 cuestionarios

22 videos

Module Overview40sExploring and Managing the CAS Connection1mDemo: Exploring and Managing a CAS Session5mAccessing Data in the SAS Compute Server2mAccessing Data in CAS3mExploring Caslibs2mDemo: Adding and Exploring Caslibs3mCaslib Attributes2mDemo: Exploring a Caslib's Attributes4mViewing Caslibs in SAS Studio33sDemo: Assigning a Libref to a Caslib5mLoading Files into In-Memory Tables43sLoading Server-Side Files2mDemo: Loading Server-Side Data into CAS6mLoading Client-Side Files2mDemo: Loading Client-Side Data into CAS4mAccessing and Loading Database Tables2mPromoting Tables to Global Scope3mDemo: Promoting a Table6mSaving In-Memory Tables1mDemo: Saving In-Memory Tables3mDropping In-Memory Tables21s

1 lectura

Summary of Connecting to CAS and Accessing Data30m

9 ejercicios de práctica

Activity: Identify the Active Caslib15mActivity: Explore Available Caslibs15mActivity: Load a Server-Side File into Memory15mActivity: Load a Client-Side File into Memory15mActivity: Promote an In-Memory Table15mActivity: Save an In-Memory Table15mActivity: Drop an In-Memory Table15mPractice: Load a Server-Side File into Memory30mReview of Connecting to CAS and Accessing Data30m

Semana4

Semana 4

6 horas para completar

Exploring and Validating Data

In this module you will learn about exploring and validating data using a variety of CAS actions and CASL techniques. You will begin by exploring a CAS table's structure by viewing the column attributes, previewing the table rows, working with the results of an action and more. Then you will learn about charactering data by finding the distinct and missing values in each column. Lastly, you learn about validating data by removing duplicate rows and creating a new CAS table that identifies bad data.

6 horas para completar

18 videos (Total 59 minutos), 2 lecturas, 14 cuestionarios

18 videos

Module Overview46sExploring Table Structure33sA Quick Look at Table Values1mWorking With Action Results2mExploring Action Results1mAccessing Result Table Values3mDemo: Creating an Array From a Result Table Column10mResult Table Computed Columns1mSaving CASL Results2mDemo: Saving CASL Results6mCharacterizing Data2mDemo: Characterizing Data4mValidating Data1mIdentifying and Isolating Duplicates2mIntroduction to Table.copyTable4mSubsetting Rows and Columns in CopyTable40sUsing copyTable to Validate Data2mDemo: Validating Data Using CASL10m

2 lecturas

Alternative to table.copyTable for SAS Viya for Learners10mSummary of Exploring and Validating Data30m

13 ejercicios de práctica

Activity: View Column Attributes1mActivity: Display the First Five Rows of a Table15mActivity: View the Results of a CAS Action15mActivity: Filter a Result Table15mActivity: Create a Computed Column in a Result Table15mActivity: Save a Result Table as a SAS Data Set15mPractice: Explore a CAS Table Using Actions30mActivity: Print Rows of a Result Table15mPractice: Identify Categorical Columns for Analysis30mActivity: Remove Duplicate Rows of a Table15mActivity: Specify the Length of a Computed Column15mPractice: Document Invalid Data30mReview of Exploring and Validating Data30m

Semana5

Semana 5

6 horas para completar

Preparing Data

In this module you will learn about Preparing Data in CAS. You will begin by executing some common data manipulation using CAS actions techniques such as updating a table in place, creating a new table with computed columns, performing conditional processing, filtering rows and columns, converting column types, working with dates, imputing missing values, restructuring data, and even executing DATA step code in CAS. Lastly you will learn about how to execute fedSQL statements in the CAS server.

6 horas para completar

29 videos (Total 91 minutos), 2 lecturas, 13 cuestionarios

29 videos

Module Overview49sData Preparation in CAS3mIntroduction46sUpdating a Table in Place3mUsing Conditional Logic in the Update Action2mDemo: Updating a Table in Place8mBenefits and Considerations When Updating a Table1mCreating a New In-Memory Table1mFormatting Calculated Columns2mWorking with SAS Date and Time Values3mDemo: Working with Dates and Times6mData Type Conversion4mDemo: Converting Column Data Types5mPreparing the Cars Table15sDemo: Preparing the Cars Table7mBenefits and Considerations When Creating a New Table51sUsing the DataStep CAS Action2mAltering Table Metadata2mImputing Missing Values2mDemo: Imputing Missing Values5mTranspose Action1mDemo: Transposing a Table4mDynamically Removing Outliers1mDemo: Dynamically Removing Outliers7mIntroduction to the FedSql Action Set2mSimple FedSQL Query1mCreating CAS Tables Using SQL1mJoins33sDemo: Imputing Missing Values5m

2 lecturas

Reminder to use table.partition10mSummary of Preparing Data30m

12 ejercicios de práctica

Activity: Find the SCAN Common Function15mActivity: Load a Client-Side File into Memory15mActivity: Update a Column in Place15mActivity: Format a Computed Column15mActivity: Convert a Column's Data Type15mPractice: Update a Table in Place30mPractice: Create a New CAS Table30mActivity: Execute DATA Step Code with an Action15mActivity: Add a Label to a Column15mPractice: Impute Missing Values30mActivity: Execute an SQL Query with an Action15mReview of Preparing Data30m

Semana6

Semana 6

5 horas para completar

Analyzing and Summarizing Data

In this module you will learn about Analyzing and Summarizing Data in CAS. You will begin by understanding the benefits and considerations of using the CAS server with the compute server for your data processing needs. Then you will execute a variety of actions to obtain summary statistics, frequency and crosstabulation reports. Lastly you will learn about how to process the results of the CAS server by using the SAS Output Delivery System (ODS) on the smaller summarized results to create data visualizations, or output to an external file types like PowerPoint, Word, Excel and PDF.

5 horas para completar

18 videos (Total 75 minutos), 2 lecturas, 10 cuestionarios

18 videos

Module Overview46sIntroduction3mSummary Statistics Using the Summary Action1mDemo: Generating Descriptive Statistics Using Summary6mSummary Statistics Using the Aggregate Action3mDemo: Generating Descriptive Statistics Using Aggregate6mFrequency and Crosstabulation Reports4mDemo: Creating Frequency and Crosstabulation Reports7mAdditional Analytic Actions17sDemo: Additional Analytic Actions6mIntroduction to Data Visualization and Reporting46sBest Practice1mDemo: Data Visualization Using CAS Tables9mUsing the SAS Output Delivery System1mDemo: Exporting Results10mGetting the Best Performance3mBest Practices1mDemo: Getting the Best Performance5m

2 lecturas

About Exporting Results10mSummary of Analyzing and Summarizing Data30m

9 ejercicios de práctica

Activity: Find the Summary Action1mActivity: Execute the Summary Action1mActivity: Execute the Aggregate Action15mActivity: Execute the freqTab Action15mPractice: Generate Descriptive Statistics Using Summary30mPractice: Generate a Crosstabulation Report30mActivity: Create a Graph from a CAS Table15mPractice: Create a Bar Chart from a Summarized CAS Table30mReview of Analyzing and Summarizing Data30m

Acerca de Programa especializado: Distributed Programming in SAS® Viya® for Data Analysts

SAS Viya is a cloud-enabled, in-memory analytics engine that provides quick, accurate and reliable analytical insights. This professional certificate program is designed for experienced SAS programmers who want to leverage the power of SAS Cloud Analytics Services (CAS) to access, manage, and analyze in-memory tables. You will write SAS programs to execute in CAS using standard SAS syntax, including the DATA step, FedSQL, and procedures. You will also use the native CAS programming language (CASL) to process in-memory data. These skills prepare you for the SAS Viya Programming certification exams.

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 Programa especializado?
Cuando te inscribes en un curso, obtienes acceso a todos los cursos que forman parte del Programa especializado 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.
¿Hay ayuda económica disponible?
Sí. En ciertos programas de aprendizaje, puedes postularte para recibir ayuda económica o una beca en caso de no poder costear los gastos de la tarifa de inscripción. Si hay ayuda económica o becas disponibles para tu selección de programa de aprendizaje, verás un enlace para postularte en la página de descripción.

¿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

CASL Programming for Distributed Computing in SAS® Viya®

Acerca de este Curso

Qué aprenderás

Habilidades que obtendrás