Hi Sandya,
i mimicked your code using the sashelp.class dataset like below
proc sql;
select name into :name1-:name19 from sashelp.class;
quit;
The above code will create the macro variables like name1,name2....; inorder to check if the macro variable is getting resolved in the format i created i used the fmtlib option, i found that it is not resolving and the reason for this is the syntax in the proc format value
proc format fmtlib;
value $tafmt 'X' = 'X (n="&name1")';
run;
the correct syntax would be as below
proc format fmtlib;
value $tafmt 'x'="x(n=&name1)";
run;
make sure that you put only once opening and closing quote for the label as "x(n=&name1)";. Hope this will be helpful.
Thanks,
Jagadish
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.