looking for a number in a sequence

[No-body]

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 

[Reeza]

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

[No-body · Accepted solution]

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;

[No-body]

Sorry I ment to say proc freq; data = test1

[Reeza]

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;

[No-body]

Thanks for you help.

[Reeza]

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

[No-body]

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