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
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
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
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!
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.
Ready to level-up your skills? Choose your own adventure.