Macros for General programming

Id Lesson SAS R SAS Video R Video
MACROS_GEN_L210Import multiple sheets from excel at a time
MACROS_GEN_L310Run same code on multiple datasets - data step
MACROS_GEN_L311Run proc sort on multiple datasets - same by variables
MACROS_GEN_L312Run proc freq on multiple datasets - one or more tables
MACROS_GEN_L313Run proc sort nodupkey on multile datasets using same by variables
MACROS_GEN_L314Run proc sort NOuniquekeys on multile datasets using same by variables
MACROS_GEN_L401Create new folder on harddrive from a sas program
MACROS_GEN_L402Get the file details in a folder/subfolders - OS specific commands
MACROS_GEN_L403Create/delete a temporary copy of the file for reading into SAS - OS based commands