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

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

Walternate — Fri, 09 Jun 2023 13:21:07 GMT

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

Output:

missing_nums

Any help is much appreciated!

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

PaigeMiller — Fri, 09 Jun 2023 13:32:13 GMT

/* 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.