data required;
input cycle $;
datalines;
C1
C2
C3
C4
C5
C6
C7
;
data have;
input subject $ cycle $;
cards;
Sub1 C1
Sub1 C2
Sub1 C5
Sub2 C1
Sub2 C2
Sub2 C3
Sub2 C7
;
proc sql;
create table temp as
select subject,
min(input(compress(cycle,,'kd'),best.)) as min,
max(input(compress(cycle,,'kd'),best.)) as max
from have
group by subject;
quit;
data temp2;
set temp;
length cycle $ 20;
do i=min to max;
cycle=cats('C',i);output;
end;
keep subject cycle;
run;
proc sql;
create table want as
select * from temp2
except
select * from have;
quit;
... View more
