Hi, have get stuck in a thing with SAS. I should compare 4 different companys income during a period in three country in different county.In the table i only want to pick the company with highest total income for each county in every country. the table look something like this: Country.........County........Company.......Income Country1.......Countyx......Compay1.......45000 ......................................Company2.....45600 ......................................Company3.....30566 ......................................Company4.....38000 . . . . . . Country3.....Countyz......Company1......360000 ....................................Company2......500000 ....................................Company3......32100 ....................................Company4......200000 That i want is to only get the bold lines in a table.
... View more