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...
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