Date:         Sat, 3 Sep 2005 10:14:57 +0100
Reply-To:     Jared Wilson <wilsonjaredm@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jared Wilson <wilsonjaredm@GMAIL.COM>
Subject:      Re: sequential summing/ sequential running totals of column values
Comments: To: David L Cassell <davidlcassell@msn.com>
In-Reply-To:  <BAY103-F25E4C4A22E7661F2B7C2D1B0A30@phx.gbl>
Content-Type: text/plain; charset=WINDOWS-1252

SGkgRGF2aWQsCkkndmUgbm90IGJlZW4gY2xlYXIgaW4gd2hhdCBJJ20gYXNraW5nIG9yIHdoeSBz
by4uLgpJIGFtIHdhbnRpbmcgdG8gc2VxdWVudGlhbGx5IHN1bSB0aGUgdmFsdWVzIGluIGEgc2lu
Z2xlIGNvbHVtbiBhbmQgc3Ryb3JlIAp0aGVzZSB2YWx1ZXMgaW4gYSBzZWNvbmQgY29sdW1uLCBh
bmQgcmVwZWF0IHRoaXMgZm9yIDEwMCBjb2x1bW5zIGluIHRoZSBzYW1lIApkYXRhIHNldC4gU28g
aWYgY29sdW1uICdhJyBoYXMgdmFsdWVzIAo0MAoxCjMgCjMwCjEwIAoxNSAKdGhlbiB0aGUgY29y
cmVzcG9uZGluZyB2YWxlcyBpbiBjb2x1bW4gJ2FhJyB3b3VsZCBiZSAKNDAKOTkKOTgKNzAKOTUg
Cjg1IApJIHdhbnQgdG8gdXNlIHRoaXMgdmFsdWUgdG8gc2VsZWN0IGRhdGEgcm93cyB0aGF0IGZh
bGwgd2l0aGluIHZhcmlvdXMgCid3aW5kb3dzJy4gSSdtIGFjdHVhbGx5IGNhbGN1bGF0aW5nIEFr
YWlrZSB3ZWlnaHRzIGFuZCB3YW50IHRvIHNlbGVjdCBtb2RlbHMgCnRoYXQgZmFsbCB3aXRoaW4g
dmFyaW91cyBldmlkZW5jZSB3aW5kb3dzLiAKQXQgdGhlIG1vbWVudCBJJ20gZG9pbmcgdGhlIHNv
cnQgYW5kIHN1bSBzdGVwcyBmb3Igc2luZ2xlIHZhcmlhYmxlcyB1c2luZyAKcHJvYyBzb3J0IGFu
ZCB0aGVuIHN1bSBpbiBhIGRhdGEgc3RlcCBidXQgSSB3YW50IHRvIHJlcGVhdCB0aGUgcHJvY2Vz
cyBmb3IgCjEwMCBjb2x1bW5zIG9mIGRhdGEgYW5kIHdhcyB3b25kZXJpbmcgaWYgdGhlcmUgaXMg
YSBtb3JlIGVmZmljaWVudCB3YXkgb2YgCmRvaW5nIGl0LiBUaGVyZSBtYXkgYmUgbm8gbmVlZCBm
b3IgdXNpbmcgcHJvYyBzb3J0IGF0IGFsbCwgYnV0IHRoYXQgCihjb21iaW5lZCB3aXRoIHN1bSBp
biBhIGRhdGEgc3RlcCkgaXMgdGhlIG9ubHkgd2F5IEkga25vdyBvZiBnZXR0aW5nIHRoZSAKY29s
dW1uIHJ1bm5pbmcgdG90YWxzIHRoYXQgSSB3YW50LgogaG9wZSB0aGlzIG1ha2VzIHRoaW5ncyBh
IGxpdHRsZSBjbGVhcmVyCiBtYW55IHRoYW5rcyAKamFyZWQKICAgT24gOS8yLzA1LCBEYXZpZCBM
IENhc3NlbGwgPGRhdmlkbGNhc3NlbGxAbXNuLmNvbT4gd3JvdGU6IAo+IAo+IHdpbHNvbmphcmVk
bUBHTUFJTC5DT00gd3JvdGU6Cj4gPkkgd29uZGVyIGlmIGFueW9uZSBjb3VsZCBoZWxwPyBJJ20g
dHJ5aW5nIHRvIHN1bSB2YWx1ZXMgaW4gb25lIGNvbHVtbj0yMAo+ID5zZXF1ZW50aWFsbHksIHBy
b2R1Y2luZyB0aGUgcnVubmluZyB0b3RhbCBvZiBlYWNoIGNvbHVtbiBpbiBhIHNlcGVyYXRlPTIw
Cj4gPmNvbHVtbi4gU28gaW4gdGhlIGV4YW1wbGUgYmVsb3cgY29sdW1uICdhJyBjb250YWlucyB0
aGUgb3JpZ2luYWwgZGF0YSAKPiBhbmQ9Cj4gPj0yMAo+ID5jb2x1bW4gJ2FzJyBjb250YWlucyB0
aGUgY29ycmVzcG9uZGluZyBydW5uaW5nIHRvdGFsIHdoZW4gZWFjaCB2YWx1ZSAKPiBpcz0yMAo+
ID5zdW1tZWQgc2VxdWVudGlhbGx5LCBncmVhdGVzdCB2YWx1ZSBmaXJzdC4gSSd2ZSBzZWFyY2hl
ZCB0aGUgd2ViIHBsdXMgCj4gcGFzdD0KPiA+PTIwCj4gPmxpc3RpbmdzIG9uIHRoaXMgbGlzdHNl
cnZlIGFuZCBjYW4ndCBmaW5kIHdoYXQgSSdtIGxvb2tpbmcgZm9yLiBOb3Qgc3VyZQo+ID5pZj0K
PiA+PTIwCj4gPkkgaGF2ZSB0byB1c2UgcHJvYyBzb3J0IG9uIGVhY2ggY29sdW1uIGluIHR1cm4g
KEkgaGF2ZSAxMDAgc3VjaCBjb2x1bW5zKQo+ID5hbj0KPiA+ZD0yMAo+ID51c2UgU3VtYSthIGlu
IGEgZGF0YSBzdGVwLCBvciB3aGV0aGVyIHRoZXJlIGlzIGEgZnVuY3Rpb24gdGhhdCB3aWxsIGRv
Cj4gPndoYXQ9Cj4gPj0yMAo+ID5pIHdhbnQgd2l0aG91dCBoYXZpbmcgdG8gc29ydCBmaXJzdC49
MjAKPiA+SSB3b25kZXIgaWYgYW55b25lIGNvdWxkIGhlbHA/IEknbSB0cnlpbmcgdG8gc3VtIHZh
bHVlcyBpbiBvbmUgY29sdW1uPTIwCj4gPnNlcXVlbnRpYWxseSwgcHJvZHVjaW5nIHRoZSBydW5u
aW5nIHRvdGFsIG9mIGVhY2ggY29sdW1uIGluIGEgc2VwZXJhdGU9MjAKPiA+Y29sdW1uLiBTbyBp
biB0aGUgZXhhbXBsZSBiZWxvdyBjb2x1bW4gJ2EnIGNvbnRhaW5zIHRoZSBvcmlnaW5hbCBkYXRh
IAo+IGFuZD0KPiA+PTIwCj4gPmNvbHVtbiAnYXMnIGNvbnRhaW5zIHRoZSBjb3JyZXNwb25kaW5n
IHJ1bm5pbmcgdG90YWwgd2hlbiBlYWNoIHZhbHVlIAo+IGlzPTIwCj4gPnN1bW1lZCBzZXF1ZW50
aWFsbHksIGdyZWF0ZXN0IHZhbHVlIGZpcnN0LiBJJ3ZlIHNlYXJjaGVkIHRoZSB3ZWIgcGx1cyAK
PiBwYXN0PQo+ID49MjAKPiA+bGlzdGluZ3Mgb24gdGhpcyBsaXN0c2VydmUgYW5kIGNhbid0IGZp
bmQgd2hhdCBJJ20gbG9va2luZyBmb3IuIE5vdCBzdXJlCj4gPmlmPQo+ID49MjAKPiA+SSBoYXZl
IHRvIHVzZSBwcm9jIHNvcnQgb24gZWFjaCBjb2x1bW4gaW4gdHVybiAoSSBoYXZlIDEwMCBzdWNo
IGNvbHVtbnMpCj4gPmFuPQo+ID5kPTIwCj4gPnVzZSBTdW1hK2EgaW4gYSBkYXRhIHN0ZXAsIG9y
IHdoZXRoZXIgdGhlcmUgaXMgYSBmdW5jdGlvbiB0aGF0IHdpbGwgZG8KPiA+d2hhdD0KPiA+PTIw
Cj4gPmkgd2FudCB3aXRob3V0IGhhdmluZyB0byBzb3J0IGZpcnN0Lj0yMAo+ID5NYW55IHRoYW5r
cyBmb3IgYW55IGhlbHAhCj4gPmphcmVkCj4gPiBhIGFzIGIgYnMgYyBjcyA0IDQgMTAgMTAwIDIg
OTYgMiA5IDMwIDcwIDc0IDc0IDEgMTAgNDAgNDAgMjAgOTQgMyA3Cj4gPjIwPQo+ID49MjAKPiA+
OTAgMSA5Nwo+IAo+IEkgZG9uJ3Qgc2VlIHdoYXQgeW91J3JlIGFmdGVyLgo+IAo+IEFyZSB5b3Ug
c2F5aW5nIHRoYXQgeW91IHdhbnQgZWFjaCB2YXJpYWJsZSB7YSwgYiwgLi4ufSBzb3J0ZWQgc2Vw
YXJhdGVseQo+IGluIGRlc2NlbmRpbmcgb3JkZXIgYW5kIHRoZW4gc3VtbWVkIGluIHRoZSBtYXRj
aGluZyB2YXJpYWJsZT8gSWYgc28sCj4gdGhlbiBob3cgZG8gb3l1IHBsYW4gdG8gaG9sZCB0aGUg
ZGF0YT8gVGhlIGRhdGEgc3RydWN0dXJlIGl0c2VsZiBzZWVtcwo+IHRvIGJlIHdvcmtpbmcgYWdh
aW5zdCB5b3UuIElmIHlvdSBnZXQgQSBzb3J0ZWQgYW5kIHRoZW4gc3VtbWVkIGluIEFTLAo+IHRo
ZW4gd2hhdCBoYXBwZW5zIHdoZW4geW91IHN1bSB1cCBCPyBFdmVyeXRoaW5nIGluIEEgYW5kIGlu
IEFTIGlzCj4gbm93IGhvc2VkLiBGb3IgdGhhdCBtYXR0ZXIsIEkgZG9uJ3Qgc2VlIHRoZSBwb2lu
dCBvZiB0aGUgc3VtcyBlaXRoZXIuCj4gCj4gRG8geW91IG5lZWQgdG8gYnVpbGQgeW91ciBkYXRh
IHN0cnVjdHVyZSBkaWZmZXJlbnRseSwgc28gdGhhdCB0aGUgc3VtCj4gdmFyaWFibGVzCj4gQVMs
IEJTLCBldGMuIGFyZSBpbiBhIHNlcGFyYXRlIGRhdGEgc2V0Pwo+IAo+IElmIGFsbCB5b3Ugd2Fu
dCBpcyBzZXF1ZW50aWFsIHN1bXMsIHRoYXQgd291bGQgYmUgZWFzaWVyLiBCdXQgSSBjYW5ub3QK
PiB0ZWxsLAo+IHNpbmNlIHlvdXIgJ2V4YW1wbGUgZGF0YScgYXJlIHVucmVhZGFibGUuIEhvdyBh
Ym91dCB3cml0aW5nIGJhY2sgdG8gdGhlCj4gbGlzdAo+IHdpdGggYSBzaW1wbGUgZXhhbXBsZSBv
Ziwgc2F5LCA1IHZhcmlhYmxlcyBhbmQgMTAgcm93cz8gU2hvdyB1cyB0aGUKPiBvcmlnaW5hbAo+
IGRhdGEsIGFuZCB3aGF0IHlvdSB3YW50IHRoZSBmaW5hbCBwcm9kdWN0IHRvIGxvb2sgbGlrZS4g
VHJ5IHRvIGluY2x1ZGUgYWxsCj4gdGhlIGNhc2VzIHRoYXQgd291bGQgbWF0dGVyLCBpbmNsdWRp
bmcgd2hhdCB0byBkbyB3aGVuIHRoZXJlIGFyZSB0aWVzLgo+IAo+IEkgYWxzbyB0aGluayBpdCB3
b3VsZCAqcmVhbGx5KiBoZWxwIGlmIHlvdSB3cm90ZSBiYWNrIHRvIHRoZSBsaXN0IGFuZAo+IGV4
cGxhaW5lZAo+IHdoeSB5b3UgYXJlIHRyeWluZyB0byBnZXQgdGhpcy4KPiAKPiBEYXZpZAo+IC0t
Cj4gRGF2aWQgTC4gQ2Fzc2VsbAo+IG1hdGhlbWF0aWNhbCBzdGF0aXN0aWNpYW4KPiBEZXNpZ24g
UGF0aHdheXMKPiAzMTE1IE5XIE5vcndvb2QgUGwuCj4gQ29ydmFsbGlzIE9SIDk3MzMwCj4gCj4g
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX18KPiBGUkVFIHBvcC11cCBibG9ja2luZyB3aXRoIHRoZSBuZXcgTVNOIFRvb2xiYXIg
liBnZXQgaXQgbm93IQo+IGh0dHA6Ly90b29sYmFyLm1zbi5jbGljay11cmwuY29tL2dvL29ubTAw
MjAwNDE1YXZlL2RpcmVjdC8wMS8KPgo=