Using "Retain" with missing Values

[Wagner_Alvarenga]

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!

[Reeza · Accepted solution]

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

[Haikuo]

Or replacing

retain c 0;

c=c+b;

WITH

c+b;

Haikuo