Creating a Date Range Prompt in Web Report Studio - SAS 9.2 Version

0

There is actually many more PROMPT types available in SAS 9.2 than the prior version. Including ranges for date, time, text, and numeric! The 'Date Range' type specifically replaces the workarounds necessary in a prior version. (See these workarounds in post: Creating a Date Range Prompt in Web Report Studio in SAS9.1.3)

Included are the steps in SAS 9.2 (Information Map Studio & Web Report Studio 4.2):

1. Within Information Map Studio - For the Date Variable, Select 'Properties', Move to 'Value-Generation Method' and choose 'User Selects Values from a Dynamic List'

2. For the Filter, Select the Condition 'Range of values (between)'

3. For the Filter, Values Select 'Use Single Prompt for both 'From' and 'To' Values'


4. For the Prompt, Select Prompt Type 'Date Range'

5. Save the Information Map

6. Within Web Report Studio - Apply the prompted filter in Web Report Studio to the Date Variable

7. View the report to receive the prompt options for Date Range:

Reference Material: http://support.sas.com/resources/papers/sgf09/355-2009.pdf

Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Comments are closed.

Back to Top