topic proportion and distribution in SAS Programming

proportion and distribution

CathyVI — Fri, 25 Mar 2022 23:52:44 GMT

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

Re: proportion and distribution

ballardw — Sat, 26 Mar 2022 05:24:22 GMT

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)?

Re: proportion and distribution

CathyVI — Sat, 26 Mar 2022 17:42:39 GMT

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.