BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
RobP
Quartz | Level 8

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;
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
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

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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