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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.