BookmarkSubscribeRSS Feed
gregor1
Quartz | Level 8

I have three columns which I want to use to get a sum.

It looks like this:

TEAM

Team Count

One Team's Share

1

61456

 

2

56788

 

3

25524

 

4

32256

 

5

78552

 

6

44796

 

7

38128

 

8

112586

 

9

1532

510.6666667

10

9560

3186.666667

11

616

205.3333333

12

31712

10570.66667

13

20528

6842.666667

14

17060

5686.666667

15

9956

 

 

 

For the new column:

I want the sum of the value for Team 3's Team Count & Team 11's One Team's Share value.  I want that sum to be in a fourth column and on the same row as Team 3.  I need a function that will accomplish similarly for each of the Teams 1 - 8 and 15.

 

Can anyone help me? Thank you!

2 REPLIES 2
TomKari
Onyx | Level 15

Is there a general, repeatable requirement for this, backed by a generalized description?

 

Because this sure looks like a job for Excel to me!

 

Tom

 

P.S. Yes, of course it can be done in SAS, but WHY??

Astounding
PROC Star

I guess I get to invent the variable names:

 

data want;

set have (where=(team=11) rename=(share=team11_share));

do until (done);

   set have end=done;

   if share=. then column4 = count + team11_share;

   else column4 = .;

   output;

end;

drop team11_share;

run;

 

EDITED to add missing statement.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 901 views
  • 0 likes
  • 3 in conversation