home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #19 / NN_1992_19.iso / spool / bit / listserv / sasl / 4008 < prev    next >
Encoding:
Text File  |  1992-09-03  |  1.3 KB  |  31 lines

  1. Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
  2. Path: sparky!uunet!paladin.american.edu!auvm!NIHCU.BITNET!HIS
  3. Message-ID: <SAS-L%92090310082545@UGA.CC.UGA.EDU>
  4. Newsgroups: bit.listserv.sas-l
  5. Date:         Thu, 3 Sep 1992 10:08:02 EDT
  6. Reply-To:     Howard Schreier <HIS@NIHCU.BITNET>
  7. Sender:       "SAS(r) Discussion" <SAS-L@UGA.BITNET>
  8. From:         Howard Schreier <HIS@NIHCU.BITNET>
  9. Subject:      WHERE & FIRSTOBS
  10. Lines: 19
  11.  
  12. CONTENT:  Comment
  13. SUMMARY:  SQL WHERE and global SAS WHERE not same thing
  14. REL/PLTF: 6.06+
  15.  
  16. > In all procs WHERE and OBS/FIRSTOBS are mutually exclusive.
  17. > HOWEVER, look at the PROC SQL <options>; there is one to
  18. > control the number of observations (I think) and the number
  19. > of loops (essentially a "govenor" of sorts).
  20.  
  21. But,  the  SQL  WHERE  clause  and  the  SAS  WHERE  feature
  22. (implemented  both  as a statement and as a data set option)
  23. are two different things which just happen to share a name.
  24.  
  25. /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
  26. \   Howard Schreier, U.S. Dept. of Commerce, Washington    /
  27. /                     MVS 5.18 & 6.07                      \
  28. \   Voice: (202) 377-4180        BITNET: HIS@NIHCU         /
  29. /   Fax:   (202) 377-4614      INTERNET: HIS@CU.NIH.GOV    \
  30. \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
  31.