https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-3-0-filtering-multiple-columns-with-logical/m-p/4709#M1511 I cant figure out in 3.0 how to filter several different columns with the logical operator 'OR'... Sat, 15 Sep 2007 22:18:36 GMT deleted_user 2007-09-15T22:18:36Z https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-3-0-filtering-multiple-columns-with-logical/m-p/4709#M1511 I cant figure out in 3.0 how to filter several different columns with the logical operator 'OR'... Sat, 15 Sep 2007 22:18:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-3-0-filtering-multiple-columns-with-logical/m-p/4709#M1511 deleted_user 2007-09-15T22:18:36Z https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-3-0-filtering-multiple-columns-with-logical/m-p/4710#M1512 Hi:<BR /> I no longer have EG 3.0 to test specifically. But in general, SAS expects OR conditions to be specified in one of 2 ways:<BR /> [pre]<BR /> if jobcode = 'PILOT' or jobcode='BAGCLK' or jobcode = 'FLTAT' . . .<BR /> <BR /> if jobcode in ('PILOT', 'BAGCLK', 'FLTAT') . . .<BR /> [/pre]<BR /> <BR /> So, if you are trying to select something that would look like this:<BR /> [pre]<BR /> if jobcode = 'PILOT' or 'BAGCLK' or 'FLTAT' . . .<BR /> [/pre]<BR /> <BR /> Then EG would probably be unhappy. If you are using different columns, then the syntax would be similar:<BR /> [pre]<BR /> if jobcode = 'PILOT' or salary gt 50000 . . .<BR /> [/pre]<BR /> <BR /> For help with the exact click path to get an OR condition in EG 3.0, you might consider contacting Tech Support.<BR /> <BR /> cynthia Sun, 16 Sep 2007 04:20:37 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/enterprise-guide-3-0-filtering-multiple-columns-with-logical/m-p/4710#M1512 Cynthia_sas 2007-09-16T04:20:37Z