Solved: I sorted by id and date (mm/dd/yy). I need to create a running count by id and job (while keeping the dates in order). How do I create.
Compute a running total for a "window" of time A subsequent data step can be used to count the number of events in each rolling period. solutions that use the DATA step, PROC SQL, or other SAS routines.
The result I would like to achieve is a cumulative total column for each I would be interest to know if their is a better method using PROC SQL. .. where the cumulative total is a running total of the previous 5 observations. How To Create An Access Database Summing Query