EG 7.1_How to identify the list of surgeon doing 80% of the volume

[LVeilleux]

Hi,

I'm new user in SAS EG. and working with health data

My employe would like to see the list of surgeon doing 80% of the surgery volume.

I count volume by Dr

Dr	Cas
Medecin E	160
Medecin A	50
Medecin B	32
Medecin C	5
Medecin D	5
etc

(in this example = Medecin E and A), when they will be identify, I would need to identify in which category 80% of the volume or (for each surgeon) 

Dr	Volume	HIG_Code_Description
Medecin E	100	810 Palliative Care
Medecin E	28	654 Other/Unspecified Sepsis
Medecin E	2	726 Hip Replacement with Trauma/Complication of Treatment
Medecin E	20	026 Ischemic Event of Central Nervous System
Medecin E	10	810 Palliative Care
Medecin A	40	726 Hip Replacement with Trauma/Complication of Treatment
Medecin A	2	026 Ischemic Event of Central Nervous System
Medecin A	3	810 Palliative Care

thank you!

Line

[ballardw]

Since the two example data sets don't have any count in common and you do not show what the actual output should be and it isn't clear exactly what you want 80% of, it is a tad hard to be sure this is what you want.

proc freq data= have ;
tables Dr;
weight volume;
run;

This will generate output with the Percent column showing the percent of all procedures performed by one doctor.

If this doesn't provide what you are looking for provide a little more data and what the results should be for that dummy data. It will help to provide the data in the form of a data step that reads data lines as what ever table source you pasted from takes manipulation to make nice for data.