Thank you, Astounding. Actually, this is a simplified example so your intuition is correct, there are in fact 7 reviewers so I would have reviewer_A to reviewer_G. Note that only two reviewers would ever review a single study. In this case, would a correct code modification for the 7 reviewer situation be: data want; set have; array abcdefg {7} reviewer_A reviewer_B reviewer_C reviewer_D reviewer_E reviewer_F reviewer_G; array new {2} $ 8 reviewer_1 reviewer_2; i=0; do j=1 to 7; if abcdefg{j} > ' ' then do; i + 1; if i < 3 then new{i} = abcdefg{j}; end; end; drop i j reviewer_A reviewer_B reviewer_C reviewer_D reviewer_E reviewer_F reviewer_G; run; ?? Many thanks again.
... View more