The SAS Output Delivery System and reporting techniques

tagsets.excelxp: Excel convert the data?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

tagsets.excelxp: Excel convert the data?

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

10

100

1000

100000000

AAAAA

Is there any option to avoid this convertion?


Accepted Solutions
Solution
‎11-30-2011 09:10 AM
Super Contributor
Posts: 358

tagsets.excelxp: Excel convert the data?

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.

View solution in original post


All Replies
Solution
‎11-30-2011 09:10 AM
Super Contributor
Posts: 358

tagsets.excelxp: Excel convert the data?

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 160 views
  • 0 likes
  • 2 in conversation