Hi,
Can anyone please help me to get SAS code to calculate moving median for last 30 days.
Regards,
Swapna
First Google hit should help (has full code):
Hi,
Thanks for your reply.
The link which you shared is to calculate moving average and I have already gone through it..
But I am looking for a code to calculate Moving "MEDIAN" for last 30 days.
Regards.
Swapna
Ah. maybe have a look at the expand procedure then:
(Replace MOVAVE with the MOVMED)
22104 - How can I compute a moving average of a variable?
Per:
Have gone to that option as well, and sorry to not mention that in my first post.
The challenge is we don't have SAS ETS with us, thus I need a code which should work in Base SAS.
If you have SAS9.4 , then SQL can get that , otherwise use ARRAY.
Hi Xia,
Yes I am having SAS 9.4, It would be really great if you can please share some sample code, so that I can try it at my end.
Regards,
Swapna
SAS - moving min/max using arrays
You'll notice the code was originally sourced from this website.
OK. Here is an example :
data have; do date='01jan2014'd to today(); v=ranuni(1234); output; end; format date date9.; run; proc sql; create table want as select *,(select median(v) from have where date between a.date-30 and a.date) as moving_median_30_day from have as a; quit;
Xia Keshan
Just a note that the SAS SQL Median function only works in SAS 9.4
Thanks Reeza. I have already mentioned it before .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.