How do I aggregate two dimensions

legojenn — Fri, 28 Oct 2016 21:30:42 GMT

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

Re: How do I aggregate two dimensions

Lorrie_SAS — Mon, 31 Oct 2016 15:57:26 GMT

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#p1bhe7s7u4l7egn1d2ahwvqw34is.htm

Best regards,

Lorrie

topic How do I aggregate two dimensions in SAS Visual Analytics

How do I aggregate two dimensions

Re: How do I aggregate two dimensions