Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How do I aggregate two dimensions

Accepted Solution Solved
Reply
Learner
Posts: 1
Accepted Solution

How do I aggregate two dimensions

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


Accepted Solutions
Solution
‎11-10-2016 04:30 PM
SAS Employee
Posts: 35

Re: How do I aggregate two dimensions

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

View solution in original post


All Replies
Solution
‎11-10-2016 04:30 PM
SAS Employee
Posts: 35

Re: How do I aggregate two dimensions

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 286 views
  • 0 likes
  • 2 in conversation