Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 5

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

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

Super User
Posts: 11,104

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

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.

Ask a Question
Discussion stats
  • 1 reply
  • 180 views
  • 0 likes
  • 2 in conversation