You can use operators other than the comparison operators to subset your data for querying; you can easily change a WHERE condition that has been previously set.
You can change the WHERE expression in SASUSER.PROFILE.EDU20 from the previous example. In the SQL QUERY TABLES window, select
View – Where Conditions for Subset
Select Operators to display the list of valid operators.
Select AND from the list.
Select Operators . Select ( from the list. Select Birth date from the Available Columns list. Select OTHER Operators from the list of operators to display a second menu of operators.
Select Between from the list of other operators.
Select <LOOKUP distinct values> from the Available Columns list.
Select 17OCT1945 from the Lookup Values list. Because the Between operator requires a second value, the Lookup Distinct Values window appears again after you select a value. Select 18DEC1948 from the Lookup Values list.
In the WHERE EXPRESSION window, select Operators . Select ) from the list of operators to complete the expression that will be evaluated first when the query is run.
Select OK to return to the SQL QUERY COLUMNS window.
Select
Tools – Run Query – Run Immediate
to display the output of your query.
From the SQL QUERY COLUMNS window, select
Tools – Reset
to reset your query.