home *** CD-ROM | disk | FTP | other *** search
- Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
- Path: sparky!uunet!uvaarpa!darwin.sura.net!paladin.american.edu!auvm!LEICESTER.AC.UK!MAIL_SYSTEM
- Via: uk.ac.leicester; Thu, 3 Sep 1992 16:03:41 +0100
- Message-ID: <SAS-L%92090311060000@VTVM2.BITNET>
- Newsgroups: bit.listserv.sas-l
- Date: Thu, 3 Sep 1992 16:03:00 BST
- Reply-To: Mail_System@LEICESTER.AC.UK
- Sender: "SAS(r) Discussion" <SAS-L@UGA.BITNET>
- From: Mail_System@LEICESTER.AC.UK
- Subject: %% Undelivered Mail %%
- Comments: To: SAS-L <SAS-L@VTVM2.CC.VT.EDU>
- Lines: 70
-
- Your mail was not delivered as follows:
- %MAIL-E-USERSPEC, invalid user specification '@UK.AC.LEICESTER.IRIX'
-
- Your original mail header and message follow.
-
- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
- Via: UK.AC.NSFNET-RELAY; Thu, 3 Sep 92 16:03 BST
- Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
- id <sg.25186-0@sun3.nsfnet-relay.ac.uk>;
- Thu, 3 Sep 1992 16:02:59 +0100
- Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
- id 9480; Thu, 03 Sep 92 11:01:52 EDT
- Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
- with BSMTP id 0965; Thu, 03 Sep 92 11:01:30 EDT
- Date: Thu, 3 Sep 1992 15:19:00 BST
- Reply-To: Mail_System@UK.AC.LEICESTER
- Original-Sender: "SAS(r) Discussion" <SAS-L@EDU.VT.CC.VTVM2>
- From: Mail_System@UK.AC.LEICESTER
- Subject: %% Undelivered Mail %%
- Comments: To: SAS-L <SAS-L@VTVM2.CC.VT.EDU>
- To: Multiple recipients of list SAS-L <SAS-L@EDU.VT.CC.VTVM2>
- Sender: SAS-L@EDU.VT.CC.VTVM2
-
- Your mail was not delivered as follows:
- %MAIL-E-USERSPEC, invalid user specification '@UK.AC.LEICESTER.IRIX'
-
- Your original mail header and message follow.
-
- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
- Via: UK.AC.NSFNET-RELAY; Thu, 3 Sep 92 15:19 BST
- Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
- id <sg.22549-0@sun3.nsfnet-relay.ac.uk>;
- Thu, 3 Sep 1992 15:18:24 +0100
- Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
- id 9228; Thu, 03 Sep 92 10:16:05 EDT
- Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
- with BSMTP id 9245; Thu, 03 Sep 92 10:16:04 EDT
- Date: Thu, 3 Sep 1992 10:08:02 EDT
- Reply-To: Howard Schreier <HIS%BITNET.NIHCU@EDU.VT.CC.VTVM2>
- Original-Sender: "SAS(r) Discussion" <SAS-L@EDU.VT.CC.VTVM2>
- From: Howard Schreier <HIS%BITNET.NIHCU@EDU.VT.CC.VTVM2>
- Subject: WHERE & FIRSTOBS
- To: Multiple recipients of list SAS-L <SAS-L@EDU.VT.CC.VTVM2>
- Sender: SAS-L@EDU.VT.CC.VTVM2
-
- 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 \
- \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
-
- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
- End of returned mail
-
- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
- End of returned mail
-