DATA Step, Macro, Functions and more

Count

Reply
Super Contributor
Posts: 673

Count

   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

PROC Star
Posts: 7,492

Re: Count

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;

Super Contributor
Posts: 673

Re: Count

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%

Valued Guide
Posts: 2,177

Re: Count

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 ;

Ask a Question
Discussion stats
  • 3 replies
  • 247 views
  • 1 like
  • 3 in conversation