I am trying to combine/collapse data to make it easier to run statistics on, but am having trouble on how to combine the data. I was given billing data, and therefore patients can be billed multiple times for the same procedure using different billing codes. I am trying to combine rows of data into a single row based on a patient's MRN and their date of surgery regardless of their billing codes (as I have recoded all the billing codes into bundles based on the procedure type). i.e. MRN DOB Date of Surgery Procedure Code 12345 1/1/11 July 1, 2017 12345 12345 1/1/11 July 1, 2017 12345 67890 2/2/22 July 2, 2017 12345 67890 2/2/22 July 3, 2017 23456 45678 3/3/33 July 4, 2017 567890 45678 3/3/33 July 4, 2017 567890 45678 3/3/33 July 4, 2017 567890 In the above example, I woul want it to be collapsed to the following: MRN DOB Date of Surgery Procedure Code 12345 1/1/11 July 1, 2017 12345 67890 2/2/22 July 2, 2017 12345 67890 2/2/22 July 3, 2017 23456 45678 3/3/33 July 4, 2017 567890 I have tried the PROC MEANS NWAY;
CLASS ;
VAR ;
OUTPUT OUT= MEAN= STD= N=;
RUN; But this did not work out. Thank you
... View more