BookmarkSubscribeRSS Feed
sks
Fluorite | Level 6 sks
Fluorite | Level 6
Hello All,
I have a prompt for a stored process which gets the values from a dynamic list(SAS Data set). One of the customer requirements is to add the choice "Other" to the list obtained from the SAS data set. I could not find how to add static values to the dynamic list obtained from the SAS dataset in the Stored Process Parameter window. Has anyone come across such a situation ? Is there a way to add choices that are not in the dynamic list ( I do not want the users to specify additional values that are not in the list though... )
I am debating between creating a static list with the values from the dataset and the value "Other"
or add Other as one of the values in the SAS dataset, as a workaround.

I appreciate your feedback on this issue.

Thanks
SKS
5 REPLIES 5
twocanbazza
Quartz | Level 8
What Versions are you using....
sks
Fluorite | Level 6 sks
Fluorite | Level 6
> What Versions are you using....

Hi I am using SAS 9.2 M2

Thanks
Shri
jbhan
Calcite | Level 5

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

NN
Quartz | Level 8 NN
Quartz | Level 8

Hi,

How many prompts do you have For your STP?

AndersBergquist
Quartz | Level 8

I think You can use a format for the values and set some items to other in the list.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1564 views
  • 0 likes
  • 5 in conversation