Help using Base SAS procedures

running my SAS prog via cron on UNIX

Reply
Occasional Contributor
Posts: 10

running my SAS prog via cron on UNIX

[ Edited ]

 

 

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?

Super User
Posts: 6,927

Re: running my SAS prog via cron on UNIX

[ Edited ]
/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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 6,927

Re: running my SAS prog via cron on UNIX

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 10

Re: running my SAS prog via cron on UNIX

[ Edited ]

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.

Occasional Contributor
Posts: 10

Re: running my SAS prog via cron on UNIX

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.

Community Manager
Posts: 2,757

Re: running my SAS prog via cron on UNIX

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.

Ask a Question
Discussion stats
  • 5 replies
  • 169 views
  • 4 likes
  • 3 in conversation