topic Re: An Advanced SAS program designed by a scientist in SAS Programming

sum to reset to zero when encountering a new date (by subject)

jenim514 — Tue, 30 Jan 2018 19:48:23 GMT

Hi!

Hi! I'm having issues summing by subject and date. I need the sum to reset to zero when encountering a new date (by subject). Here is my code;

data want;
set have;
by patient date;

if first.patient and res ^= . then targetsum=res;

else if res ^= . then targetsum+res;
output;
end;

run;

Here a sample of output for one subject. you can see the totals are not resetting with new date.

02OCT2017 81 81
02OCT2017 22 103

02OCT2017 39 142

11DEC2017 93 235
11DEC2017 23 258
11DEC2017 57 315

Re: An Advanced SAS program designed by a scientist

PaigeMiller — Tue, 30 Jan 2018 19:47:31 GMT

proc summary data=have;

    class patient date;

    var res;

    output out=want sum=;

run;

Re: sum to reset to zero when encountering a new date (by subject)

Reeza — Tue, 30 Jan 2018 19:49:54 GMT

As indicated, don't use a data step, use a PROC designed to summarize the data.

If you need other variables included, look at PROC SUMMARY which can support adding in other variables in the output.

https://github.com/statgeek/SAS-Tutorials/blob/master/proc_means_basic.sas

Re: sum to reset to zero when encountering a new date (by subject)

Astounding — Tue, 30 Jan 2018 19:56:52 GMT

It's not clear that PROC SUMMARY does what you need. It will get you the total for each subject/date, but it will not give you a "running total" for all observations so far. Here is how you would modify your DATA step to do that:

data want;

set have;

by patient date;

if first.date then targetsum=0;

targetsum + res;

run;