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 .
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.