Amounts exported in Excel

[fabdu92]

Hi,

I try to export a table to Excel, with a simple PROC EXPORT.

But some formats are destroyed.

For example I have some amounts values, formats 15.2 in my SAS table, which have, after exporting, 4 decimals in my Excel spreadsheet.  I'm sure you will agree that is a nonsense for amounts...

Is there anything I can do to avoid this? Or is it an Excel problem?

Thanks for answers.

[naveenraj]

using ODS tagsets.EXCELXP, will give you control over the format of the cells.

eg:
ODS tagsets.ExcelXP
FILE="&out\format.xls";
PROC PRINT DATA=test;
VAR name;
VAR height / STYLE={TAGATTR='format=0.00'};
RUN;
ODS tagsets.ExcelXP CLOSE;

[RW9]

Proc export won't, this is a feature of Excel trying to be helpful.  If you output to a tagset, Excelxp for example, then you can force formats onto the value use the tagattr option.  However this then creating XML output which may or may not be ok for you.

[Reeza]

ODS Excel is a great option if you have SAS 9.4M3