topic Maintaining Formats in ods excel in ODS and Base Reporting

Maintaining Formats in ods excel

effi_tesler — Thu, 25 Feb 2016 15:23:25 GMT

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 — Thu, 25 Feb 2016 17:05:08 GMT

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 — Sun, 28 Feb 2016 07:34:32 GMT

Thank you Bruno