proportion and distribution

[CathyVI]

Hello, 

I know this might seems very simple to some.

1. How do I generate a report on proportion of patients with any physician visit. 

2. How do I report the distribution of the number of physician visits per patient.

There are multiple records per patient

Here is my dummy data

data want;

set have;

input patientid phyvisit$;

datalines;

10  xyz

10  abc

10  ijk

11 abc

11 edc

12 abc

12 adc

12 zxc

;

run;

Thanks

[ballardw]

What is the report supposed to look like?

When you say proportion there should be some sort of numerator and denominator involved. What are they? Count of Patients? Count of Doctors? Count of Visits? Count of unique patients (each patient only counted one time)?

[CathyVI]

Based on the question, its the count of patient, so numerator will be count of patient with any physician visit and denominator will be ALL patient. Any coding idea will be really appreciated.