How do I aggregate two dimensions

[legojenn]

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

[Lorrie_SAS · Accepted solution]

Hi jenn,

If sounds like you might prefer preparing your data using SQL. You could do so from the data builder by manually editing the code on the "Code" tab of a data query or star schema. Here's some information that might be helpful to you:

http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1bhe7s7u4l7egn1d2ahw...

Best regards,

Lorrie