DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Regular Contributor
Posts: 181
Accepted Solution

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

[ Edited ]

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

 


Accepted Solutions
Solution
‎01-30-2018 03:01 PM
Super User
Posts: 6,632

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

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;

View solution in original post


All Replies
Respected Advisor
Posts: 2,825

Re: An Advanced SAS program designed by a scientist

 

proc summary data=have;

    class patient date;

    var res;

    output out=want sum=;

run;

 

--
Paige Miller
Super User
Posts: 23,295

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

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
Solution
‎01-30-2018 03:01 PM
Super User
Posts: 6,632

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

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;

☑ This topic is solved.

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

Discussion stats
  • 3 replies
  • 86 views
  • 0 likes
  • 4 in conversation