Hi: I recently completed SAS VA training and now that I am back at the office, I am a little over my head. One of my first tasks is to look for the average number of practicioners who worked on a file and the average number of files worked on by an practicioner. Once that is done, I need to slice and dice it by division and site. This should be a basic bit of data preparation that should allow me to complete report using techniques provided in the course. The three dimensions that I think I need to work with are a unique identifer for practioners, a unique identifier for files and something that joins them. We call those records timeslips. I assume that I need to aggregate the practioner IDs and file IDs. I am also assuming that I need to select distinct records. Whether a practioner completed one timeslip or one thousand in the period, it counts as one file for that practicioner, and one practicioner for that file. From here, I am lost. If I were to write this in SQL, I would not find it terribly challenging. With SAS VA, I am struggling and I assume that it's because I am overthinking it. Thanks in advance, jenn
... View more