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.
Overview
Loading...
Reviews
4.8 (80 ratings)
- 5 stars88.75%
- 4 stars8.75%
- 3 stars1.25%
- 2 stars1.25%
DG
Dec 12, 2022
Amazing course! With some additional practice, I feel like I'll soon be ready to pass the exam :-)
SW
Oct 18, 2020
Passed SAS adv exam after taking this course. It's very useful.
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
Explore our Catalog
Join for free and get personalized recommendations, updates and offers.
Coursera Footer
© 2023 Coursera Inc. All rights reserved.
