Hello:
I am trying to see if there is a drill-across solution in VA like below:
lets say one object table is showing the head of Dept A , the instructors under Dept A, in particular Joe below, hist course and the campus and the measure:
Dept | Instructor | course | campus | measure1 |
A | Joe | Math | SE | 20% |
now I want the head of Dept A to drill across for that faculty, joe and compare the measure for math but for all dept. and campus:
Dept | instructors | course | campus | measure1 |
All | All | Math | collegewide | 34% |
What would be the options for the above drill across in VA.
Hello @jplarios
Could you please provide a little bit more information to help understand the need.
- A sample data set?
- Which version of VA you have?
- Maybe some kind of sketch of the report page and how you want it to work?
Best regards,
Petri
Hi!
Hope I understand your problem correct 🙂
I did a test using sashelp.class. You can try it yoursellf by importing sashelp.class into VA.
This is the outcome:
On the report there are 2 button bars and 1 cross-tab. All measures are set to average aggregation. I have created 2 new dimensions that are used in the cross-tab. I also created 2 dimension for the choices in the button bars.
I use the button bars to select level of detail for sex and name (using parameters). Depending on their values the drill level will change:
Then create a new report and add the data set.
Then create 2 new dimensions (*_dim, 2 new level choice (*_choice) and 2 paramters (*_level):
Set default value for the parameters to 'Sex' and 'Name'.
Define the sex_dim as:
Create name_dim as:
Create level choice as:
Add two button bars and assign them as:
Add a cross-tab and assign as:
Set all the measures to average aggregation and start testing 🙂
//Fredrik
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.