SAS Support Communities

@Reeza . You showed the easy way. Can we achieve the same results by Array/Proc summary?  I ask this as these has procedures have been alternative method for transposing data.   Thanks. ... View more

@Reeza Worked like Charm, on the big data too.  Thanks, again.  I greatly appreciate your time and effort. How do i improve my sas skills? what kind of analytical  thinking is needed?   Also thanks to @PaigeMiller and @Astounding  who had responded.  Each one of you have given me a better insight. Thanks. ... View more

@Reeza that works perfectly with the dummy data set.  I will try with the full data set and keep you posted. Thanks. ... View more

@Reeza , I need to get the frequency table (as given from you) derived form the earlier data, where we need to create the columns having proc1 and proc2. The dummy data set is what I had posted earlier. Thanks. ... View more

@Reeza  This is how the table should look:                                                           Table of CONDX by CONDX2 CONDX(CONDX)- First procedure                                     CONDX2(CONDX2) –Second procedure Frequency   ASD Echo only MI/BYPASS MI/PERC ToF VALVE VSD Total MI/BYPASS 50                 MI/PERC 75 1               PDA 4                 TGA 8                 ToF 6                 VALVE 82                 VSD 2                 Total                   ... View more

Hi @PaigeMiller , The data is form a larger data set. The first column is the PT_ID. ... View more

@Reeza , I need to create (i) a column that contains the first procedure/day/patient ; (ii) a column the has the second procedure done on the same patient(s) on the same day as the first procedure.  Once I have these, I need to use proc tabulate to list out the procedures (first procedure) in a column against the list of second procedure done on the same patient; and get the counts. Say, frequency of MI/BYPASS, MI/PERC, etc as the first procedure and the frequency of Mi/BYPASS as the first and MI/PERC as the second procedure, and so on. i.e,. finding the number of times a combinations of surgery have been done, as opposed to the procedure being done only once.   Hope I am clear with my project objective. ... View more

@PaigeMiller I need to have a column with 1st procedure done on all patients and a column for 2nd procedure done on the same day on the same patient to tabulate different what combination of procedures  were done and at what frequency.   Thanks, ... View more

@Reeza . Sorry, I was confused too about how to go about the analysis.  Just got some clarification.  I need to have ONLY the second procedure done on the patient on the same day to be in the Procedure 2 column.  So, the table I WANT is:   ID Date Procedure gender Counter   Prcedure2 1 08/01/2003 MI/BYPASS F 1   1 08/01/2003 MI/PERC F 2 MI/PERC 2 12/03/2003 MI/PERC F 1   2 12/03/2003 MI/BYPASS F 2 MI/BYPASS 3 08/01/2003 MI/PERC F 1   4 08/02/2003 MI/BYPASS M 1   4 08/02/2003 MI/PERC M 2 MI/PERC 5 08/04/2003 MI/BYPASS F 1   6 08/04/2003 VALVE F 1   7 08/05/2003 MI/PERC F 1   8 08/04/2003 MI/BYPASS F 1   8 08/04/2003 MI/PERC F 2 MI/PERC 9 08/04/2003 MI/PERC F 1   10 08/06/2003 MI/BYPASS M 1   10 08/06/2003 MI/PERC M 2 MI/PERC 11 08/06/2003 MI/PERC F 1     Once again, sorry for not being clear on what I need.  Getting the ropes of SAS, and some times it is hard to understand what is needed exactlu. ... View more

Hi @Astounding, Your code works but generates 2 different data set. I need the data in the same data set  file as new variables. I need to do proc freq/proc tabulate with the new data set.   Thanks ... View more

Thanks @Reeza . Will try it tomorrow.  Also, can same procedure used to identify IDs with only 1 procedure?   Thanks. ... View more

Hi Reeza, I have the foll0wing data, where the last column is a counter, that counts if more than one procedure is done on the same patient on the same day. How do i identify patients that have more than one procedure per day and separate from patients with only one procedure per day? Thanks HAVE   ID Date Procedure gender Counter   1 08/01/2003 MI/BYPASS F 1 1 08/01/2003 MI/PERC F 2 2 12/03/2003 MI/PERC F 1 2 12/03/2003 MI/BYPASS F 2 3 08/01/2003 MI/PERC F 1 4 08/02/2003 MI/BYPASS M 1 4 08/02/2003 MI/PERC M 2 5 08/04/2003 MI/BYPASS F 1 6 08/04/2003 VALVE F 1 7 08/05/2003 MI/PERC F 1 8 08/04/2003 MI/BYPASS F 1 8 08/04/2003 MI/PERC F 2 9 08/04/2003 MI/PERC F 1 10 08/06/2003 MI/BYPASS M 1 10 08/06/2003 MI/PERC M 2 11 08/06/2003 MI/PERC F 1   WANT ID Date Procedure gender Counter   Prcedure2 1 08/01/2003 MI/BYPASS F 1 MI/BYPASS 1 08/01/2003 MI/PERC F 2 MI/PERC 2 12/03/2003 MI/PERC F 1 MI/PERC 2 12/03/2003 MI/BYPASS F 2 MI/BYPASS 3 08/01/2003 MI/PERC F 1   4 08/02/2003 MI/BYPASS M 1 MI/BYPASS 4 08/02/2003 MI/PERC M 2 MI/PERC 5 08/04/2003 MI/BYPASS F 1   6 08/04/2003 VALVE F 1   7 08/05/2003 MI/PERC F 1   8 08/04/2003 MI/BYPASS F 1 MI/BYPASS 8 08/04/2003 MI/PERC F 2 MI/PERC 9 08/04/2003 MI/PERC F 1   10 08/06/2003 MI/BYPASS M 1 MI/BYPASS 10 08/06/2003 MI/PERC M 2 MI/PERC 11 08/06/2003 MI/PERC F 1   ... View more