Finding the number of days between precipitation events

sfd — Wed, 27 Feb 2013 20:07:15 GMT

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

Re: Finding the number of days between precipitation events

Reeza — Wed, 27 Feb 2013 20:13:11 GMT

data want;

set have;

retain days_since_rf;

if precip_cm ne 0 then days_since_rf=0;

else days_since_rf+1;

run;

sfd — Wed, 27 Feb 2013 20:24:18 GMT

Thank you @Reeza! Your code did the trick.