I have a string variable that contains numeric values and alphanumeric values. For instance:
var1
123
B23
3244
V190
I want:
var1 var2
123 .
. B23
3244 .
. V190
is there anyway to do this in SAS?
something like this?
data have;
input var1 $ @@;
datalines;
123 B23 3244 V190
;
run;
data want;
set have;
if anyalpha(var1)>0 then do; var2=var1; call missing(var1); end;
run;
proc print data=want noobs; run;
Thanks Wong,
This code worked for what I wanted.
Then please mark the question as answered.
Is the letter always the first character of the string?
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 16. 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: