Is there a way to use the formatted value of a prompt value that is inserted into a text object? For example, one of the fields (FUNDABLE) contains values of Y or N and a custom format is applied to the field to provide a description of Funded or Non-Funded, respectively. The user is prompted to make a selection to filter the data on one of the values. I want to use this in a text object to place the value in the title (not the header) above the table but I need it to say Funded or Non-Funded. It says Y or N when I insert.
Unfortunately, the display of unformatted values is a known issue. The only workaround is to create the prompted filters in Web Report Studio instead of the information map. See http://support.sas.com/kb/30/746.html
Thank you so much for your quick response. I don't know if this will work for me, as I've created a custom filter that allows for "All" of the items as one of the selections, as per the SAS Global Forum paper 064-2008 - SAS Web Report Studio tips and techniques. Is there a way to do the same thing in WRS?
I forgot to mention that I am still using IMS 3.1 and WRS 3.1 and SAS 9.1.3 SP4. When I use the PUT statement, no data is returned to the report and the text object still contains the unformatted values. The data is in SAS format but this isn't working for me.
We are currently in the process of upgrading to SAS 9.2 so this may work then. Thanks again for your assistance!
Thank you for updating the SAS note with details. I had not removed the user-defined format when I first tested. When I try to do it as you have carefully explained in the SAS note, I still get the unformatted values and no data is returned so I don't know what I am doing wrong.
I'll keep working at it to see if I can get it to work as it should. Thanks again!
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.