I would like to have some of the fields in my excel output formatted as currency and I need them to be formatted w/ 4 digits after the decimal point. How would I go about that? I tried this...
var billamt/ style={tagattr='format:Currency'];
...but I don't know how to indicate I want 4 digits after the decimal point rather than just 2.
Thanks!
Hi:
This is how I would do it. Excel shows me 4 decimal places for sales and 2 decimal places for returns.
cynthia
ods tagsets.excelxp file='c:\temp\currency.xml'
style=sasweb;
proc report data=sashelp.shoes nowd;
column product sales returns;
define product / group;
define sales / style(column)={tagattr='$#,##0.0000'};
define returns / style(column)={tagattr='$#,##0.00'};
run;
ods _all_ close;
Hi:
This is how I would do it. Excel shows me 4 decimal places for sales and 2 decimal places for returns.
cynthia
ods tagsets.excelxp file='c:\temp\currency.xml'
style=sasweb;
proc report data=sashelp.shoes nowd;
column product sales returns;
define product / group;
define sales / style(column)={tagattr='$#,##0.0000'};
define returns / style(column)={tagattr='$#,##0.00'};
run;
ods _all_ close;
Perfect. Thanks!
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 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.