topic Re: Running all the programs in a directory in SAS Programming

Running all the programs in a directory

Daniela_P — Thu, 13 Oct 2016 14:10:38 GMT

Dear experts,

I'd like to run all the programs (110) in a directory on my pc with a single instruction.

How could I do it with %include, or some other code?

The programs have different names and are very long. I'd like not to write them all in the enhanced editor, neither to write all their names...

Many thanks to all.

Daniela

Re: Running all the programs in a directory

Astounding — Thu, 13 Oct 2016 14:15:32 GMT

Do they have to run in a certain order, or will any order be sufficient?

Re: Running all the programs in a directory

ballardw — Thu, 13 Oct 2016 17:29:49 GMT

%include is likely to be your best bet.

And you shouldn't have to type anything as any file manager worth it's name should let you copy and paste path and/or file names.

An exercise for the interested reader is to use a FILENAME that consistis of and operating system command to pipe the name of the files using something like DIR c:\path\*.SAS to a data step and then use Call Execute to do the include. NOTE: DO not save the resulting program in the same folder as future runs could create multiple references (or use logic to explicitly NOT use that file for the %include).

Re: Running all the programs in a directory

RW9 — Thu, 13 Oct 2016 14:58:37 GMT

Its rarely as simple as pulling in a directory listing and including each file. What about interdependancies? How to QC? Where to send outputs? How to check inputs etc.

Re: Running all the programs in a directory

Daniela_P — Thu, 13 Oct 2016 16:04:33 GMT

...any order is good

Re: Running all the programs in a directory

Ksharp — Fri, 14 Oct 2016 06:28:08 GMT

filename x 'c:\temp\*.sas';
%include x/source2;

Re: Running all the programs in a directory

Daniela_P — Fri, 14 Oct 2016 14:07:58 GMT

Thank you very much,

it worked!

Daniela