topic Re: Auto run SAS Programs in SAS Programming

Auto run SAS Programs

BaileyY — Sun, 27 Oct 2019 15:59:25 GMT

Hi.

I have multiple programs (10) in a folder. They are lengthy. Is there a SAS script that can allow me to write string of code to tell SAS to run all Programs within that folder? Thank you. Example: My SAS programs and original table files D:\Data_Trending

Auto run SAS Codes

BaileyY — Sun, 27 Oct 2019 17:00:05 GMT

Hi.

Re: Auto run SAS Codes

Cynthia_sas — Sun, 27 Oct 2019 17:14:43 GMT

Hi:
You already posted this question in the SAS Programming forum, here: https://communities.sas.com/t5/SAS-Programming/Auto-run-SAS-Programs/m-p/599648#M173127 and that is probably a better place for the question than the Procedures forum.
Cynthia

Re: Auto run SAS Programs

Reeza — Sun, 27 Oct 2019 17:24:49 GMT

I've merged your posts into one, please do not post the same question multiple times.

You can use %INCLUDE with a wild card to call all programs but they may not run in the order you want.

%include 'D:\Data_Trending\*.sas' / source2 lrecl=500;

SOURCE2 tells SAS to still put the code to the log and LRECL specifies the line length of the input program, the default is 256 I believe which can sometimes truncate your code causing issues.

@BaileyY wrote:

Hi.

I have multiple programs (10) in a folder. They are lengthy. Is there a SAS script that can allow me to write string of code to tell SAS to run all Programs within that folder? Thank you. Example: My SAS programs and original table files D:\Data_Trending

Re: Auto run SAS Programs

VDD — Sun, 27 Oct 2019 17:28:19 GMT

Hello @BaileyY a quick searched reveals many solution to your question.

here is one possible solution.

%macro run_one (path);
   proc printto log="&path.log";
   run;
   proc printto print="&path.lst";
   run;
   %include "&path.sas";
   run;
%mend run_one;

Re: Auto run SAS Programs

BaileyY — Sun, 27 Oct 2019 20:28:00 GMT

Thank you so much!! You are my favorite for responses. I am not an expert SAS programmer and some of the existing code on this forum can be difficult to understand and translate. You always provide exceptional explanation with your help. So appreciate you on this forum! Thank you!