topic Find out Same Digit repeated continuously in SAS Programming

Find out Same Digit repeated continuously

sas_lak — Tue, 17 Feb 2015 04:56:50 GMT

Hi,

I am looking here to get any Digit is continuously repeated more than 6 times from Security_No.

Sl_No	Security_No
1	111111111112
2	989898989898
3	111111111111
4	910000000000
5	999999999990
6	128390203040
7	127777777771
8	739349340595
9	634995038404

Thanks in Advance....!

Re: Find out Same Digit repeated continuously

Ksharp — Tue, 17 Feb 2015 05:50:38 GMT

data have;

input Sl_No Security_No : $20.;

cards;

1 111111111112

2 989898989898

3 111111111111

4 910000000000

5 999999999990

6 128390203040

7 127777777771

8 739349340595

9 634995038404

;

run;

data want;

set have;

if prxmatch('/0{6,}|1{6,}|2{6,}|3{6,}|4{6,}|5{6,}|6{6,}|7{6,}|8{6,}|9{6,}/o',Security_No);

run;

Xia Keshan

Re: Find out Same Digit repeated continuously

FriedEgg — Tue, 17 Feb 2015 18:05:42 GMT

Here is an alternative to using regular expression.

data foo;

input Sl_No Security_No : $12.;

do rept_int=0 to 9 while (_n_>0);

if find(Security_No, repeat(put(rept_int,1.),5)) then do;

_n_=0;

output;

end;

cards;

1 111111111112

2 989898989898

3 111111111111

4 910000000000

5 999999999990

6 128390203040

7 127777777771

8 739349340595

9 634995038404

;

run;

Re: Find out Same Digit repeated continuously

sas_lak — Thu, 19 Feb 2015 11:43:16 GMT

Thank you...!