%macro break(byval);
data work.age_&byval;
set work.sorted(where=(age=&byval));
run;
%mend;
proc sort data=sashelp.class out=work.sorted;
by age;
run;
options mprint;
data _null_;
set work.sorted;
by age;
if first.age then call execute('%break('||age||')');
run;
concatenation
Sorry I don't understand why there is concatenation here. The files are produced as age_11, age_12...
It is concatenating the string that is being sent. In short, it is submitting:
%break(16)
which will run the macro with the variable's value
Can I ask how '||age||' became the value of the variable?
Thanks for help.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.