Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Advanced SAS Programming Techniques

SAS via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

18 hours 6 minutes
Sessions

Self-Paced
Level

Intermediate
Subtitles

English, Arabic, French, Portuguese, German, Thai, Indonesian, Spanish, Kazakh, Hindi, Russian, Swedish, Korean, Greek, Italian, Chinese, Ukrainian, Japanese, Polish, Dutch, Turkish

Found in

Part of

SAS Advanced Programmer

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

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.

Syllabus

Course Overview, Review, and Data Setup

In this module, you'll set up software and data for this course. Then you'll review the concepts of SAS DATA step processing and how to process data sets.

Using Advanced Functions

In this module, you'll use advanced functions to compare data between multiple rows in a SAS table, find and count substrings within a column, and clean and standardize data. You'll also explore CALL routines, Perl regular expressions, and how to use advanced functions to modify and analyze storm, weather, and population data.

Defining and Processing Arrays

In this module, you'll learn how to use arrays to simplify your code. You'll use arrays to process repetitive code, rotate data, and perform table lookups.

Defining and Processing Hash Objects

In this module, you'll learn how to declare a hash object, instantiate or create an instance of the object, and initialize its lookup keys and data. You'll use the hash object to store and retrieve data, create an output table from the data in the hash object, and create a hash iterator object to process the data in a particular order.

Using Utility Procedures

In this module, you'll learn how to use PROC FORMAT's PICTURE statement to create a custom template to display large numbers, dates, and times. You'll also use PROC FCMP, the function compiler procedure, to create custom functions and CALL routines.