topic Re: Call all programs in a folder in SAS Procedures

Call all programs in a folder

rakeshvvv — Fri, 12 Sep 2014 13:09:31 GMT

I have folder and that has around 50-60 sas programs…. I would like to know if I can write a program to call all the programs in that folder….…….

Re: Call all programs in a folder

jakarman — Fri, 12 Sep 2014 13:22:37 GMT

You can do a directory listing and do an execute with an %include of all of them. Possible yes. Does it make sense? hardly.

What problem do you trying to solve? Is it about autocalling macros?

Re: Call all programs in a folder

rakeshvvv — Fri, 12 Sep 2014 13:28:07 GMT

I have around 60 programs which would creating listings for different scenarios.....Every week i have run them....so i have to call them individually....... I am just wondering if there is any option where we can save all those programs in a folder and write a program to call all those program located in that particular folder instead of running them individually........

Re: Call all programs in a folder

jakarman — Fri, 12 Sep 2014 14:02:09 GMT

You are describing a scheduling facility, if you have no scheduler there are ways to simulate that.
The best thing is when they are all independent, no ordering just a start program.
Do not use the %include but run it as MP-Connect, SAS-connecte licensed? or batch schript, (X-cmd open?

Reading the filenames in a directory is an easy part. Using Dopen dinfo will make it machine independent

http://support.sas.com/documentation/cdl/en/hostwin/67279/HTML/default/viewer.htm#p0qzctpnc6pi8sn1qcuv81rls13c.htm#n10k6grg16q25dn17wxmhlf1bfv4

If you have a script every week running eg 03:00u am monday. (cron or whatever) you can read those names and start those.
What to do with the logging? results? returncode?

Re: Call all programs in a folder

ballardw — Fri, 12 Sep 2014 14:55:26 GMT

If you need them to run in a specific order then use of %Include is probably the way to go.

Create a SAS program that looks something like;

%include "c:\programfolder\prog1.sas";

%include "c:\programfolder\prog2.sas";

%include "c:\programfolder\prog3.sas";

If you have a long path it may be easier to have a macro variable hold it

%let folder = C:\folder\anotherfolder\program folder;

and then

%include "&folder.\prog1.sas";

Re: Call all programs in a folder

Tom — Fri, 12 Sep 2014 16:39:43 GMT

You might be best to create an operating system command to do this. For example in ksh on Unix you would just use this simple one line program.

for x in $(ls *.sas) ; do sas $x ; done

Of course if you want to check if the individual jobs completed correctly or other conditional processing decisions the task would get harder. If you have a scheduling tool then perhaps you might want to use that.

You could write a SAS program. If you don't care if the programs run in a separate session you can just %INCLUDE all of them.

%include "*.sas";

But that is a big IF because there can be serious side effects from running multiple independent programs in a single session.

If you have access to X commands then you can have SAS do what the FOR loop in KSH above was doing.

data _null_;

infile "ls *.sas" pipe truncover ;

input program $256.;

command=catx('sas',program);

infile execute pipe filevar=command end=eof ;

do while (not eof);

input;

put _infile_;

end;

run;

Re: Call all programs in a folder

Ksharp — Sat, 13 Sep 2014 15:01:21 GMT

data _null_;

infile "dir c:\temp\*.sas /s /b " pipe truncover ;

input program $256.;

call execute(catx(' ','%inc',quote(program),';')) ;

run;

Re: Call all programs in a folder

Reeza — Sat, 13 Sep 2014 17:05:44 GMT

Use %include with a wildcard, though the order may not be what you want:

%include 'path to folder\*.sas';

Re: Call all programs in a folder

Patrick — Sun, 14 Sep 2014 04:15:15 GMT

You could use a OS shell script as Tom suggests, or %include (but this executes everything as a single program), or MP connect.

Systask would be another option 6814 - Example of SYSTASK COMMAND statement to start a SAS batch job within aSAS program as it allows you to run programs independently, in sequence or in parallel (in combination with the "waitfor" statement) like you could do with a shell script - but you can code everything in SAS which is may be syntax you're more familiar with.

Re: Call all programs in a folder

PegasusTT77 — Thu, 07 Jun 2018 14:50:39 GMT

Thank you 🙂