Prior data carried over to next row

[RW9]

Is there not a code block in EG?  I haven't used it in years, but you can create items and link them together, and one of those items is SAS code files.  Then within the SAS code file you write a datastep to process your data as you want.  And yes, retain is the method you want to use.

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214163.htm

[gregor1]

Thanks RW9 for your reply...I need to think about that and how to proceed.  I am not an experienced coder so will need to read up on you comments.  Have been trying to figure it out for a while, so your comments give me another lead.

[Tom]

You are going to have a problem if the variable you want to create already exists. Either drop the empty BEGIN and END variables or create your new values using different variable names.  Let's make your test data into an actual dataset.

data have ;
  input date team $ group $ category $ incoming outgoing ;
  informat date yymmdd. ;
  format date yymmdd10. ;
  put (_all_)(+1);
cards;
2013-06-25  A  1  AUTO  1  0
2013-07-02  A  1  AUTO  1  0
2013-07-09  A  1  AUTO  0  1
2013-07-10  A  1  AUTO  2  0
2013-07-11  A  1  AUTO  2  0
2013-07-12  A  1  AUTO  0  2
;

Not sure what the other variables are for, so we can just ignore them fro now.  If they represent some type of grouping of the data then you will need to add some BY processing statements.

So basically you want to RETAIN the new END variable so that you can store the old value into BEGIN.  The SUM statement (variable + expression) will make that happen and also initialize it to zero.

data want ;
  set have ;
  begin = end ;
  end + incoming - outgoing;
run;