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
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;
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%
Do you seek two answers?
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 ;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.