I have the below dataset which contains both character and numeric data as shown below :
data example;
length Var1 $10.;
input Var1 $;
datalines;
AB
CD
100
400
;
run;
Trying to output result by using input function shown below:
data cleaned_data;
set example;
Result = put(input(Var1, best3.), z3.);
run;
But after running this getting note :
Does below return what you're after?
data example;
input var1 :$10.;
datalines;
AB
CD
1.5
400
5
;
run;
data cleaned_data;
set example;
if notdigit(strip(var1)) then result=var1;
else result=put(input(var1, ?? best32.), z3.);
run;
proc print data=cleaned_data;
run;
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.