topic Re: running my SAS prog via cron on UNIX in SAS Procedures

running my SAS prog via cron on UNIX

prolifious — Fri, 27 Jan 2017 14:03:39 GMT

on my unix box,

/home/.../sas $

/home/.../sas $ runsas mysasprogs/myprog.sas

how do i deal with the "runsas" statement in cron?

i've tried

45 8 27 1 * /home/.../sas/mysasprogs/myprog.sas

45 8 27 1 * /home/.../sas $ runsas mysasprogs/myprog.sas

these arent working.. any help on how to deal with the runsas statement?

Re: running my SAS prog via cron on UNIX

Kurt_Bremser — Fri, 27 Jan 2017 15:14:30 GMT

/home/.../sas $

This is your UNIX prompt. This don`t belong in your crontab.

runsas mysasprogs/myprog.sas

This is your command. This is what you need in the crontab.

But I would make sure that all files in a crontab are called by their absolute pathname (starting with the root - / - directory), as the current working directory of a crontab job might be different from the one you were in when testing.

Re: running my SAS prog via cron on UNIX

Kurt_Bremser — Fri, 27 Jan 2017 14:22:27 GMT

PS runsas is (my guess) the script file that handles calling sas with a certain config & autoexec.

Re: running my SAS prog via cron on UNIX

prolifious — Fri, 27 Jan 2017 14:30:43 GMT

Thank you very much...yes you're probably right. I'm working with your advice, i'll get back soon. I really appreciate your help.

Re: running my SAS prog via cron on UNIX

prolifious — Fri, 27 Jan 2017 15:53:51 GMT

totally correct about the script. I spoke with someone within my shop and they're going to help me with that. This is not as straight forward as I was initially told. I've never worked with scripts before, so i need to start now! Thanks again for your help.

Re: running my SAS prog via cron on UNIX

ChrisHemedinger — Fri, 27 Jan 2017 19:51:25 GMT

I like to create a shell script (example: sasdaily.sh) file with all of the SAS jobs that I want to schedule at once. Looks something like:

/usr/local/bin/sas_u8 -nodms -sysin "/u/myid/project/job1.sas"
/usr/local/bin/sas_u8 -nodms -sysin "/u/myid/project/job2.sas"

To make this file executable, you need to run chmod (example: "chmod +x sasdaily.sh"). Then when I need to change/add the SAS jobs I'm running, I can just edit the .sh file and not mess with the crontab scheduler.

You can also combine a "change dir" command in your crontab with this as it runs:

30 06  *   *   1-5   cd /u/myid/project && ./sasdaily.sh

Then your logs/listings are grouped where you expect them, with your SAS files.