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
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.