proc expand

[RobP]

Just renewed our SAS license and I no longer have access to the SAS/ETS module.  I was wondering if someone could either run the below piece of code and post the results, or describe the results to me.

I know it creates 7day moving average calculations for the specified columns.  I was just wanting the exact output as I need to reproduce the results using a datastep now.

proc sort data=sashelp.stocks(obs=20) out=stocks;
  where stock eq 'IBM';
  by date;
run;

proc expand data=stocks out=mav;
  id date;
  convert open          = open_mav        
          high          = high_mav
          low           = low_mav    
          / transformin=(setmiss 0) transformout=(movave 7)
          ;
%runquit;

proc print data=mav;
run;

[Reeza · Accepted solution]

If you sign up for SAS Academics on Demand, it includes the SAS ETS module and you can test it yourself.