Chapter Contents

Previous

Next

Using Parentheses and Other Operators

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.

Changing a WHERE Expression

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.

AND

Select AND from the list.

Select Operators. Select ( from the list. Select Birth date from the list of Available Columns. Select OTHER Operators from the Operators list to display a second menu of operators.

Between

Select Between from the list of OTHER Operators.

Select <LOOKUP distinct values> from the list of Available Columns.

Select 17OCT1945 from the list of Lookup Values. Because the BETWEEN operator requires a second value, the Lookup Distinct Values window appears again after you have selected a value. Select 18DEC1948 from the list of Lookup Values.

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.

Viewing Your Output

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.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.