BookmarkSubscribeRSS Feed
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?

p.s. We're still using 9.1
SAS Employee
Thank you. I shall pass this along.
SAS Employee
It is my understanding that we are currently working on this feature for future releases and will be called, “prompted prefiltering”.
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.
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:
It also includes additional examples and KB entries from SAS.

Angela Hall



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 3 replies
  • 3 in conversation