proc expand

RobP — Thu, 30 Nov 2017 18:06:26 GMT

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;

Re: proc expand

Reeza — Thu, 30 Nov 2017 18:11:27 GMT

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

topic proc expand in SAS Procedures

proc expand

Re: proc expand