topic Re: Creating a run book for different code to run in SAS Programming

Creating a run book for different code to run

Nitish1003 — Tue, 28 Nov 2023 18:19:58 GMT

Hi All,

I am trying to create a run book to have all my code in one place with %include statement.

I have a job code and code name. What I did is I created a dataset with Job_Code, code_name and added Sn_no. Now I am trying to create a macro so that I can pass the Sn_no and that particular code should get executed.

Any suggestion on how should I proceed with this? Thanks a lot for looking into it

Re: Creating a run book for different code to run

Reeza — Tue, 28 Nov 2023 18:31:33 GMT

%macro run_snno(sn_no=);

data _null_;
set jobs;
where sn_no = &sn_no.;
rc = dosubl(catt("%include('", code_name, "');"));
run;


%mend;

One possibility.

If you want to pass multiple SN_NO this could be expanded to use IN instead easily.

@Nitish1003 wrote:

Hi All,

I am trying to create a run book to have all my code in one place with %include statement.

I have a job code and code name. What I did is I created a dataset with Job_Code, code_name and added Sn_no. Now I am trying to create a macro so that I can pass the Sn_no and that particular code should get executed.

Any suggestion on how should I proceed with this? Thanks a lot for looking into it

Re: Creating a run book for different code to run

Nitish1003 — Wed, 29 Nov 2023 16:55:26 GMT

Thanks a lot this helped