- data t1;
- input id $ date quan price;
- datalines;
- 1 1 10 2
- 1 2 9 2
- 2 1 8 2
- 2 2 7 2
- 2 3 6 2
- 3 2 5 2
- mm 5 4 2
- ;
- run;
- proc sort data=t1(keep=id) out=t2 nodupkey;by id ;run;
- data t2;
- set t2;
- do date=1 to 10;
- call missing(quan,price);
- output;
- end;
- run;