## Finding the number of days between precipitation events

Solved
Occasional Contributor
Posts: 6

# 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: 23,659

## 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;

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

## 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
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.