01-27-2017 09:02 AM - edited 01-27-2017 09:03 AM
on my unix box,
/home/.../sas $ runsas mysasprogs/myprog.sas
how do i deal with the "runsas" statement in cron?
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?
01-27-2017 09:19 AM - edited 01-27-2017 10:14 AM
This is your UNIX prompt. This don`t belong in your crontab.
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.
01-27-2017 09:22 AM
PS runsas is (my guess) the script file that handles calling sas with a certain config & autoexec.
01-27-2017 09:30 AM - edited 01-27-2017 09:30 AM
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.
01-27-2017 10:53 AM
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.
01-27-2017 02:51 PM
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.