data test;
infile cards missover;
input id date g g0 g6 g24;
cards;
875 6 1.149237
56 24 0.692732
11 0 1.00089
37 0 1.178934
37 6 0.534396
37 24 0.608486
run;
data test1;
set test;
if date = 0 then g0 = g;
if date = 6 then g6 = g;
if date = 24 then g24 = g;
drop date g;
run;
data test;
infile cards missover;
input id date g g0 g6 g24;
cards;
875 6 1.149237
56 24 0.692732
11 0 1.00089
37 0 1.178934
37 6 0.534396
37 24 0.608486
run;
data test1;
set test;
if date = 0 then g0 = g;
if date = 6 then g6 = g;
if date = 24 then g24 = g;
drop date g;
run;