Creating a run book for different code to run

[Nitish1003]

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 

[Reeza]

%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 

---

[Nitish1003]

Thanks a lot this helped