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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.