GEN : Macros for General programming

Id Lesson SAS R SAS Video R Video
MACROS_GEN_L210 1- Import multiple sheets from a single excel file
MACROS_GEN_L310 2- Run same code on multiple datasets - data step
MACROS_GEN_L311 3- Run proc sort on multiple datasets - same by variables
MACROS_GEN_L312 4- Run proc freq on multiple datasets - one or more tables
MACROS_GEN_L313 5- Run proc sort nodupkey on multile datasets using same by variables
MACROS_GEN_L314 6- Run proc sort NOuniquekeys on multile datasets using same by variables
MACROS_GEN_L401 7- Create new folder on harddrive from a sas program
MACROS_GEN_L402 8- Get the file details in a folder/subfolders - OS specific commands
MACROS_GEN_L403 9- Create/delete a temporary copy of the file for reading into SAS - OS based commands