Can any one help me out in calculating moving(running) minimum and maximum in sas datastep

[venkatard]

Can any one help me out in calculating moving(running) minimum and maximum in sas datastep

[esjackso]

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.

[venkatard]

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

[art297 · Accepted solution]

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;

[venkatard]

Thanks a lot for the quick reply.