1. Should the last two records in your desired output should be a2 w1 125 100 SCR a2 w2 150 100 SCR ? ANS: Yes , Output looks like below : pt visit sum date minimum visit_min a1 scr 100 01jan2015 . a1 w1 150 02jan2015 100 SCR a1 w2 125 03jan2015 100 SCR a1 w3 80 04jan2015 100 SCR a1 w4 90 05jan2015 80 w3 a1 w5 70 06jan2015 100 SCR a2 scr 100 01jan2015 . a2 w1 125 02jan2015 100 SCR a2 w2 150 03jan2015 100 SCR 2. Can we always count of the first instance of a patient ID to be a visit type of SCR? If not, can the data be sorted in that fashion? Ans: Patient ID is sorted based on the date ,So SCR can occur at any instance . 3. Are all visits for a patient ID to be considered at once or is it possible patient A1 would have two visit groups (perhaps separated by a time variable we don't have) that would need to be considered separately? Yes ,All visit for a patient ID to be consider at once .
... View more