SAS Certified Programming Training (Base Programming)
0% Completed
M1 — The SAS Programming Model and the Exam
The two-step model: DATA step to read and write, PROC step to analyse
Reading
The programming environment: program data set, work library, output
Reading
Exam structure: 60 to 65 questions, 120 minutes, 68 percent to pass
Reading
Submitting code, reading the log and fixing the first error quickly
Reading
Choosing column processing or row processing for a reporting need
Reading
Walking a practice question and marking the data step it requires
Reading
M2 — The DATA Step: Reading and Writing
The LIBRARY statement, the DATA statement and the RUN statement
Reading
INFILE, INPUT and the INFORMAT that parses a raw text file
Reading
Reading delimited and fixed-width files with the right import options
Reading
The SET statement, the WHERE clause and the KEEP option
Reading
DROP, RENAME and LABEL for readability and for downstream work
Reading
Writing to a permanent library and appending with the LOCK statement
Reading
M3 — Transforming Data in the DATA Step
Assignment statements, expressions and the EVAL function
Reading
Functions on dates, characters and numbers and their formats
Reading
FORMAT and INFORMAT pairs and the default format library
Reading
The OUTPUT statement, the BY statement and FIRST. and LAST. variables
Reading
Arrays and the DO loop for a repeated calculation
Reading
Missing values, the missing functions and the IS MISSING test
Reading
M4 — Combining Data Sets
Sorting with PROC SORT and the BY statement in the DATA step
Reading
The MERGE statement with one-to-one, many-to-one and inner joins
Reading
The BY group merge and FIRST. and LAST. for group-level summaries
Reading
The APPEND and UPDATE statements for combining and revising rows
Reading
Reading inline data with the DATALINES statement inside a program
Reading
Checking a merge result with PROC FREQ on the key variables
Reading
M5 — The PROC Step and the Procedures That Matter
PROC PRINT, PROC CONTENTS and PROC VARNAME for orientation
Reading
PROC MEANS with summary options and the CLASS and WAYS statements
Reading
PROC FREQ with tables, cross tabulation and the OUTPUT statement
Reading
PROC SQL with select, join, group by and the create table statement
Reading
PROC REPORT with column definition, compute and grouping
Reading
PROC TRANSPOSE and PROC EXPORT to reshape and deliver a data set
Reading
M6 — Functions, Formats and Date Handling
Character functions: SCAN, SUBSTR, INDEX, TRIM and CATX
Reading
Numeric functions: ROUND, INT, CEIL, FLOOR and the missing value set
Reading
Date and datetime handling with MDY, YEAR, MONTH and DAY
Reading
Creating and applying custom formats with the FORMAT procedure
Reading
INFORMAT lookups that read a date written in a different format
Reading
The YRDIF and AGE functions for tenure and age calculations
Reading
M7 — Macro Programming, SAS/STAT and ODS
Macro variables, %LET and macro quoting with the percent and ampersand
Reading
Macro parameters, the %DO loop and a reusable reporting macro
Reading
Global and local symbol tables and where a name resolves
Reading
SAS/STAT basics: the t-test, the chi-square and the linear model
Reading
ODS output destinations for HTML, RTF, PDF and flat files
Reading
ODS graphics, table styles and a report deliverable that ships
Reading
M8 — Capstone: Build a SAS Reporting Program
Ingest two raw extracts and validate row counts against expectations
Reading
Clean the data in the DATA step and standardise the date formats
Reading
Merge the reference and transaction data with a by-group merge
Reading
Build the summary with PROC SQL and PROC MEANS and cross-check the figures
Reading
Package the output as a macro with parameters for the report period
Reading
Deliver the report through ODS and write the exam revision plan
Reading
📞
Enroll Now
Start Your Journey
Fill in your details and our team will get back to you within 24 hours