04-11-2017 11:27 AM
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 ?
04-13-2017 03:14 AM
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?