Here is how to do this with proc expand: data have;
input id qtr :yyq6. x;
format qtr yyq6.;
datalines;
1 2009Q1 1
1 2009Q3 2
2 2010Q1 3
2 2011Q1 4
2 2011Q2 5
;
proc expand data=have out=want to=qtr method=none;
by id;
id qtr;
run;
proc print data=want noobs; run;
... View more
