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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.