Maintaining Formats in ods excel

[effi_tesler]

Hi,

In tagset excelxp I can maintain a text cell by using  tagattr="@" 

It doesn't seem to  work in ods excel

What can I do to display a cell  that contains numbers as  text?

Example code:

data qa;

length a $19;

a='0001111111111111111';

run;

ods excel  tagset=ExcelXP file="&sasrepdev/qa.xlsx";

PROC PRINT DATA=qa NOOBS LABEL HEADING=H;

  VAR a           / style (data)=data {tagattr="@"};           

run;       

ods _all_ close;

The xlsx file contain a numeric cell and therefore the result is 1111111111111110

[BrunoMueller · Accepted solution]

hi

as a workaround you can use:

tagattr='type:String'

Below is an example

proc print data=qa noobs label ;
  var a / style (data)= {tagattr='type:String'};
run;

Bruno

[effi_tesler]

Thank you Bruno