You already have three good answers, but here is a fourth. It uses the untranspose macro and would really simplify the task if you were untransposing more than one variable.
filename ut url 'http://tiny.cc/untranspose_macro';
%include ut ;
%untranspose(data=have, out=want (rename=(day_=Vent_status)),
by=UUID, prefix=Vent_, id=Day,
var=day_, missing=yes, var_first=yes)
Art
... View more
