Hello,
Produce a dataset that is complete (all keys present!).
Then check which of these keys are not present in your "real" dataset;
data work.all_keys;
LENGTH ID $ 5;
input ID $ 1-5;
cards;
00001
00002
;
run;
data work.all_keys;
set work.all_keys;
do key='01','02','03','04','05','06','07';
output;
end;
run;
proc sort data=work.all_keys; by ID key; run;
data work.real_keys;
LENGTH ID $ 5 key $ 2;
input ID $ 1-5 key $ 7-8;
cards;
00001 01
00001 02
00001 04
00001 07
00002 01
00002 02
00002 03
00002 04
00002 06
;
run;
proc sort data=work.real_keys; by ID key; run;
data missing_keys;
merge work.all_keys(in=a)
work.real_keys(in=b);
by ID key;
if a and NOT b then output;
run;
/* end of program */
Regards,
Koen
... View more