1) Please post code into a code box opened with the forums {I} menu icon
2) Please provide data in the form of a data step. That way we know what your variable names are and the types.
3) Provide an example of the desired output for sample data
4) Please provide just enough data to demonstrate the issue at hand.
It looks like you are requesting a cumulative total by day for something as the main part. I think this might be part of what you need.
data want;
set new1;
retain total 0;
if mod(juldate(date),1000)=1 then total=0;
total+Qcorcfs;
run;
which assume you have an actual date associated with each measurement and it is an actual SAS date value.
Comparing the total to those other values should be easy enough. I suspect you want something like
If total ge q25 then somevar=date.
Which would likely involve resetting that variable for each year, retaining the variable and only assigning if the current year's value of the variable is missing, or some flags involved.
When I was working with stream flow data we were more concerned with a water year that ran Oct to Sep than calendar but water budgets differ.
