The SAS Output Delivery System and reporting techniques

Maintaining Formats in ods excel

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Maintaining Formats in ods excel

[ Edited ]

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


Accepted Solutions
Solution
‎02-28-2016 02:33 AM
SAS Super FREQ
Posts: 683

Re: Maintaining Formats in ods excel

hi

 

as a workaround you can use:

tagattr='typeSmiley Frustratedtring'

 

Below is an example

 

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

Bruno

View solution in original post


All Replies
Solution
‎02-28-2016 02:33 AM
SAS Super FREQ
Posts: 683

Re: Maintaining Formats in ods excel

hi

 

as a workaround you can use:

tagattr='typeSmiley Frustratedtring'

 

Below is an example

 

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

Bruno

New Contributor
Posts: 2

Re: Maintaining Formats in ods excel

Thank you Bruno
☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 386 views
  • 1 like
  • 2 in conversation