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 ?
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;
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?
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? 🙂
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?
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.