In this course, you learn advanced techniques within the DATA step and procedures to manipulate data. 鈥淏y 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.
Overview
Loading...
Skills You'll Learn
Perl (Programming Language), Data Analysis, Data Manipulation, Data Processing, SAS (Software), Data Structures, Data Transformation, Statistical Programming
Reviews
4.8 (94 ratings)
- 5 stars86.17%
- 4 stars10.63%
- 3 stars2.12%
- 2 stars1.06%
DG
Dec 13, 2022
Amazing course! With some additional practice, I feel like I'll soon be ready to pass the exam :-)
BD
Jun 5, 2022
Really useful courses and can quickly boost you from a basic SAS programmer to advanced level.
From the lesson
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.
Taught By
Michele Ensor