topic Re: Count in SAS Programming

Count

SASPhile — Tue, 04 Feb 2014 16:51:49 GMT

   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

Re: Count

art297 — Tue, 04 Feb 2014 17:21:06 GMT

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;

Re: Count

SASPhile — Fri, 07 Feb 2014 00:05:18 GMT

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%

Re: Count

Peter_C — Fri, 07 Feb 2014 08:57:11 GMT

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 ;