Hello Community,
I am just following up with my question in Check if the variable is numeric then convert to Char .
Thank you all for your valuable replies.
In my case I am reading from different XML files, So I dont know if it is numeric or character datatype originally. So ideally what I need to do is something like
%if (%sysfunc(vartype(xyz.myVar)) = N) %then %do;
put(xyz.myVar,$5.);
%end
proc sql;
create table abc as
select myvar
from xyz;
quit;
In this way no matter what the data type is , I can always read a character.
Please help
I think the CAT solution proposed would work, did that not work for your for some reason?
option missing='';
data class;
set sashelp.class;
if name in ('Alfred' 'Jane') then age=.;
run;
proc sql;
create table want as
select name, catt(age) as age, weight, height
from class;
quit;
I think the CAT solution proposed would work, did that not work for your for some reason?
option missing='';
data class;
set sashelp.class;
if name in ('Alfred' 'Jane') then age=.;
run;
proc sql;
create table want as
select name, catt(age) as age, weight, height
from class;
quit;
Thank you for the quick reply.
Although this one runs and changes the data type ; the value is missing
@jjames1 wrote:
Thank you for the quick reply.
Although this one runs and changes the data type ; the value is missing
I don't understand what that means.
Hello Reeza,
It was an error from my side.
This way of conversion worked.
Thank you so much 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.