DATA Step, Macro, Functions and more

sum of column

Reply
New Contributor
Posts: 4

sum of column

Hi,

 

I came across one dataset  which consist of

state region1 region2 region3

abc   20          30         50

def    40         30          30

ghi    25         35          40

xyz    30         45          20

i need to find out the sum of each region and which region is largest among the 3 regions?

Can some one help me ? 

 

 

 

PROC Star
Posts: 732

Re: sum of column

Posted in reply to dharmana01

Use proc means Smiley Happy

 

data have;
input state $ region1 region2 region3;
datalines;
abc 20 30 50
def 40 30 30
ghi 25 35 40
xyz 30 45 20
;

proc means data = have sum;
   var region1-region3;
run;
New Contributor
Posts: 4

Re: sum of column

Hi dray,

 

Thanks for your reply, but i am looking for result into new dataset with the variable state and only the region with larger .

will it can be done in data step itself? 

PROC Star
Posts: 732

Re: sum of column

Posted in reply to dharmana01

So you want your variable state and the region variable which has the highest sum?

 

In the example posted, both region 2 and region 3 has sum equal to 140, then what? Smiley Happy

New Contributor
Posts: 4

Re: sum of column

Hi dray,

 

Yes, i want the result with the variable state and the region variable which has the highest sum.

 

Apologies , observations was randomly given by me .And unfortunate region 2 and 3 sum become equal. you can change any one number either in region 2 and region 3.

 

Is this possible to do in the datastep itself?

 

New Contributor
Posts: 3

Re: sum of column

Posted in reply to dharmana01
proc means data=DSN n min max sum;                                                                                                     
run;

You could generate summarization table for above dataset,

It would give you the sum of each region as well as largest among them

 

 

Ask a Question
Discussion stats
  • 5 replies
  • 202 views
  • 2 likes
  • 3 in conversation