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: 1,400

## Re: sum of column

Use proc means

``````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: 1,400

## Re: sum of column

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?

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

``````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

Discussion stats
• 5 replies
• 220 views
• 2 likes
• 3 in conversation