tagsets.excelxp: Excel convert the data?

RD2 — Wed, 30 Nov 2011 09:33:29 GMT

Run following program in SAS 9.3

------------------------------------------------

data work.test;

infile cards firstobs=2;

input LABCODE $ ;

cards;

LABCODE

01E01

01E02

01E03

01E08

AAAAA

;

run;

ods tagsets.excelxp style=sasweb file="C:\temp\test.XLS ";

proc print data=test noobs label;

run;

ods tagsets.excelxp close;

----------------------------------------

In EXCEL 2007, output EXCEL sheet LABCODE become

100

1000

100000000

AAAAA

Is there any option to avoid this convertion?

OS2Rules — Wed, 30 Nov 2011 14:10:21 GMT

Hi:

You just need to force the Excel output to be in text rather than a number....

use: style(column)={tagattr='format:@'}

to format the variable in the print.

topic tagsets.excelxp: Excel convert the data? in ODS and Base Reporting