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.