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

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

1 ACCEPTED SOLUTION

Accepted Solutions
art297
Opal | Level 21

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;

View solution in original post

4 REPLIES 4
esjackso
Quartz | Level 8

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
Calcite | Level 5

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
Opal | Level 21

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;

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1971 views
  • 2 likes
  • 3 in conversation