topic Excelxp - currency style in ODS and Base Reporting

Excelxp - currency style

Chip — Fri, 18 Nov 2011 14:19:15 GMT

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!

Re: Excelxp - currency style

Cynthia_sas — Fri, 18 Nov 2011 14:36:07 GMT

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;

Re: Excelxp - currency style

Chip — Fri, 18 Nov 2011 14:51:24 GMT

Perfect. Thanks!