HI everyone, thanks in advance for your help!! I am working with call history data from a survey. A household may be called several times throughout the survey, and I need to generate a variable to capture: Given that the household completed the adult screener interview, how many calls did it take? Therefore, I need to know a) whether the household completed the adult screener interview at all, and b) if so, how many calls did it take before they completed it. The variables are CALL_CODE= 'CS' (stands for completed screener), and the household ID is called ID. I know I need to do something with retain, first, and last, but I am stuck. I hope this wasn't too unclear!
... View more