topic Re: extract numeric values and character values in SAS Programming

extract numeric values and character values

thanikondharish — Wed, 25 Jul 2018 13:56:54 GMT

data s ;

input id $ result $ ;

cards ;

111 482

112 854

113 neg

114 pos

115 45.5

;

extract numeric values and character values from result variable?

Re: extract numeric values and character values

novinosrin — Wed, 25 Jul 2018 13:59:16 GMT

data s ;

input id $ result $ ;

cards ;
111   482
112   854
113    neg
114    pos
;

data want;
set s;
n=compress(result,' ','kd');
c=compress(result,' ','d');
run;

Re: extract numeric values and character values

RW9 — Thu, 26 Jul 2018 07:45:59 GMT

Show what the output should look like. Do you want a numeric column with those which are numeric converted? Would you like separate datasets, etc? For columns:

data want;
 set s;
 if not anyalpha(result) then num_var=input(result,best.);
run;

Re: extract numeric values and character values

s_manoj — Wed, 25 Jul 2018 17:43:40 GMT

Hi,

Check below code

data want;
set s;
if input(result, best.) then numeric = result;
else char = result;
run;

Re: extract numeric values and character values

RW9 — Thu, 26 Jul 2018 07:45:37 GMT

You have warnings in that code though about converting text to numeric, actually I fell into the same trap as I forgot that ifn() will do the conversion regardless of the if part. I updated my code to avoid this.