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
%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
Thanks a lot this helped
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.