topic Re: Prompts with OR in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137624#M11122 <HTML><HEAD></HEAD><BODY><P>As mentioned above, the question is a bit vague, but here's a stab at it.</P><P></P><P>Try setting up your filter for an "In a list" condition, and it might work.</P><P></P><P>Tom</P></BODY></HTML> Sat, 11 Jan 2014 00:09:38 GMT TomKari 2014-01-11T00:09:38Z Prompts with OR https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137622#M11120 <HTML><HEAD></HEAD><BODY><P>Hi -</P><P></P><P>I have a prompt in my data that is looking at a column that is populated with a Y or an N.&nbsp; If I want Y or N it seems to work fine but if I want both it does not work.&nbsp; I suspect that the prompt creates a where clause that has an AND in it but this should be an OR......Is there any way to change this?</P><P></P><P>John</P></BODY></HTML> Fri, 10 Jan 2014 15:20:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137622#M11120 jcb267 2014-01-10T15:20:19Z Re: Prompts with OR https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137623#M11121 <HTML><HEAD></HEAD><BODY><P>your question is not clear...input/output data and some more explanation might help us understand better.</P></BODY></HTML> Fri, 10 Jan 2014 21:29:11 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137623#M11121 pradeepalankar 2014-01-10T21:29:11Z Re: Prompts with OR https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137624#M11122 <HTML><HEAD></HEAD><BODY><P>As mentioned above, the question is a bit vague, but here's a stab at it.</P><P></P><P>Try setting up your filter for an "In a list" condition, and it might work.</P><P></P><P>Tom</P></BODY></HTML> Sat, 11 Jan 2014 00:09:38 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137624#M11122 TomKari 2014-01-11T00:09:38Z Re: Prompts with OR https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137625#M11123 <HTML><HEAD></HEAD><BODY><P>Hope you have selected "Multiple Values" under number of values like below while creating the prompt and have used "in a list" condition as suggested by Tom.</P><P></P><P><IMG alt="" class="jiveImage" src="https://communities.sas.com/legacyfs/online/4742_pastedImage_0.png" style="width: 496px; height: 268px;" /></P><P><IMG alt="" class="jiveImage" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks,</P><P>Jag</P></BODY></HTML> Sun, 12 Jan 2014 09:05:29 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137625#M11123 Jagadishkatam 2014-01-12T09:05:29Z Re: Prompts with OR https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137626#M11124 <HTML><HEAD></HEAD><BODY><P>Thank you, Jag......this worked!</P></BODY></HTML> Tue, 14 Jan 2014 14:57:02 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Prompts-with-OR/m-p/137626#M11124 jcb267 2014-01-14T14:57:02Z