Usage Note 7109: WHERE expression processed first when used with OBS= or FIRSTOBS=
OPTIONS
Beginning in Release 8.1, applying OBS= and FIRSTOBS= processing to a
subset of data is supported for the WHERE statement, WHERE= data set
OPTION, and WHERE clause in the SQL procedure.
When used with a WHERE expression, the values specified for OBS= and
FIRSTOBS= are not physical observation numbers in the data set, but
rather logical numbers in the subset. The WHERE is processed first
and the OPTIONS are then applied to the returned subset.
See the "Processing a Segment of Data That Is Conditionally Selected"
discussion in the SAS System Help for further information and
examples.
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows NT Workstation | 8.1 TS1M0 | |
| Microsoft Windows 95/98 | 8.1 TS1M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.1 TS1M0 | |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | |
| Microsoft Windows 2000 Server | 8.1 TS1M0 | |
| Solaris | 8.1 TS1M0 | |
| OpenVMS VAX | 8.1 TS1M0 | |
| Microsoft Windows 2000 Advanced Server | 8.1 TS1M0 | |
| IRIX | 8.1 TS1M0 | |
| 64-bit Enabled Solaris | 8.1 TS1M0 | |
| z/OS | 8.1 TS1M0 | |
| OS/2 | 8.1 TS1M0 | |
| 64-bit Enabled HP-UX | 8.1 TS1M0 | |
| HP-UX | 8.1 TS1M0 | |
| ABI+ for Intel Architecture | 8.1 TS1M0 | |
| AIX | 8.1 TS1M0 | |
| Tru64 UNIX | 8.1 TS1M0 | |
| 64-bit Enabled AIX | 8.1 TS1M0 | |
| CMS | 8.1 TS1M0 | |
| OpenVMS Alpha | 8.1 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | |
| Topic: | Common Programming Tasks ==> Conditional Processing
Common Programming Tasks ==> Selecting Data
SAS Reference ==> Statements ==> Action ==> WHERE
|
| Date Modified: | 2008-03-26 11:07:27 |
| Date Created: | 2002-03-12 14:19:18 |
