BookmarkSubscribeRSS Feed
Ian
Calcite | Level 5 Ian
Calcite | Level 5
Hi Everyone,

We'd like a way to force the use of a particular predefined filter as soon as the user selects an item for reporting. For example, I am selecting an item called "age group" which always requires selection of one of 20 or so predefined age groupings.

In other words, the background join from age to age grouping is dependent on the selection of one of the many possible groupings (i.e. part of the where clause).

When the user selects "age group" we want to ensure that the prompted filter is used at report run time rather than assuming that the user will always turn the prompted filter on.

We have about 50 maps where we'd like to use this functionality.Any thoughts?
Ian

p.s. We're still using 9.1
3 REPLIES 3
Jenn2
SAS Employee
Thank you. I shall pass this along.
Jenn2
SAS Employee
It is my understanding that we are currently working on this feature for future releases and will be called, “prompted prefiltering”.
AngelaHall
SAS Employee
What you can do is estabilish a SAS Stored Process and associated prompt, add to the Information Map and then this will force all Web Reports to utilize the Stored Process prompt.

Basic Steps:
1. The metadata must exist for the table, but the table doesnt need to exist.
We create a library in Sas Management Console called 'Report Temp' and place metadata for tables there.
2. The beginning of the stored process code must then reassign this library to WORK so that users arent overwritting the results of other users.
libname reportt (work);
3. Add the appropriate code and prompt to the sql query so that the parameter is passed correctly.
(Example: http://sas-bi.blogspot.com/2009/11/using-multiple-selection-prompts-in-sas.html)
4. Add the stored process to the information map.

This was performed for improving sql queries to data sources such as Oracle. See the article I posted earlier this year:
http://sas-bi.blogspot.com/2009/06/utilizing-sql-pass-thru-within-sas.html
It also includes additional examples and KB entries from SAS.

Angela Hall
http://www.zencos.com

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 910 views
  • 0 likes
  • 3 in conversation