Newsgroups: bit.listserv.sas-l
Date:         Mon, 5 Oct 1992 15:47:40 PDT
Reply-To:     "(Claire Castell)" <Claire.Castell@EBAY.SUN.COM>
From:         "(Claire Castell)" <Claire.Castell@EBAY.SUN.COM>
Subject:      Re: SAS/ACCESS under Unix
Comments: To: SAS-L@OHSTVMA.IRCC.OHIO-STATE.EDU

Yes !!! And it's Working !!  We have the "extremely experimental" version
6.09 for Sun (UNIX) here at Sun Microystems.  SAS Institute is very
interested and cooperative with our test results. (I'm sure they are
tired of me b*tching at them for 2 years for the Sybase interface). We
have Sybase and Oracle working now. I understand Ingres is later on.

These SAS/ACCESS products will be included in the next production release
in the Spring or Summer of 1993.

Below, I have a blurb I sent to my internal users at Sun, if you are
interested. BTW, it's in OpenWindows and there will be a Solarius 2 port.

Claire Castell, Sun Microsystems, Inc.

..From SAS-L@uga.cc.uga.edu  Fri Oct  2 18:19:46 1992
..Subject:      SAS/ACCESS under Unix
..Comments: To: sas-l@ohstvma.ircc.ohio-state.edu
..Comments: cc: schild@alishaw.ucsb.edu
..To: Multiple recipients of list SAS-L <SAS-L@uga.cc.uga.edu>
..Content-Length: 413
..X-Lines: 16
..
..Hi Folks,
..
..   I just received my License Fee Schedule for the SAS System
..under Unix/OpenVMS, effective Jan 1, 1993. I noticed that they describe:
..
..SAS/ACCESS under Sun includes Interfaces to ORACLE,
..INGRES, and SYBASE.
..
..   Could this be true?  Either now or in the NEAR future?
..If so, bravo SAS!!!  Anyone out there able to comment from
..hands-on a beta?
..
..Cheers,
..Mark Schildhauer
..SSCF
..Univ. Calif., Santa Barbara
..
*---------------------------  Internal Email ---------------------------*
From Claire.Castell@EBay  Fri Sep 25 16:25:33 1992
To: sas-users@Sun.COM
Subject: SAS Version 6.09 Update

	       * SAS Interfaces to Sybase and Oracle *

Many of you expressed interest in the long-promised interfaces to
Sybase and Oracle in the SAS Software.  SAS Institute gave us an
experimental copy of the next release, 6.09, with the interfaces,
called SAS/ACCESS.  Daryl Tilley has been testing the interfaces both to
Sybase and Oracle with VERY GOOD results !

This means that SAS can used to perform reporting and analysis, high
quality graphics, statistics, etc., directly on Sybase and Oracle data-
bases without making extracts or duplicate files.  SAS's reporting
capabilites are generally superior to Focus or SQL.  Those of you
faced with converting your SAS mainframe programs to something that
will read Oracle or Sybase on Unix may find this a quick solution,
rather than recoding in another language or query.

To give you an idea of the ease of use, the following are the steps
a user would follow to be able to run SAS programs using a Sybase or
Oracle database, with straight pass-through of data.

1. In the Program Editor type:
	Proc Access ; run;
2. Define the FILE DESCRIPTOR in the Access window
	a. Define the LIBREF and a file descriptor name (abitrary name)
	b. Select an engine (Sybase or Oracle for now, Ingres later)
	c. Create a description:
		username: 	(database login)
		password: 	(database password)
		database name:	sunbias
		table:		pmf
		server:		SUNBIAS  (sybase server)
		Interfaces:	/home/dataless/dst00/interfaces
3.  Create a View
    The above window returns a window with all the fields in the table
    requested. This windows allows you to select only the fields you need,
    rename them if needed, and write sub-setting criteria (SQL where clause).

4.  You now have a permanent "view" that acts just like any SAS dataset
    that you can use in a data step, a PROC or with Proc SQL.  You only
    go through steps 1-3 once.  After a view is created you treat it like
    a SAS dataset.

	PROC PRINT DATA = sybase.pmf; run;

    You can even EDIT the database with SAS's data editors, FSEDIT and
    FSVIEW and directly change the Sybase or Oracle data through SAS.

    A SAS program easily reads multiple "Views", flat files and SAS datasets
    so one program could read and report any combination of Sybase, Oracle
    and other data files in one program.

Again, this version is EXPERIMENTAL.  The production version will be out
in the Spring of 1993, although I will have a good Beta version before
that.  If you would like to test your application with this version,
contact Daryl Tilley at daryl.tilley@EBay or 34060.

(SAS uses OpenWindows Interface, 3.0 and is writing a Solaris 2 port)

Thanks,
 Claire Castell
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU