Can any one help me out in calculating moving(running) minimum and maximum in sas datastep
You could just use something like:
data have;
input user_id week score;
cards;
101 1 143
101 2 156
101 3 102
102 1 19
102 2 23
;
data want;
set have;
retain running_min running_max;
by user_id;
running_min=ifn(first.user_id,score,min(score,running_min));
running_max=ifn(first.user_id,score,max(score,running_max));
run;
Can you provide more details about what you are trying to do and what you have tried? Without context it will be hard to help.
I am sorry.
i have a data set for example
user_id week score
101 1 143
101 2 156
101 3 102
102 1 19
102 2 23
i want running minimum and running maximum for scores by user_id.
please see the below table which gives running min and running max
user_id week score running_ min running_max
101 1 143 143 143
101 2 156 143 156
101 3 102 102 156
102 1 19 19 19
102 2 23 19 23
You could just use something like:
data have;
input user_id week score;
cards;
101 1 143
101 2 156
101 3 102
102 1 19
102 2 23
;
data want;
set have;
retain running_min running_max;
by user_id;
running_min=ifn(first.user_id,score,min(score,running_min));
running_max=ifn(first.user_id,score,max(score,running_max));
run;
Thanks a lot for the quick reply.
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.