BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
effi_tesler
Calcite | Level 5

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

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

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

View solution in original post

2 REPLIES 2
BrunoMueller
SAS Super FREQ

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
Calcite | Level 5
Thank you Bruno

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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