topic Re: Sum most recent consecutive values until 0 occurs in SAS Data Management

Sum most recent consecutive values until 0 occurs

droofus — Fri, 15 May 2015 21:45:31 GMT

Hi all, I'm new here, please forgive me if I'm posting this wrong or in the wrong area.

I've been struggling with this a bit. I'm trying to sum the most recent consecutive months until a 0 is reached. Please see my have/want below.

HAVE:

WANT;

Thanks in advance!

PGStats — Sat, 16 May 2015 17:58:54 GMT

Homework? Check out the sum statement.

data want;

set have;

if count=0 then sum=0;

else sum + count;

run;

Jagadishkatam — Sun, 17 May 2015 01:52:42 GMT

Alternatively with first.

data want;

set have;

by count notsorted;

if first.count then sum=count;

else sum+count;

run;

Thanks,

Jag