BeOptimized - Tips and Tricks

Use a SAS table to control job execution

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.

Go back to your selection

This site uses cookies. .

By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.