Finding the number of days between precipitation events

Accepted Solution Solved
Reply
Occasional Contributor sfd
Occasional Contributor
Posts: 6
Accepted Solution

Finding the number of days between precipitation events

Hello All,

I'm trying to find the number of days between the occurrence of rainfall events. Here's a sample of my code:

Date          precip_cm

1/1/61          0.13

1/2/61          0

1/3/61          0

1/4/61          0

1/5/61          0.64

1/6/61          0.32

1/7/61          0

1/8/61          0

1/9/61          0

1/10/61        0 

I'd like to add a new column that shows the number of days since the last rainfall occurred. Here's an example of what I'm trying to do:

Date          precip_cm          days_since_rf

1/1/61          0.13                     0

1/2/61          0                         1

1/3/61          0                         2

1/4/61          0                         3

1/5/61          0.64                    0   

1/6/61          0.32                    0

1/7/61          0                         1

1/8/61          0                         2    

1/9/61          0                         3

1/10/61        0                         4

Does anyone have any suggestions on how to do this? Thanks in advance for your help!

Salli


Accepted Solutions
Solution
‎02-27-2013 03:13 PM
Super User
Posts: 19,855

Re: Finding the number of days between precipitation events

data want;

set have;

retain days_since_rf;

if precip_cm ne 0 then days_since_rf=0;

else days_since_rf+1;

run;

View solution in original post


All Replies
Solution
‎02-27-2013 03:13 PM
Super User
Posts: 19,855

Re: Finding the number of days between precipitation events

data want;

set have;

retain days_since_rf;

if precip_cm ne 0 then days_since_rf=0;

else days_since_rf+1;

run;

Occasional Contributor sfd
Occasional Contributor
Posts: 6

Re: Finding the number of days between precipitation events

Thank you @Reeza! Your code did the trick.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 154 views
  • 0 likes
  • 2 in conversation