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!
Try replacing c=c+b with c=sum(c, b);
Try replacing c=c+b with c=sum(c, b);
Or replacing
retain c 0;
c=c+b;
WITH
c+b;
Haikuo
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.