SAS Programming BASE Certification Course for SAS Beginners
The Complete Preparation Course for SAS Certified Base Programming Professionals for SAS 9.4 (Exam ID A00-231, A00-215 )
Lo que serás capaz de hacer
This course is a comprehensive training program designed to prepare you for the SAS BASE programming certification . Whether you’re a beginner or an aspiring data professional, this course will help you develop essential SAS programming skills and advance your career in data-driven industries. Many companies actively seek SAS-certified professionals, making this certification a valuable asset. If earning your SAS BASE certification is your goal, this course is the perfect choice for you. Who Is This Course For? This course is suitable for: (1) Beginners with no prior SAS experience. (2) Individuals preparing for the SAS BASE certification exams , including: SAS Certified Specialist: Base Programming Using SAS 9.4 (Exam ID A00-231) --- The course covers all exam topics in detail. SAS Certified Associate: Programming Fundamentals Using SAS 9.4 (Exam ID A00-215), which is a junior-level SAS BASE certification. --- This course covers more topics than required for the A00-215 exam. Note: A00-215 is NOT a prerequisite for A00-231. Many students have enrolled in this course and passed the full SAS 9.4 Base Programming (A00-231) certification directly. What You’ll Learn Step-by-step, code-by-code explanations for easy and efficient learning. Quizzes, coding exercises, and projects for hands-on practice. Downloadable course materials, including: PowerPoint slides SAS programs Data files used in all lectures Software Requirements: SAS Studio This course was originally created using the SAS University Edition (downloadable version of SAS Studio). However, it has since been updated to SAS OnDemand for Academics which is a free, web-based version of SAS Studio. The course is fully compatible with SAS OnDemand for Academics. The software's interface, appearance, and functionality remain consistent between the two versions. Detailed setup instructions are provided in Section 2 . A Note on Course Ratings and Reviews Many students who enrolled in this course successfully passed the SAS Base Certification Exam (Exam ID: A00-231) on their first attempt. They've shared their success stories with me, and I’m both encouraged and grateful that this course played a key role in helping them achieve this milestone. I’d love to hear your success story too! Please consider sharing your experience and the joy of this important career accomplishment in your course review. Your feedback not only motivates me, but it also helps guide and inspire others who are preparing for the exam. 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 once again for choosing this course and allowing me to be a part of your certification journey! References: SAS certification prep guide: base programming by SAS Institute The little SAS book: a primer / Lora D. Delwiche and Susan J. Slaughter Learning SAS by example: a programmer's guide / Ron Cody
- This course is the complete SAS BASE programming certification preparation course even if you are new to SAS.
- In this course, students will learn all SAS BASE programming skills to obtain SAS BASE programming certification
- This course covers all topics in SAS BASE certifications Exams (A00-231 (full version) , A00-215 (junior version))
- Students will also learn SAS advanced topic: Proc SQL Essentials and SAS Macros Essentials
- A00-215 is NOT the prerequisite of A00-231. Many students enrolled this course directly passed A00-231 (full version) to save time and money.
- You are welcome to FREE view more than 10 full lectures before enrollment.
Temario
UNIDAD 1 - Course Overview, downloadable course materials and access free SAS studio · 4 leccionesUNIDAD 1 - Course Overview, downloadable course materials and access free SAS studio
UNIDAD 1 - Course Overview, downloadable course materials and access free SAS studio
- Course Overview
- access free SAS software "SAS OnDemand for Academics/cloud-based SAS studio"
- how to use SAS OnDemand for academics/cloud-based SAS studio with this course
- Downloadable course materials (PPT slides, SAS codes, data) for all lectures
UNIDAD 2 - An Introduction to SAS · 2 leccionesUNIDAD 2 - An Introduction to SAS
UNIDAD 2 - An Introduction to SAS
- SAS Introduction
- Quiz: SAS introduction
UNIDAD 3 - Get Data into SAS: create temporary & permanent SAS data · 13 leccionesUNIDAD 3 - Get Data into SAS: create temporary & permanent SAS data
UNIDAD 3 - Get Data into SAS: create temporary & permanent SAS data
- Read data delimited by blanks (.txt data file) using list input
- Read data delimited by commas (.csv data file) using list input
- Read data delimited by any delimiters using list input
- Read data in fixed columns using column input
- Read data using formatted input including using SAS informat to read dates
- Read data using formatted input: use SAS format to display SAS date values
- Create internal SAS data using DATALINES statement
- LIBNAME statement: assign library names and create permanent SAS data sets
- Proc Import: Import Excel data file into SAS
- Proc Import: Import external delimited data files into SAS
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 4 - Work with data · 11 leccionesUNIDAD 4 - Work with data
UNIDAD 4 - Work with data
- Use ASSIGNMENT statements in DATA step & use SET statement to create a SAS data
- SAS functions: overview
- Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statements
- Conditionally execute SAS statements: IF-THEN/ELSE, DO and END statement (Cont.)
- Define the length of a variable using the LENGTH statement
- Subset your Data using subsetting IF statement and DELETE statement
- Quiz
- Coding Exercise 1
- Coding Exercise 1: Solution
- Coding Exercise 2
- Coding Exercise 2: Solution
UNIDAD 5 - Create labels and formats · 10 leccionesUNIDAD 5 - Create labels and formats
UNIDAD 5 - Create labels and formats
- Use LABEL statement to add Labels to vars in DATA step & Proc Print Split option
- Use FORMAT statement to assign Formats to Variable: more on SAS Built-in Formats
- Create your user defined FORMATS
- Storing and Referencing/using your User-Defined FORMATS
- Proc format with CNTLIN= option to define custom formats
- Quiz
- Coding Exercise 1
- Coding Exercise 1: Solution
- Coding Exercise 2
- Coding Exercise 2: Solution
UNIDAD 6 - Use SAS Functions to manipulate character and numeric data values · 14 leccionesUNIDAD 6 - Use SAS Functions to manipulate character and numeric data values
UNIDAD 6 - Use SAS Functions to manipulate character and numeric data values
- Convert Character & Numeric Value: Auto convert, explicitly PUT & INPUT function
- SCAN function: Separate a character value and obtain a specified word/string
- SUBSTR function: Extract and replace a portion of a character value
- TRIM and CATX functions: Concatenate character values
- INDEX function: Search a character value for a specified string
- FIND function: search for substrings of characters in a character string
- UPCASE, LOWCASE and PROPCASE functions: Change the case of characters
- TRANWRD function: Replace/remove characters within a character string
- SAS numeric functions: INT and ROUND functions: Modifying Numeric Values
- additional SAS numeric functions: Smallest and Largest functions
- additional SAS numeric functions: RAND function
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 7 - Use SAS Functions to manipulate SAS date values · 7 leccionesUNIDAD 7 - Use SAS Functions to manipulate SAS date values
UNIDAD 7 - Use SAS Functions to manipulate SAS date values
- Explanation on how SAS stores date and time values; Usage of MDY function
- YEAR, QTR, MONTH, DAY, WEEKDAY Functions: Extract year/quarter/month/day values
- TODAY, DATE, INTCK functions: get current date value & number of time interval
- DATDIF, YRDIF function: Calculate difference in days and years between two dates
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 8 - Process data using DO LOOPS · 7 leccionesUNIDAD 8 - Process data using DO LOOPS
UNIDAD 8 - Process data using DO LOOPS
- Constructing DO loops: part 1
- Constructing DO loops: part 2
- Conditionally Executing DO Loops using DO UNTIL and DO WHILE
- Using Conditional Clauses with the Iterative DO Statement
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 9 - Using ARRAYS to simply coding · 9 leccionesUNIDAD 9 - Using ARRAYS to simply coding
UNIDAD 9 - Using ARRAYS to simply coding
- Creating One-Dimensional Arrays
- Creating Variables in an ARRAY Statement
- Assigning Initial Values to Arrays & Creating Temporary Array Elements
- Two dimensional array
- Quiz
- Coding Exercise 1
- Coding Exercise 1: Solution
- Coding Exercise 2
- Coding Exercise 2: Solution
UNIDAD 10 - Combine SAS data sets · 12 leccionesUNIDAD 10 - Combine SAS data sets
UNIDAD 10 - Combine SAS data sets
- One-to-One Merging
- Concatenating
- Appending
- Interleaving
- Match merging
- Types of match-merging: merge data sets one-to-one and one-to-many
- Match Merging: Renaming Variables
- Match Merging: Excluding Unmatched Observations
- Match Merging: Selecting Variables
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 11 - Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE · 7 leccionesUNIDAD 11 - Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE
UNIDAD 11 - Reconstruct/Reshape SAS Data sets in DATA step and using Proc TRANSPOSE
- Convert One Obs / Subject to Several Obs / Subject Using a Data step
- Convert Several Obs/Subject to One Obs/Sub in DATA Step: First, Last functions
- Convert One Obs / Subject to Several Obs / Subject Using PROC TRANSPOSE
- Convert Several Obs / Subject to One Obs / Subject Using PROC TRANSPOSE
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 12 - SAS Stat Procedures: Proc SORT, PRINT, MEANS, FREQ, UNIVARIATE, Contents, Export · 12 leccionesUNIDAD 12 - SAS Stat Procedures: Proc SORT, PRINT, MEANS, FREQ, UNIVARIATE, Contents, Export
UNIDAD 12 - SAS Stat Procedures: Proc SORT, PRINT, MEANS, FREQ, UNIVARIATE, Contents, Export
- Sorting SAS Data with PROC SORT
- Generate list reports with Proc PRINT: VAR, SUM, WHERE, ID and BY statements
- Generate reports with Proc PRINT: VAR, SUM, WHERE, ID and BY statements (Cont.)
- Calculate summary statistics and multilevel summaries using Proc MEANS procedure
- Produce one-way and two-way frequency tables with the Proc FREQ procedure
- Enhance frequency tables with options (NLEVEL, ORDER, LIST, CROSSLIST)
- Proc Univariate: More powerful way to Describing and Summarizing data
- Proc Content: investigate/view the Contents of a SAS Libraries or a SAS data set
- Proc Export: Export data to create standard, comma-delimited, Excel data files
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 13 - Generate reports using ODS statements · 6 leccionesUNIDAD 13 - Generate reports using ODS statements
UNIDAD 13 - Generate reports using ODS statements
- ODS overview with examples creating PDF, RTF, PowerPoint outputs
- ODS: Creating HTML Output with Options
- ODS: Creating Excel Output with multiple worksheets
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 14 - Error Handling: identify and resolve SAS errors · 5 leccionesUNIDAD 14 - Error Handling: identify and resolve SAS errors
UNIDAD 14 - Error Handling: identify and resolve SAS errors
- Syntax errors: misspelled keywords, unmatched ' ', missing ; , invalid option
- Logic Error: PUTLOG statement, ERROR statement, temporary variables N and ERROR
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 15 - SAS Macro: Essentials · 7 leccionesUNIDAD 15 - SAS Macro: Essentials
UNIDAD 15 - SAS Macro: Essentials
- SAS Macro Overview
- Replacing Text Strings Using Macro Variables
- Generating SAS Code Using Macros
- Passing Information into a Macro Using Parameters
- Quiz
- Coding Exercise
- Coding Exercise: solution
UNIDAD 16 - Proc SQL: Essentials · 6 leccionesUNIDAD 16 - Proc SQL: Essentials
UNIDAD 16 - Proc SQL: Essentials
- Retrieve Data from a Single Table using the Select Statement
- Retrieve Data from Multiple Tables using Inner Join
- Retrieve Data from Multiple Tables using Outer Joins
- Quiz
- Coding Exercise
- Coding Exercise: Solution
UNIDAD 17 - Hands-on Project: Case study on Weight Loss data · 3 leccionesUNIDAD 17 - Hands-on Project: Case study on Weight Loss data
UNIDAD 17 - Hands-on Project: Case study on Weight Loss data
- Project step-by-step instruction & Excel data file
- Project Solution: Video
- Project SAS Code: Downloadable
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
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
17 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
15 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- 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.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 17 unidades · 135 lecciones · 60 h
- 12 meses de acceso
- 15 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
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.


