Help using Base SAS procedures

proc expand

Accepted Solution Solved
Reply
Contributor
Posts: 27
Accepted Solution

proc expand

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;

Accepted Solutions
Solution
‎11-30-2017 01:13 PM
Super User
Posts: 23,776

Re: proc expand

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

View solution in original post


All Replies
Solution
‎11-30-2017 01:13 PM
Super User
Posts: 23,776

Re: proc expand

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

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 191 views
  • 0 likes
  • 2 in conversation