Hi SAS Team, by taking num field as reference we need to pull the missing numbers in the output by subj and week wise. for sub 01 and week w1 we have 1,2&5 numbers so here 3&4 are missing. for sub 01 and week w2 we have 1,5&3 numbers so here 2&4 are missing. for sub 02 and week w3 we have 7&5 numbers so here 1,2,3,4&6 are missing. data Have; input sub week$ num; cards; 01 w1 1 01 w1 2 01 w1 5 01 w2 1 01 w2 5 01 w2 3 02 w3 7 02 w3 5 ; run; so all these missing numbers should come in the output as shown below. sub week num 1 w1 3 1 w1 4 1 w2 2 1 w2 4 2 w3 1 2 w3 2 2 w3 3 2 w3 4 2 w3 6 Regards, Raju
... View more