I'm trying to get my head around how to pass filters in one report to another. It's mainly as an aid to learning but using data which could give me useful information as well.
I'm using data with a record per SAS session per user, and have a report with a bar chart of SAS usage. The category is an organisation hierarchy (Department, Division, Branch, User) and the measure is an aggregated measure of the number of distinct users in the bygroup. There is also a slider report control to filter on date of use (a range). As well as being able to drill down through the hierarchy I tried to create a link to another report containing a line chart of users over time (date for X, frequency for Y, grouped on user). I had hoped it would filter on the date range and the users from the bar chart. But although it filters on the users, it doesn't on the date range.
I'm using VA 7.4.
Hello,
VA 7.5 (and 8.x) has an option on report links named Set prompt bar values of target report. I believe this does what you are looking for.
Sam
Hello,
VA 7.5 (and 8.x) has an option on report links named Set prompt bar values of target report. I believe this does what you are looking for.
Sam
Thanks @Sam_SAS that looks like it would do the trick. As with several other issues, I'm going to have to look forward to upgrading to M6 and 7.5.
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 16. 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.