topic Re: To run multiple programs by a single code in SAS Programming

To run multiple programs by a single code

AKHILA — Tue, 16 Jun 2020 10:24:43 GMT

Hi all,

I have some 5 programs ,say for eg: pgm1.sas, pgm2.sas, pgm3.sas. etc which i am saving in the same location. let it be D:\Path.

Is there any way to use a single %include statement to run all this programs at once?

Please help me for this.

Re: To run multiple programs by a single code

Patrick — Tue, 16 Jun 2020 10:27:04 GMT

With "at once" do you mean "in parallel"?

Re: To run multiple programs by a single code

AKHILA — Tue, 16 Jun 2020 10:30:13 GMT

I mean simply to run all 5 pgms parellel or one after other to get the 5 outputs.

Re: To run multiple programs by a single code

Kurt_Bremser — Tue, 16 Jun 2020 10:36:23 GMT

You can use one %INCLUDE statement by specifying the "aggregate storage location" (in this case, a directory) first:

filename progdir "D:\Path";

%include progdir(pgm1,pgm2,pgm3,pgm4,pgm5);

Note that this will run the included codes in succession.

If you want to run several SAS programs simultaneously, you need to run several SAS sessions in parallel.

Re: To run multiple programs by a single code

gamotte — Tue, 16 Jun 2020 10:36:31 GMT

Hello,

Something like this ?

filename a ("c:/temp/a.sas" "c:/temp/b.sas");

%include a;

Re: To run multiple programs by a single code

Jagadishkatam — Tue, 16 Jun 2020 10:37:22 GMT

Instead of %include, you can use the batch file to run , please let me know if your sas session is in unix/linux

Re: To run multiple programs by a single code

Patrick — Tue, 16 Jun 2020 10:37:52 GMT

If what you're asking for here is not just a "dumed-down" version of your real problem then just having five %include statements is by far the easiest and easiest to maintain option.

If the real problem you want to solve is of higher complexity then please share.

Re: To run multiple programs by a single code

AKHILA — Tue, 16 Jun 2020 10:44:39 GMT

Thanks for the suggestion. but in future if i add more programs how can i dynamically add those without entering in %include statement.

Can you please suggest some macros?

Re: To run multiple programs by a single code

MCoopmans — Tue, 16 Jun 2020 11:06:07 GMT

Maybe this is doing the trick:

%let path=c:\temp;


filename sasfiles "&path";

data files;
 
 did=DOPEN("sasfiles");
 do i=1 to DNUM(did);
  name=dread(did,i);
  ext=SUBSTR(name,INDEX(name,".")+1);
  path="&path\" ||name ;
  if UPCASE(ext)="SAS" then do;
    output;
	call execute ("%include '"|| path  || "';");
    *put name= ext=;
	end;
 end;
run;

Re: To run multiple programs by a single code

PaigeMiller — Tue, 16 Jun 2020 11:09:46 GMT

Does the order the programs are run make a difference? Or will any order work?

Re: To run multiple programs by a single code

AKHILA — Tue, 16 Jun 2020 11:20:00 GMT

any order is fine

Re: To run multiple programs by a single code

Ksharp — Tue, 16 Jun 2020 11:33:03 GMT

Not sure if the following could work.

%include "D:\Path\pgm*.sas" ;

Re: To run multiple programs by a single code

Kurt_Bremser — Tue, 16 Jun 2020 11:34:10 GMT

How do you add your programs? If you simply put them into a specific directory, and all programs in that directory need to be run, then @MCoopmans's code will do the trick.

@AKHILA wrote:

Thanks for the suggestion. but in future if i add more programs how can i dynamically add those without entering in %include statement.

Can you please suggest some macros?