thread376-1348461
When I am using tagsets.excelxp and use the 'tagattr' to format a variable in proc print or proc report, the values print out as all zeroes. If I take out the / style={tagattr='format:##0.0'} the values print again, but with no commas and various numbers of decimal places. What is going on? Please help. (ps. using the 'thousands_separator' option didn't work either)
sample code below----
ODS TAGSET.EXCELXP options(....);
Proc print data=test;
var price / style={tagattr='format:#,##0'} ;
run;
ODS _all_ CLOSE;
Any help/insight would be greatly appreciated! Thanks.
When I am using tagsets.excelxp and use the 'tagattr' to format a variable in proc print or proc report, the values print out as all zeroes. If I take out the / style={tagattr='format:##0.0'} the values print again, but with no commas and various numbers of decimal places. What is going on? Please help. (ps. using the 'thousands_separator' option didn't work either)
sample code below----
ODS TAGSET.EXCELXP options(....);
Proc print data=test;
var price / style={tagattr='format:#,##0'} ;
run;
ODS _all_ CLOSE;
Any help/insight would be greatly appreciated! Thanks.