topic Re: find the number in SAS Programming

find the number

asuman — Mon, 12 Nov 2018 16:17:09 GMT

the data set contains many variable of character and numeric types but i need to print only those number having length equals 12 and it should be numbers.

kindly help.(No macros)

Re: find the number

novinosrin — Mon, 12 Nov 2018 16:18:43 GMT

Hi @asuman Can you post a sample along with your description plz

Re: find the number

asuman — Mon, 12 Nov 2018 16:21:36 GMT

data a;

input id;

cards;

123456789012

1234567890qa

123456

asdghjj098752

123456789087654

run;

need to print only those records having length=12 and it should be numbers only.

Re: find the number

novinosrin — Mon, 12 Nov 2018 16:25:55 GMT

Are you after this?

data a;

input id $30.;

cards;
123456789012
1234567890qa
123456
asdghjj098752
123456789087654
run;

data want;
set a;
if notdigit(strip(id))=0 and length(strip(id))=12;
run;

Re: find the number

novinosrin — Mon, 12 Nov 2018 16:49:22 GMT

Or the other possibility being eliminate non digit values using compress and filter based on length


data a;

input id $30.;

cards;
123456789012
1234567890qa
123456
asdghjj098752
123456789087654
run;

data want;
set a;
if  length(compress(strip(id),,'kd'))=12;
run;

Re: find the number

asuman — Mon, 12 Nov 2018 16:56:13 GMT

Both solutions works perfectly.

thanks novinosrin.

Regards,

aditya suman