I spent significant amount of time experimenting with %str and %bquote but without success.
Code:
%let year = 2019;
%let lable = %sysfunc(cat(text,%str(%(&year.),text)); %put &=lable;
Result:
text(2019text
Desired result:
text(2019)text
When I try to mask the second bracket I get errors.
No masking needed at all:
%let year=2019;
%let lable=text(&year.)text;
%put lable=&lable.;
Log:
37 %let year=2019; 38 39 %let lable=text(&year.)text; 40 41 %put lable=&lable.; lable=text(2019)text
No masking needed at all:
%let year=2019;
%let lable=text(&year.)text;
%put lable=&lable.;
Log:
37 %let year=2019; 38 39 %let lable=text(&year.)text; 40 41 %put lable=&lable.; lable=text(2019)text
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.