The SAS Output Delivery System and reporting techniques

Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

Reply
New User
Posts: 1

Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

Hi

 

I am trying to increase the decimal places in the excel output that ODS EXCELXP tagsets generate. The SAS dataset does show about 5 decimal places, however, when I exporrt it using ODS I see only 2 decimal places.

 

Could you please let me know which format/procedure/etc could I use to increase the decimals in the output?

Super Contributor
Posts: 339

Re: Increase Decimal places in Excel using ODS TAGSETS EXCELXP option

Try:

 

Data A;
  Number=123; Output;
Run;

ODS Tagsets.ExcelXP File="D:\Test.xml" Style=HTMLBlue;
Proc Report Data=A;
  Column Number;
  Define Number/Display Style(Column)={TagAttr='Format:0.00000'};
Run;
ODS Tagsets.ExcelXP Close;

Ask a Question
Discussion stats
  • 1 reply
  • 400 views
  • 1 like
  • 2 in conversation