Dev colleagues, earn the SAS Advanced Programmer Professional Certificate and grow your career with a SAS® Credential. Learn to process data using Structured Query Language in the SAS environment , use the SAS macro facility to design, write, and debug dynamic macro programs along with the advanced DATA step techniques and procedures to manipulate data. The three courses in this Professional Certificate include: 1) Structured Query Language (SQL) using SAS - learn how SQL can be used in SAS programs to create reports and query your data, Query and subset data, Summarize and present data, Combine tables using joins and set operators., Create and modify tables and views, Create data-driven macro variables using a query and Access DBMS data with SAS/ACCESS technology ; 2) technology. SAS Macro Language - learn advanced techniques within the DATA step and procedures to manipulate data, Perform text substitution in SAS code, Use macro variables and macro functions, Automate and customize the production of SAS code, Conditionally or iteratively construct SAS code, Write self-modifying, data-driven program; and 3) Advanced SAS Programming Technique - learn advanced techniques within the DATA step and procedures to manipulate data - Use additional functions (LAG, FIND/FINDER, 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, and Create custom functions using the FCMP procedure.
Sign-up today (teams & execs welcome): https://tinyurl.com/2h26z596
Much career success, Lawrence E. Wilson - Online Learning Central