topic Re: looking for a number in a sequence in SAS Enterprise Guide

looking for a number in a sequence

No-body — Tue, 25 May 2021 14:39:43 GMT

Hello;

I have a variable in a data called numbers and in the variable there are a set with numbers in it - lets say 1 to 9000.
I need to find any numbers that are not in the sequence - how do I do that?

Thanks

Re: looking for a number in a sequence

Reeza — Tue, 25 May 2021 15:02:47 GMT

Merge it with a set of data that is the full series and anything not in the range will be identified.

Re: looking for a number in a sequence

No-body — Tue, 25 May 2021 16:20:04 GMT

This was my idea then merge but is not working.

data verify;

set test;

do var = min(1) to max(9000); output;
end; drop min max; run;

data test1;
merge verify test; by number;
proc freq; data=test;
run;

Re: looking for a number in a sequence

No-body — Tue, 25 May 2021 16:26:33 GMT

Sorry I ment to say proc freq; data = test1

Re: looking for a number in a sequence

Reeza — Tue, 25 May 2021 16:28:27 GMT

Your log is probably full of errors because that's not valid code. This should get you started:

*generate verification data set;
data verify;
flag=1;
do number= 1 to 9000;
output;
end;
run;


*use IN data set options to identify where a record is coming from or use flag;
data test;
merge verify (in=t1) test (in=t2);
by number;
missing=0;
if t1 and not t2 then missing=1;
run;

Re: looking for a number in a sequence

No-body — Tue, 25 May 2021 16:44:37 GMT

Thanks for you help.

Re: looking for a number in a sequence

Reeza — Tue, 25 May 2021 17:05:52 GMT

Your answer isn't correct so marking that as the answer isn't right.

Re: looking for a number in a sequence

No-body — Tue, 25 May 2021 18:09:54 GMT

My apologizes I thought I marked what you gave me, I am new to this so still figuring it out.