topic Re: How to separate string into numeric and character variables in SAS Programming

How to separate string into numeric and character variables

hanahch — Mon, 22 Aug 2022 05:01:22 GMT

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!

Re: How to separate string into numeric and character variables

PeterClemmensen — Mon, 22 Aug 2022 05:08:33 GMT

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;

Re: How to separate string into numeric and character variables

andreas_lds — Mon, 22 Aug 2022 05:53:13 GMT

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