I've made a prompt (drop down format) where the user selects from a list of text values, I would like to use the TEXT VALUE that the user chooses in a computed column. As an example, I would like to simply return the text value the user has chosen as a computed column. I tried: &promptname and it errored out. I was trying to call the value like the filter does when it calls the value of the prompt. I'm sure this feature exists.
In short: How do you call a prompt value in an advanced expression in a computed column?
Yes macro variables require double quotes to "decode" the value. So much fun!
You can use the macro variable created by the prompt ... which I don't think that will mean much to you.
Can you give me an example of how you are using this ... for instance, the user picks a word (like Dog) or a value (like 4) and then your computed column would output something like this:
"You picked: Dog"
or this "100" (because 25*4 is 100)
?
Well the trick seemed to be use quotations. The user selects a string. I tried to report the string by doing &promptname. I tried '&promptname' and that returned "&promptname". Then I tried double quote "&promptname" and that returned the selected prompt value that I was looking for. Very odd behavior from double quotes, that's usually reserved for designating text. I appreciate your response!
Yes macro variables require double quotes to "decode" the value. So much fun!
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.