SAS Advanced Programmer

Offered By: SAS via Coursera

Course Description

Overview

When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.

Syllabus

Course 1: Structured Query Language (SQL) using SAS
- Offered by SAS. Course Description In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to ... Enroll for free.

Course 2: SAS Macro Language
- Offered by SAS. In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. Course Learning ... Enroll for free.

Course 3: Advanced SAS Programming Techniques
- Offered by SAS. In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. “By the end of this ... Enroll for free.

Courses

0 reviews
20 hours 26 minutes
View details

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. Course Learning Objectives: (3+ per course) “By the end of this course, a learner will be able to…” ● Perform text substitution in SAS code. ● Use macro variables and macro functions. ● Automate and customize the production of SAS code. ● Conditionally or iteratively construct SAS code. ● Write self-modifying, data-driven programs.
0 reviews
1 day 2 hours 28 minutes
View details

Course Description In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data. “By the end of this course, a learner will be able to…” ● Query and subset data. ● Summarize and present data. ● Combine tables using joins and set operators. ● Create and modify tables and views. ● Create data-driven macro variables using a query. ● Access DBMS data with SAS/ACCESS technology.
0 reviews
17 hours 56 minutes
View details

In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. “By the end of this course, a learner will be able to…” ● Use additional functions (LAG, FINDC/FINDW, and COUNT/COUNTC/COUNTW). ● Perform pattern matching using PRX functions. ● Process repetitive code, rotate data, and perform table lookups using arrays. ● Perform table lookups and sort data using hash and hash iterator objects. ● Create numeric templates using the FORMAT procedure. ● Create custom functions using the FCMP procedure.

Taught by

Michele Ensor, Peter Styliadis and Stacey Syphus