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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.