Using a SAS table to control job execution can be useful when lot of jobs have to be scheduled regularly but depending on circumstance some don't have to be scheduled. In normal situation we would have to adapt the job scheduler and this could be time consuming. You could use instead a SAS Dataset or Excel spreadsheet where all the jobs are listed with a flag variable indicating the list of jobs to schedule.

This tips and tricks will be done in 3 steps :

• We will first create a list of jobs to execute and a table referencing those jobs.
• Then we will create a SAS code that read this table and execute the different jobs depending on the flag.
• Finally, we will create a .bat file and schedule it in Windows task scheduler.

Prerequisites

You have some SAS experience and would like to automate your SAS code execution.