https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14001#M2920 Hi All!<BR /> <BR /> I'm quite new to EG and running into some issues while using prompts.<BR /> <BR /> I have two simple text prompts (so far) and both exhibit the same problem. Despite being able to supply multiple options at the prompt it only ever returns the <U>first</U> choice.<BR /> <BR /> So for example at the prompt screen I chose ESP and DEU but it only returns ESP. If I switch the order it only returns DEU. If I add ten options it still only returns the first one.<BR /> <BR /> I've tried a lot of different operators in the Query Builder filter section : equal to, in list, between, in range etc. As you can see, some of these are wildly inappropriate, but this kind of thrashing around is symptomatic of my desperation; I may very well soon begin to cry.<BR /> <BR /> At the moment I'm using "equal to" because this seems the most reasonable choice.<BR /> <BR /> Any ideas? Wed, 15 Jun 2011 10:20:59 GMT theBIFellow 2011-06-15T10:20:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14001#M2920 Hi All!<BR /> <BR /> I'm quite new to EG and running into some issues while using prompts.<BR /> <BR /> I have two simple text prompts (so far) and both exhibit the same problem. Despite being able to supply multiple options at the prompt it only ever returns the <U>first</U> choice.<BR /> <BR /> So for example at the prompt screen I chose ESP and DEU but it only returns ESP. If I switch the order it only returns DEU. If I add ten options it still only returns the first one.<BR /> <BR /> I've tried a lot of different operators in the Query Builder filter section : equal to, in list, between, in range etc. As you can see, some of these are wildly inappropriate, but this kind of thrashing around is symptomatic of my desperation; I may very well soon begin to cry.<BR /> <BR /> At the moment I'm using "equal to" because this seems the most reasonable choice.<BR /> <BR /> Any ideas? Wed, 15 Jun 2011 10:20:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14001#M2920 theBIFellow 2011-06-15T10:20:59Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14002#M2921 Hi,<BR /> There is a good article call :Interactive and Efficient Macro Programming with Prompts in SAS® Enterprise Guide® 4.2.<BR /> In the article, search for <B>MULTIPLE VALUE PROMPTS</B>, you will find exactly what you need. Wed, 15 Jun 2011 11:37:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14002#M2921 yonib 2011-06-15T11:37:50Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14003#M2922 Thanks for that! I'm having a read of that right now:-) Wed, 15 Jun 2011 13:32:26 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-and-Stored-Procedures/m-p/14003#M2922 theBIFellow 2011-06-15T13:32:26Z