topic Advanced Prompts in SAS Enterprise Guide

Advanced Prompts

Anthony — Mon, 06 Feb 2012 20:24:38 GMT

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?

Advanced Prompts

TriciaA — Mon, 06 Feb 2012 20:44:02 GMT

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)

Advanced Prompts

Anthony — Mon, 06 Feb 2012 21:01:40 GMT

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!

Advanced Prompts

TriciaA — Mon, 06 Feb 2012 21:06:11 GMT

Yes macro variables require double quotes to "decode" the value. So much fun!