Via: uk.ac.leicester; Thu, 3 Sep 1992 16:27:51 +0100
Newsgroups: bit.listserv.sas-l
Date:         Thu, 3 Sep 1992 16:27:00 BST
Reply-To:     Mail_System@LEICESTER.AC.UK
From:         Mail_System@LEICESTER.AC.UK
Subject:      %% Undelivered Mail %%
Comments: To: SAS-L <SAS-L@VTVM2.CC.VT.EDU>

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:27 BST
Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
          id <sg.26578-1@sun3.nsfnet-relay.ac.uk>;
          Thu, 3 Sep 1992 16:26:27 +0100
Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
          id 9667; Thu, 03 Sep 92 11:22:01 EDT
Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
          with BSMTP id 2307; Thu, 03 Sep 92 11:21:59 EDT
Date: Thu, 3 Sep 1992 16: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>

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:19 BST
Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
          id <sg.25735-0@sun3.nsfnet-relay.ac.uk>;
          Thu, 3 Sep 1992 16:11:37 +0100
Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
          id 9575; Thu, 03 Sep 92 11:10:33 EDT
Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
          with BSMTP id 1705; Thu, 03 Sep 92 11:10:04 EDT
Date: Thu, 3 Sep 1992 16:07: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>

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:07 BST
Received: from vtvm2.cc.vt.edu by sun3.nsfnet-relay.ac.uk with Internet SMTP
          id <sg.25456-0@sun3.nsfnet-relay.ac.uk>;
          Thu, 3 Sep 1992 16:07:18 +0100
Received: from vtvm2.cc.vt.edu by VTVM2.CC.VT.EDU (IBM VM SMTP V2R2) with BSMTP
          id 9530; Thu, 03 Sep 92 11:06:17 EDT
Received: from VTVM2.BITNET by vtvm2.cc.vt.edu (Mailer R2.08 R208002)
          with BSMTP id 1358; Thu, 03 Sep 92 11:06:08 EDT
Date: Thu, 3 Sep 1992 16:03: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>

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>

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>

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

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
End of returned mail

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
End of returned mail

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
End of returned mail
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU