home *** CD-ROM | disk | FTP | other *** search
- Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
- Path: sparky!uunet!paladin.american.edu!auvm!NIHCU.BITNET!HIS
- Message-ID: <SAS-L%92090310082545@UGA.CC.UGA.EDU>
- Newsgroups: bit.listserv.sas-l
- Date: Thu, 3 Sep 1992 10:08:02 EDT
- Reply-To: Howard Schreier <HIS@NIHCU.BITNET>
- Sender: "SAS(r) Discussion" <SAS-L@UGA.BITNET>
- From: Howard Schreier <HIS@NIHCU.BITNET>
- Subject: WHERE & FIRSTOBS
- Lines: 19
-
- CONTENT: Comment
- SUMMARY: SQL WHERE and global SAS WHERE not same thing
- REL/PLTF: 6.06+
-
- > In all procs WHERE and OBS/FIRSTOBS are mutually exclusive.
- > HOWEVER, look at the PROC SQL <options>; there is one to
- > control the number of observations (I think) and the number
- > of loops (essentially a "govenor" of sorts).
-
- But, the SQL WHERE clause and the SAS WHERE feature
- (implemented both as a statement and as a data set option)
- are two different things which just happen to share a name.
-
- /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
- \ Howard Schreier, U.S. Dept. of Commerce, Washington /
- / MVS 5.18 & 6.07 \
- \ Voice: (202) 377-4180 BITNET: HIS@NIHCU /
- / Fax: (202) 377-4614 INTERNET: HIS@CU.NIH.GOV \
- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
-