%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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.