I'm using wrs 4.2 and I'd like to remove the retained values.
In my wrs page I have some parameters to select before having my report. But now my data has changed and the possible selected values are different the selected values I used before are unformatted. That's normal, unexisting selected values are showed unformatted.
but how to clear this?
thanks for your help
what do you mean by retained values?
You have prompts on your STP or web report or Information Map (is there a source for the report like STP or IM?)
"But now my data has changed" What do you mean by "now". The last 3 days?
when the underlying data changes the prompts show obviously only the values that exist in the
data. Try to clear your browser cache if something is out of synch.
The prompts are coming from a SP. But wrs retains your last selection and when you reconnect the prompts are filled by the last selected values.
can we change the option in wrs or jboss and tell him not to retain previous selected values?
SAS WRS saves the selected prompt values along with the report. This is the reason why the values in the prompts are still reflecting the previous values. As a work around for this issue you have to remove the prompts from your report, save it and add the prompts again.
If your report is based on the Information maps you can uncheck the prompts from the menu and add them after saving the report, incase if your report is using STP you have to remove the prompts directly from the STP.
This SAS note describes the behavior that you are experiencing: http://support.sas.com/kb/40/605.html
If the list of values is static, then you will have to edit the prompt in the stored process to regenerate a new list, but if the list is dynamic, then you should only need to follow the suggestions in the SAS note.
You should not have to physically remove the prompts from the stored process.
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
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.
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.