0

  • No hay productos en el carrito.

Inicio / Cursos / SAS Programming Advance Certification Course(SAS SQL, Macro)
Impartido por Sharon ChengPago único de $2,800 MXN · acceso por 12 meses

SAS Programming Advance Certification Course(SAS SQL, Macro)

The complete Prep Course for SAS Advanced Programming Professional Certification SAS® 9.4 (Exam ID A00-232)

Certificado oficial emitido por la SEPA través del Gobierno del Estado de México
12 meses de acceso En línea · 60 h 21 unidades
Inscribirme — $2,800 MXN Explorar programa
Qué aprenderás

Lo que serás capaz de hacer

This course is designed for individuals seeking to become advanced SAS programming professionals by earning the official SAS® Advanced Certification . Course Overview This comprehensive preparation course covers all the essential topics for the SAS® Certified Professional: Advanced Programming Using SAS® 9.4 (Exam ID A00-232) . Key Topics Covered (Aligned with the Certification Exam) SAS SQL (35%) – Master advanced SQL techniques in SAS SAS Macro (35%) – Develop expertise in macro programming for automation Advanced Techniques and Efficiencies (30%) – Learn optimization strategies for efficient data processing Course Features 24/7 access – Learn anytime, anywhere at your convenience. Pre-recorded lectures – Enjoy a self-paced, user-friendly learning experience. Structured learning approach – Each lecture begins with key concepts and coding rules presented in PowerPoint slides, followed by hands-on SAS programming sessions. We run SAS programs, explain the code in detail, interpret results, address system messages, and troubleshoot errors. Downloadable course materials – Access PowerPoint slides, data files, and SAS code for hands-on practice. Quizzes, coding exercises, and projects – Reinforce learning through interactive practice—because mastery comes with practice! SAS Software for This Course: SAS Studio This course was initially created using the SAS University Edition (downloadable SAS Studio version), which has since been replaced by SAS OnDemand for Academics —a free, web-based version of SAS Studio. Fully compatible with SAS OnDemand for Academics Consistent interface, appearance, and functionalities between both versions Detailed setup instructions for SAS OnDemand for Academics are provided in Section 2 Course Ratings and Reviews Your honest and thoughtful feedback is highly appreciated! Your ratings help improve course content and enhance your learning experience. This course is regularly updated to reflect the latest SAS certification changes and incorporate student suggestions, ensuring it remains relevant and valuable. Fair and constructive reviews are essential to improving the course’s quality, and I truly appreciate your honest input. In this field, course ratings above 4.5 are widely regarded as indicators of high-quality content. Thank you for your support! Reference Materials SAS 9.4 SQL Procedure User's Guide, Second Edition SAS® 9.4 Macro Language: Reference, Fifth Edition SAS Certification Prep Guide: Advanced Programming for SAS 9 – by SAS Institute

  • This course will prepare you for the SAS certificate (Exam ID A00-232): SAS Advanced Programming Professional Certification SAS® 9.4
  • SAS SQL (Proc SQL): Accessing Data Using SQL (35%)
  • SAS Macro: Macro Processing (35%)
  • SAS Advanced Programming Techniques and Efficiencies (30%)

Temario

UNIDAD 1 - Course Overview and downloadable course materials · 2 lecciones

UNIDAD 1 - Course Overview and downloadable course materials
  • Course IntroductionVideo · 12 min
  • Downloadable course materialsVideo · 1 min
UNIDAD 2 - Use the free web-based SAS studio "SAS OnDemand for Academics" with this course · 4 lecciones

UNIDAD 2 - Use the free web-based SAS studio "SAS OnDemand for Academics" with this course
  • Access free SAS software "SAS OnDemand for Academics" step by step instructionVideo · 11 min
  • Upload course data files and SAS programs into SAS ondemand for academicsVideo · 6 min
  • change file path/directory in SAS ondemand for academicsVideo · 7 min
  • examples: update and run SAS programs in SAS ondemand for academicsVideo · 7 min
UNIDAD 3 - SAS SQL: Proc SQL introduction · 1 lecciones

UNIDAD 3 - SAS SQL: Proc SQL introduction
  • Proc SQL introductionVideo · 7 min
UNIDAD 4 - SAS SQL: SELECT statement: Retrieving Data from a Single Table · 13 lecciones

UNIDAD 4 - SAS SQL: SELECT statement: Retrieving Data from a Single Table
  • SELECT Statement: OverviewVideo · 15 min
  • SELECT Clause: Eliminate Duplicate Rows Using the DISTINCT KeywordVideo · 10 min
  • SELECT Clause: Create ColumnsVideo · 11 min
  • SELECT Clause: Assign Values Conditionally by Using a CASE ExpressionVideo · 11 min
  • SELECT Clause: Replace Missing Values with COALESCE Function and Case ExpressionVideo · 9 min
  • ORDER BY Clause: Sort DataVideo · 12 min
  • WHERE Clause: Retrieving Rows That Satisfy a ConditionVideo · 14 min
  • Summarizing Data using aggregate functions (or summary functions)Video · 12 min
  • GROUP BY Clause: Group DataVideo · 15 min
  • HAVING Clause: Filter Grouped DataVideo · 7 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 5 - SAS SQL: JOIN: Retrieving Data from Multiple Tables · 10 lecciones

UNIDAD 5 - SAS SQL: JOIN: Retrieving Data from Multiple Tables
  • Inner Join Data: Use Where Clause, Use Inner Join keyword, Comparison OperatorsVideo · 12 min
  • Inner Join Data: Effect of Missing Values on Join, Use Multiple Matching ColumnsVideo · 13 min
  • Inner Join Data: Inner Join More Than Two Tables, Self-JoinsVideo · 7 min
  • Outer Join Data: Left, Right and Full Outer JoinsVideo · 11 min
  • Specialty Joins: cross joins, union joins, and natural joinsVideo · 12 min
  • Comparison of DATA Step Match-Merges with PROC SQL Joins: Part 1Video · 13 min
  • Comparison of DATA Step Match-Merges with PROC SQL Joins: Part 2Video · 7 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 6 - SAS SQL: Subqueries: Using Subqueries to Select Data · 7 lecciones

UNIDAD 6 - SAS SQL: Subqueries: Using Subqueries to Select Data
  • Single-Value and Multiple-Value SubqueriesVideo · 11 min
  • Testing for the Existence of a Group of ValuesVideo · 5 min
  • Correlated Subqueries and Combining a Join with a SubqueryVideo · 8 min
  • Multiple Levels of Subquery NestingVideo · 7 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 7 - SAS SQL: Combine Queries with Set Operators · 8 lecciones

UNIDAD 7 - SAS SQL: Combine Queries with Set Operators
  • UNION: Produce all unique rows from both queriesVideo · 11 min
  • EXCEPT: Produce all unique rows from both queriesVideo · 7 min
  • INTERSECT: Produce rows that are common to both query resultsVideo · 4 min
  • OUTER UNION: Concatenate the query resultsVideo · 4 min
  • EXCLUSIVE UNION: Produce Rows from the First or Second QueryVideo · 6 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 8 - SAS SQL: Creating and Updating Tables and Views · 18 lecciones

UNIDAD 8 - SAS SQL: Creating and Updating Tables and Views
  • Create New Table without Rows by using the CREATE TABLE StatementVideo · 5 min
  • Create Tables from a Query Result using CREATE TABLE with AS KeywordVideo · 6 min
  • Create Tables like an Existing Table with LIKE clause & Copy an Existing TableVideo · 6 min
  • Insert Rows into Tables using Insert Statement with the SET ClauseVideo · 8 min
  • Insert Rows into Tables using Insert Statement with the VALUE ClauseVideo · 7 min
  • Insert Rows into Tables using Insert Statement with a QueryVideo · 8 min
  • Update All Rows with the Same Expression using Update StatementVideo · 6 min
  • Update All Rows with Different Expressions using Update StatementVideo · 10 min
  • Delete Rows with the DELETE statementVideo · 4 min
  • Alter Columns with the ALTER TABLE statement: Add a ColumnVideo · 8 min
  • Alter Columns with the ALTER TABLE statement: Modify or Delete a ColumnVideo · 3 min
  • Use SQL Procedure Tables & Delete TablesVideo · 4 min
  • Proc SQL Views: Create, Describe, and Delete PROC SQL ViewsVideo · 7 min
  • Proc SQL Views: Use Proc SQL ViewsVideo · 4 min
  • Proc SQL Views: Specify/Use In-Line ViewsVideo · 7 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 9 - SAS SQL: Practical Examples Using PROC SQL · 9 lecciones

UNIDAD 9 - SAS SQL: Practical Examples Using PROC SQL
  • Comparing Old and New TablesVideo · 6 min
  • Overlaying Missing Data ValuesVideo · 8 min
  • Computing Percentages within SubtotalsVideo · 9 min
  • Counting Exact Duplicate Rows in a TableVideo · 4 min
  • Expanding Hierarchical Data in a TableVideo · 6 min
  • Summarizing Data in Multiple ColumnsVideo · 5 min
  • Creating a Summary ReportVideo · 8 min
  • Creating a Customized Sort OrderVideo · 7 min
  • Updating a Table with Values from Another TableVideo · 8 min
UNIDAD 10 - SAS Macro: SAS Macro Introduction · 7 lecciones

UNIDAD 10 - SAS Macro: SAS Macro Introduction
  • SAS Macro OverviewVideo · 3 min
  • Replacing Text Strings Using Macro VariablesVideo · 5 min
  • Generating SAS Code Using MacrosVideo · 6 min
  • Passing Information into a Macro Using ParametersVideo · 4 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 11 - SAS Macro: Macro Variables & Macro Functions · 17 lecciones

UNIDAD 11 - SAS Macro: Macro Variables & Macro Functions
  • SAS macro variables: IntroductionVideo · 5 min
  • Automatic macro variablesVideo · 3 min
  • User-Defined Macro VariablesVideo · 6 min
  • Displaying Macro Variable Values in the SAS Log: using SYMBOLGENVideo · 4 min
  • Displaying Macro Variable Values in the SAS Log: using %PUTVideo · 4 min
  • Using Macro Quoting Function to Mask Special Characters:%STRVideo · 5 min
  • More on Using Macro Quoting Functions to Mask Special Characters:%STRVideo · 4 min
  • Using Macro Functions to Manipulate Character Strings: %UPCASEVideo · 4 min
  • Using Macro Functions to Manipulate Character Strings: %SUBSTRVideo · 5 min
  • Using Macro Functions to Manipulate Character Strings: %SCANVideo · 4 min
  • Using %SYSFUNC function to execute other SAS functionsVideo · 4 min
  • Combining Macro Variable References with TextsVideo · 8 min
  • Using delimiter for a macro variable name immediately before textVideo · 5 min
  • More on using delimiter for a macro variable name immediately before textVideo · 6 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 12 - SAS Macro: Create & Use macro variables during a data step or a Proc SQL step · 9 lecciones

UNIDAD 12 - SAS Macro: Create & Use macro variables during a data step or a Proc SQL step
  • Use macro variables during execution of a data step: Symput routineVideo · 14 min
  • Create multiple macro variables with SYMPUT and Indirect referencing with &&Video · 10 min
  • Obtaining Macro Variable Values during DATA Step Execution with SYMGET FunctionVideo · 4 min
  • Creating Macro Variables during PROC SQL Step Execution: INTO clauseVideo · 7 min
  • Creating a series of related Macro Variables with the INTO Clause in Proc SQLVideo · 7 min
  • Creating one macro variable holding a Delimited List of Values with INTO clauseVideo · 5 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 13 - SAS Macro: Creating and Using Macro Programs · 10 lecciones

UNIDAD 13 - SAS Macro: Creating and Using Macro Programs
  • Basic Concepts: Defining, Compiling and Calling MacrosVideo · 5 min
  • Developing and Debugging Macros with options: MPRINT, MLOGICVideo · 6 min
  • Using Macro Parameters: Positional ParametersVideo · 9 min
  • Using Macro Parameters: Keyword ParametersVideo · 9 min
  • Using Macro Parameters: Mixed ParametersVideo · 6 min
  • Processing Statements Conditionally at the macro level: %IF%THEN%ELSE %DO%ENDVideo · 10 min
  • Processing Statements Interactively With the iterative %DO statementVideo · 8 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 14 - Advanced Techniques and Efficiencies: Indexes · 6 lecciones

UNIDAD 14 - Advanced Techniques and Efficiencies: Indexes
  • Index Overview & Create Indexes in Data stepVideo · 10 min
  • Managing Indexes with PROC DATASETSVideo · 7 min
  • Managing Indexes with PROC SQLVideo · 6 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 15 - Advanced Techniques and Efficiencies: Combining Data Vertically · 5 lecciones

UNIDAD 15 - Advanced Techniques and Efficiencies: Combining Data Vertically
  • Combining Data Vertically using FILENAME statementVideo · 6 min
  • Combining Data Vertically using FILEVAR = optionVideo · 7 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 16 - Advanced Techniques and Efficiencies: Combining Data Horizontally · 6 lecciones

UNIDAD 16 - Advanced Techniques and Efficiencies: Combining Data Horizontally
  • Combine Summary Data and Detail Data conditionally with multiple SET statementsVideo · 7 min
  • Combine Data with multiple SET statements with KEY = option: Using an IndexVideo · 13 min
  • Using Hash Objects as Lookup TablesVideo · 13 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 17 - Advanced Techniques and Efficiencies: Formats & Arrays · 8 lecciones

UNIDAD 17 - Advanced Techniques and Efficiencies: Formats & Arrays
  • Creating Custom Formats Using the PICTURE StatementVideo · 11 min
  • Stored custom formats permanently & Manage it with FMTSEARCH= system optionVideo · 15 min
  • Use formats to create data via lookupsVideo · 7 min
  • Using the ARRAY Statement to Combine DataVideo · 5 min
  • Processing data with multiple dimensional ArraysVideo · 8 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 18 - Advanced Techniques and Efficiencies: Perform effective benchmarking · 4 lecciones

UNIDAD 18 - Advanced Techniques and Efficiencies: Perform effective benchmarking
  • Understand resources related to efficiencyLectura · 0 min
  • Use SAS system options to track resourcesVideo · 3 min
  • Using Benchmarks to Compare TechniquesLectura · 0 min
  • QuizCuestionario · 0 min
UNIDAD 19 - Advanced Techniques and Efficiencies: Controlling Data Storage Space · 6 lecciones

UNIDAD 19 - Advanced Techniques and Efficiencies: Controlling Data Storage Space
  • Reducing length for Numeric VariablesVideo · 12 min
  • Compressing Data FilesVideo · 12 min
  • use SAS data steps views to conserve data storage spaceVideo · 7 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 20 - Advanced Techniques and Efficiencies: PROC FCMP: functions and subroutines · 5 lecciones

UNIDAD 20 - Advanced Techniques and Efficiencies: PROC FCMP: functions and subroutines
  • Create and use user-defined Functions with PROC FCMPVideo · 7 min
  • Create and use Subroutines with PROC FCMPVideo · 6 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
UNIDAD 21 - Advanced Techniques & Efficiencies: compare techniques to eliminate duplicates · 6 lecciones

UNIDAD 21 - Advanced Techniques & Efficiencies: compare techniques to eliminate duplicates
  • eliminate duplicate data using Data stepVideo · 7 min
  • eliminate duplicate data using Proc SortVideo · 6 min
  • eliminate duplicate data using Proc SQLVideo · 10 min
  • QuizCuestionario · 0 min
  • Coding ExerciseLectura · 0 min
  • Coding Exercise: SolutionLectura · 0 min
Certificado oficial

Tu certificado lo emite la SEP, no solo una plataforma

Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.

Tu certificado con INEC

  • Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
  • Documento oficial con folio verificable en línea
  • Lo otorga la Universidad Tecnológica Fidel Velázquez

Otras plataformas en línea

  • Constancia privada emitida por la misma plataforma
  • Solo acredita horas cursadas o asistencia
  • Sin respaldo de una autoridad educativa
Cómo funciona

Tu itinerario, de la inscripción al certificado

  1. 1

    Inscripción con pago único

    Pagas $2,800 MXN una sola vez y entras de inmediato al curso.

  2. 2

    Estudias a tu ritmo

    21 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.

  3. 3

    Cuestionarios por unidad

    17 cuestionarios para comprobar lo aprendido.

  4. 4

    Certificado

    Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.

Lo que obtienes

Un certificado oficial de la SEP

Muestra del certificado: SAS Programming Advance Certification Course(SAS SQL, Macro)

Muestra · verificable por folio y QR

  • Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
  • Contenido impartido por Sharon Cheng.
  • Folio y QR verificables para compartirlo con quien te contrate.
Medios que necesitas
Equipo de cómputo Conexión estable a internet
Pago único

Empieza hoy, a tu ritmo

Un solo pago y acceso inmediato al curso completo durante 12 meses.

  • 21 unidades · 161 lecciones · 60 h
  • 12 meses de acceso
  • 17 cuestionarios de evaluación
  • Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Pago único
$2,800MXN
Acceso por 12 meses
Inscribirme Hablar con un asesor
Preguntas frecuentes

Sobre tu inscripción

¿Cómo es el pago?

Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.

¿Cuánto tiempo tengo acceso?

12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.

¿Quién imparte el contenido?

El curso es impartido por Sharon Cheng; INEC gestiona tu inscripción, evaluación y certificado.

¿Qué pasa cuando vence mi acceso?

Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.

Certificado emitido por la SEP a través del Gobierno del Estado de México · SAS Programming Advance Certification Course(SAS SQL, Macro)

Inscribirme
  INEC es una Marca de SalesPartners Ciudad de México S de RL de CV. Template Design © Learnify LMS. All rights reserved. Terminos y Condiciones Aviso de Privacidad Politica de Devolución
Hide picture