data CP;
input time A B;
cards;
1 . .
2 0 .1
2 .4 .7
3 .3 .5
5 .9 0
6 .3 .33
;
I want to create a third and fourth variable calle Asum and Bsum
where Asum= .+0+.4+.3+.9+.3
data CP;
input time A B Asum Bsum;
cards;
1 . . .+0+.4+.3+.9+.3 .+.1+.7+.5+0+.33
2 0 .1 0+.4+.3+.9+.3 1+.7+.5+0+.33
2 .4 .7 .4+.3+.9+.3 .7+.5+0+.33
3 .3 .5 .3+.9+.3 .5+0+.33
5 .9 0 .9+.3 0+.33
6 .3 .33 .3 .33
;
data CP;
input time A B;
cards;
1 . .
2 0 .1
2 .4 .7
3 .3 .5
5 .9 0
6 .3 .33
;
data CPn;
set CP;
n = _n_;
run;
proc sort data=CPn; by descending n; run;
data want;
set CPn;
Asum + A;
Bsum + B;
run;
proc sort data=want out=want(drop=n); by n; run;
PG
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.