Using "Retain" with missing Values

Wagner_Alvarenga — Mon, 22 Jul 2013 20:25:00 GMT

Hi,

There is the .txt file "Text" as follow:

----|---10---|---

1901 2

1905 1

1910 6

1925 .

1941 1

And the code:

data want;

infile 'Text path';

input a b;

retain c 0;

c=c+b;

run;

The result for want is:

a b c

1901 2 2

1905 1 3

1910 6 9

1925 . .

1941 1 .

But, what I realy want is:

a b c

1901 2 2

1905 1 3

1910 6 9

1925 . 9

1941 1 10

How should I proceed?

Thanks!

Re: Using "Retain" with missing Values

Reeza — Mon, 22 Jul 2013 20:29:24 GMT

Try replacing c=c+b with c=sum(c, b);

Haikuo — Mon, 22 Jul 2013 20:55:08 GMT

Or replacing

retain c 0;

c=c+b;

WITH

c+b;

Haikuo