How to separate string into numeric and character variables

[hanahch]

Hello,

I'd like to separate alphanumeric string into numeric and character variables like below:

Data have:

Data want - how do I get the output like this:

I really appreciate your help!

Thank you!

[PeterClemmensen]

Try this

data have;
input text $20.;
datalines;
2.2         
10          
15          
not reported
missing     
<5          
12.4        
;

data want;
   set have;
   if input(text, 8.) then num = input(text, 8.);
   else char = text;
run;

[andreas_lds · Accepted solution]

or

data want;
   set have;
   num = input(text, ?? 8.);
   if missing(num) then char = text;
run;