SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Sum most recent consecutive values until 0 occurs

Reply
Senior User
Posts: 1

Sum most recent consecutive values until 0 occurs

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:

Month NCountSUM

1

0
21
31
40
51
60
71
81
91

WANT;

Month NCountSUM
100
211
312
400
511
600
711
812
913

Thanks in advance!

Respected Advisor
Posts: 4,651

Re: Sum most recent consecutive values until 0 occurs

Homework? Check out the sum statement.

data want;

set have;

if count=0 then sum=0;

else sum + count;

run;

PG

PG
Trusted Advisor
Posts: 1,130

Re: Sum most recent consecutive values until 0 occurs

Alternatively with first.

data want;

set have;

by count notsorted;

if first.count then sum=count;

else sum+count;

run;

Thanks,

Jag

Thanks,
Jag
Ask a Question
Discussion stats
  • 2 replies
  • 233 views
  • 1 like
  • 3 in conversation