data have;
input Group$ Value;
datalines;
A .
A .
A .
A 1
A .
B .
B .
B 1
B .
B .
;
run;
data want;
merge have
have(keep=Group Value rename=(Group=Group1 Value=Value1 ) firstobs=2)
have(keep=Group Value rename=(Group=Group2 Value=Value2 ) firstobs=3);
Value=coalesce( Value, ifn(Group=Group1,Value1,.),ifn(Group=Group2,Value2,.) );
drop Group1 Value1 Group2 Value2;
run;
... View more
