Use BY processing combined with an explicit output statement. You may have to tweak this if you want to maintain the order, and if you want to include character and numeric values in a single column - it will have to be a character variable.
data want;
set have;
by prod;
if first.prod then do;
output;
comp=prod;
output;
end;
else output;
run;
... View more