How to build an output indicating which numbers in a range are not present

[Walternate]

Hi,

I have a dataset with distinct numbers from 1-200. What I want is to build an output which indicates the numbers that are NOT represented in the range, like so:

Data:

var1

1

2

3

5

6

7

9

12

Output:

missing_nums

4

8

10

11

Any help is much appreciated!

[PaigeMiller · Accepted solution]

/* Untested code*/
data all;
    do i=1 to 200;
        output;
    end;
run;
proc sql;
    create table missing as select i from all
    where i not in (select distinct var1 from have);
quit;

If you want tested code, you need to provide data as working SAS data step code.