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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.