Count

[SASPhile]

   mr_nbr  id
   123     001
   123     002
   234     003
   456     004
   456     005
   456     006

how to show that mr_nbr 123 has 2 different id's,456 has 3 different id's

and how to display that out of 3 different mr_nbrs there are  2 mr_nbrs that have different id's i.e 60% have multiple id's  and reverse i.e how id and mr_nbr related

[art297]

data have;

  input mr_nbr  id $;

  cards;

   123     001

   123     002

   234     003

   456     004

   456     005

   456     006

;

proc sql;

  select distinct mr_nbr, count(id) as how_many

    from have

      group by mr_nbr

  ;

quit;

[SASPhile]

Is there a better way to know the percent of mr_nbr that have more than one id?in this case out three mr_nbr 2 have more than one id. which is 66.6%

[Peter_C]

Do you seek two answers?

had provided the first.

Adapt it to create a summary table that can be analysed with proc freq which provides those cumulative percentages more conveniently than tabulate

proc sql;

CREATE TABLE summary1 AS

  select  mr_nbr, count(id) as how_many

    from have

      group by mr_nbr

  ;

quit ;

* generate cumulative frequency report ;

Proc freq data= summary1 ;

Table how_many ;

run ;