Technically, you could change the data object to a sql view which performs a UNION between the table with data and a single row with Other as data value. Then metadata register the view and use that in stead. There is no way of combining the dynamic list of values with other values within the prompt GUI.
However, you may consider if that is really worth the effort. What is supposed to happen if Other is selected? If you do not select the "Requires a non-blank value" tick box, the user is not obliged to make a selection and you can test if the underlying macro is empty, ie. no selection was made
Hi,
How many prompts do you have For your STP?
I think You can use a format for the values and set some items to other in the list.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.