home *** CD-ROM | disk | FTP | other *** search
- Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
- Path: sparky!uunet!paladin.american.edu!auvm!SWIRL.MONSANTO.COM!GIBES
- Message-ID: <9207272042.AA27710@tin.monsanto.com>
- Newsgroups: bit.listserv.sas-l
- Date: Mon, 27 Jul 1992 15:42:11 -0500
- Reply-To: Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
- Sender: "SAS(r) Discussion" <SAS-L@UGA.BITNET>
- From: Kernon Gibes <gibes@SWIRL.MONSANTO.COM>
- Subject: RE: SQL ? and SAS...
- Comments: To: SAS-L@uga.cc.uga.edu@tin.monsanto.com
- Comments: cc: GIBES@tin.monsanto.com
- Lines: 44
-
- CONTENT: Response
- SUMMARY: SQL is part of base SAS, works on data sets/views, ...
- REL/PLTF: 6.06+/all?
- E-ADDR: gibes@swirl.monsanto.com
- NAME: Kernon Gibes
- PHONE: (708) 506-2873
- DATE/TIME: 27 July 1992, 4:03 p.m. CDT
-
- Regarding:
-
- >I've been watching the SQL discussions for quite a while and it
- >just struck me that I haven't a clue on what types of files are
- >being used in these queries...
-
- >Does SQL under SAS work with any file that SAS understands ??
-
- Any SAS data set or view (actually, if you have SAS/ACCESS, I imagine
- you could be accessing a non-SAS data file/view, but I'm not experienced
- with this).
-
- >Do you need to have your datafiles in some special format ??
-
- What kinds of formats are you speaking of? Other than that the
- "datafiles" must be sets/views, I believe the answer is "no".
-
- >Is the SAS SQL PROC specially priced? or is it part of Base SAS ?
-
- It is part of base SAS.
-
- >Short of asking the systems people... how can I tell if my
- >installation has SAS SQL on it's various machines ??
-
- Since it is part of base SAS, version 6.06+, this should be more of a
- "which version of SAS am I running" question. However, you could always
- just try a:
-
- data junk; x=1; stop; run;
- proc sql;
- validate
- select * from junk;
- quit;
-
- and you'll either get a "NOTE: The PROC SQL syntax is valid" or an
- error message that PROC SQL is unknown.
-