topic Help with SAS Code in Statistical Procedures

Help with SAS Code

delarge — Thu, 08 Sep 2011 11:49:26 GMT

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.

Help with SAS Code

art297 — Thu, 08 Sep 2011 12:03:56 GMT

You can sort the tables in descending income order then, in a data step, include a by desceding income and include an if first.income statement. Or, you could use proc sql and use a where income eq max(income( statement.

Help with SAS Code

delarge — Thu, 08 Sep 2011 12:33:13 GMT

Ok, thanks!

Help with SAS Code

Ksharp — Fri, 09 Sep 2011 03:09:47 GMT

nodupkey option of proc sort will keep the first obs.

So if you have already sort your data as you want. then you will get the max obs.

data class;

set sashelp.class;

run;

proc sort data=class ;

by sex decending weight;

run;

proc sort data=class out=cl nodupkey ;

by sex;

run;

Ksharp