topic Re: sum of column in SAS Programming

sum of column

dharmana01 — Tue, 11 Apr 2017 15:27:36 GMT

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 ?

Re: sum of column

PeterClemmensen — Tue, 11 Apr 2017 15:35:29 GMT

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;

Re: sum of column

AbhishekPr — Tue, 11 Apr 2017 15:47:27 GMT

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

Re: sum of column

dharmana01 — Wed, 12 Apr 2017 06:20:46 GMT

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?

Re: sum of column

PeterClemmensen — Wed, 12 Apr 2017 07:46:33 GMT

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? 🙂

Re: sum of column

dharmana01 — Thu, 13 Apr 2017 07:14:57 GMT

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?