topic Re: How to find fancy number from the variable in SAS Programming

How to find fancy number from the variable

dishant — Fri, 26 Sep 2014 05:35:46 GMT

Hi All,

I want to find fancy numbers from the my variable. Below is the dummy example.

XYZ

123456

236514

412356

543216

621345

321456

.....

Please help me out to finding the fancy numbers from my variable.

Your help will help me a lot. thanks in advance.

Regards,

Dishant

Re: How to find fancy number from the variable

RamKumar — Fri, 26 Sep 2014 05:40:20 GMT

what do you mean by fancy numbers? what is your desired output?

Can we imagine that your variable 'XYZ' is numeric?

Re: How to find fancy number from the variable

dishant — Fri, 26 Sep 2014 05:47:33 GMT

Ram,

Please find my below explanation.

Dummy Data :

XYZ

123456

236514

454732

412356

947284

543216

621345

495345

321456

......

My Desired Output :

XYZ

123456

236514

412356

543216

621345

321456

.....

Fancy number means looks Same only pattern will differ.

If any concerns please let me know.

Re: How to find fancy number from the variable

gergely_batho — Fri, 26 Sep 2014 07:16:58 GMT

Are you looking for numbers, that have digits: 1, 2,3, 4, 5, 6 in any order?

Re: How to find fancy number from the variable

dishant — Fri, 26 Sep 2014 07:25:12 GMT

Correct.

But not only 1,2,3,4,5,6, It can be any number. Likewise see the below one.

XYZ

789123

897321

137892

...

So It want to show those Observations who having different pattern but same Numbers.

Re: How to find fancy number from the variable

gergely_batho — Fri, 26 Sep 2014 07:30:25 GMT

And where is the pattern given? Is it the first row? Or you want to find all the "fancy groups" in your dataset?

Re: How to find fancy number from the variable

dishant — Fri, 26 Sep 2014 07:32:21 GMT

Yes, I want to find all the "fancy groups" in your dataset.

There is no such pattern given.

Re: How to find fancy number from the variable

Loko — Fri, 26 Sep 2014 07:51:29 GMT

Hello,

One solution:

data have;
input XYZ;
datalines;
123456
236514
454732
412356
947284
543216
621345
495345
321456
;

data want;
set have;
do i=1 to 6;
if find(put(xyz,6.),put(i,1.)) = 0 then do;goto pass;end;
end;

output;

pass: ;
run;

Re: How to find fancy number from the variable

gergely_batho — Fri, 26 Sep 2014 08:08:35 GMT

data have;

input XYZ;

datalines;

123456

236514

454732

412356

947284

543216

621345

495345

321456

;

run;

data tmp(keep=position XYZ key );

set have;

position=_n_;

length key $ 6;

array digits[6] $ 1;

do i=1 to dim(digits);

digits=substr(put(XYZ,6.),i,1);

end;

call sortc(of digits

);

key=cats(of digits

);

run;

proc sort data=tmp out=want;

by key;

run;

Message was edited by: Gergely Bathó

Re: How to find fancy number from the variable

RW9 — Fri, 26 Sep 2014 08:27:52 GMT

One suggestion, if you want to pull out sequences where the numbers 1-6 appear in any order, why not generate a dataset with all the possibilities, then do a where in that list:

data have;
input XYZ;
datalines;
123456
236514
454732
412356
947284
543216
621345
495345
321456
;
run;

data sequence;
seq=111111;
do until (seq=666666);
output;
seq=seq+1;
end;
run;

proc sql;
create table WANT as
select *
from WORK.HAVE
where XYZ in (select distinct SEQ from WORK.SEQUENCE);
quit;

Re: How to find fancy number from the variable

stat_sas — Fri, 26 Sep 2014 12:12:41 GMT

data want(drop=i cum);

set have;

cum=0;

do i=1 to 6;

cum + input(substr(put(xyz,6.),i,1),1.);

end;

if cum=21;

run;