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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.