topic Re: Extract only numeric values which is in charcter value in SAS Programming

Extract only numeric values which is in charcter value

Aayushi_17 — Thu, 29 Nov 2018 12:24:40 GMT

Hi i want to get only numeric values where this is the input

data have;
length var1 $30.;
var1='hdhdxha82873jdjsd';output;
var1= 9293293991 ;output;
var1='123431hud';output;
var1=1223444;output;
run;

and the required output is

var1

9293293991

1223444

How can I extract just the numeric values. thanks

RW9 — Thu, 29 Nov 2018 13:08:52 GMT

data want;
  set have;
  if lengthn(compress(var1,"","d"))=0 then output;
run;

Aayushi_17 — Thu, 29 Nov 2018 17:15:47 GMT

but what if that var1 has decimal value like this var1= 929329.3991 ;output; will it be able to get the output

Aayushi_17 — Thu, 29 Nov 2018 17:24:12 GMT

Thanks for your quick response.

RW9 — Fri, 30 Nov 2018 08:51:38 GMT

data want;
  set have;
  if lengthn(compress(var1,".","d"))=0 then output;
run;