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?
... View more