proc sort data=stock.test out=test;
  by stockcode descending date;
run;

proc expand data=test Out=testout method=none;
        by stockcode;
        convert nclose = max5_close / transformout = (movmax 5);
        convert nclose = max60_close / transformout = (movmax 60);
        convert nclose = max250_close / transformout = (movmax 250);
run;

proc sort data=testout out=testfinal;
  by stockcode date;
run;