topic Re: Automatic scheduler for SAS job in SAS Procedures

Automatic scheduler for SAS job

siddharthpeesary — Wed, 25 Nov 2015 17:41:36 GMT

Hi all,

I have a file named DDA_BASED_S9_20151030

I have a folder where every month end above file will be dumped(the file name will be same except only month and year (i.e 201510)

so My job is to running every month

1)libname mydblib odbc datasrc=XXXXX user=XXXXXXX password=XXXXXXX; (->creates connection)

2)%macro importdata(infile=,outfile=,type=,filter=);
proc import
datafile=&infile
dbms=&type
out=&outfile
replace;
&filter
run;
%mend importdata;

%importdata(infile='PATH\DDA_BASED_S9_20151030.csv',outfile=DDA_BASED_S9_20151030,type=csv,filter=); (->imports file)

3)data mydblib.DDA_BASED_S9_20151030;(->saves data into the database)
set DDA_BASED_S9_20151030;
run;

Program for Automation work:

But Now I like to make it automated,

1)I like to write a program so every month where it has to check for paricular FILE in an particular FOLDER automatically without opening sas program, like using scheduler and send the file to database

can anyone tell me the process(code) for it ,it will be very helpful thanks. SO that i can use for other programs as a reference

Thanks In Advance.

Please let me know if there are any misconception.

Re: Automatic scheduler for SAS job

SASKiwi — Wed, 25 Nov 2015 18:51:45 GMT

There are many schedulers available that can check for the existence of a file to trigger a batch job. Where are you going to run your SAS job? On a PC or on a SAS server? If it is a SAS server, which is what I would recommend, I suggest you talk to your SAS admin folks to see how they schedule jobs.

Running scheduled tasks on PCs is not very reliable as they need to be switched on, have a working network connection, and have a valid username for running the scheduled task under. Servers are much better for this.

Re: Automatic scheduler for SAS job

siddharthpeesary — Wed, 25 Nov 2015 19:09:50 GMT

I like to run sas job on PC(windows)

Re: Automatic scheduler for SAS job

pearsoninst — Wed, 25 Nov 2015 19:12:28 GMT

This Post might Help ..
https://communities.sas.com/t5/SAS-Enterprise-Guide/Scheduled-Jobs/m-p/139179#U139179

Re: Automatic scheduler for SAS job

pearsoninst — Wed, 25 Nov 2015 19:13:37 GMT

There is a Schedule option in windows itself ..Pls Google it ..you will find the answer ...

Re: Automatic scheduler for SAS job

siddharthpeesary — Wed, 25 Nov 2015 19:14:36 GMT

I will check it thanks

Re: Automatic scheduler for SAS job

SASKiwi — Wed, 25 Nov 2015 19:16:40 GMT

The Windows task scheduler can be used with SAS but it can only do time scheduling, not file event scheduling. You would need to either use a third-party scheduler of your choice that can do file events or add a file exist check to your SAS job.

Re: Automatic scheduler for SAS job

siddharthpeesary — Wed, 25 Nov 2015 19:19:03 GMT

Atually i want to write sas program required to create a file in database, then i want to use a time schedule from windows

Re: Automatic scheduler for SAS job

SASKiwi — Wed, 25 Nov 2015 19:24:33 GMT

If you don't want to check for the existence of your input file in the scheduler then the Windows scheduler in your Control Panel can just do the time scheduling.

Re: Automatic scheduler for SAS job

siddharthpeesary — Wed, 25 Nov 2015 19:27:44 GMT

Kiwi I have to check the existence of file inside the sas job

Re: Automatic scheduler for SAS job

LinusH — Wed, 25 Nov 2015 20:42:24 GMT

@siddharthpeesary first you say you want a program to check the file without opening SAS. Then you say that the SAS program need to do this. Contradictory.

If you want a scheduler/OS script to this, you need to search on such forum instead, not SAS communities.

If you need a SAS program to do the check, there are lots of external file functions in SAS that are useful in situations like this.

Re: Automatic scheduler for SAS job

SASKiwi — Wed, 25 Nov 2015 20:46:25 GMT

In that case check out the FILEEXIST function as it will do what you require:

http://support.sas.com/documentation/cdl/en/lefunctionsref/67960/HTML/default/viewer.htm#n06xm8hwk0t0axn10gj16lfiri43.htm