Date:         Thu, 6 Jun 1996 07:51:23 -0700
Reply-To:     Peter Lund <PeterL@OFM.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Peter Lund <PeterL@OFM.WA.GOV>
Organization: Office of Financial Management, State of Washington
Subject:      Re: connect to ODBC with PROC SQL ??

Joahanna-
   I use SAS to access ODBC databases regularly.  You need to have the
SAS/ACCESS to ODBC module installed.  Once that is in place and your ODBC
data sources are defined it's easy.  If you have that SAS/ACCESS module
licensed, see Appendix D in the "Installation Instructions for the SAS
System under Microsoft Windows", pg 85 for details on installation.  If you
don't...  There are other ways to get data from Microsoft Access into SAS.
   If it seems that everything is installed correctly, a simple query like
this should work:
 
proc sql;
  connect to odbc (dsn="your Access data source name");
  select *
  from connection to odbc
    (select *
      from AccessTableName);
  disconnect from odbc;
quit;
 
Hope this helps.
 
Pete Lund
WA State Office of Financial Management
(360) 586-0707
peterl@ofm.wa.gov
 ----------
From: Joahanna Kirsch
To: WEI; PeterL; Harold; Multiple recipients of list SAS
Subject: connect to ODBC with PROC SQL ??
Date: Wednesday, June 05, 1996 3:56PM
 
I am trying to use proc sql and connect to a MS/ACCESS database to get
the data from my MS/ACCESS-Databases into SAS. But the SAS-System (SAS 6.11)
only gives me a error message:
The product with which the engine ODBC is associated is either not
licensed for your system or the product license has expired...
Has anyone out there allready used the SAS-pass-through facilities for
MS/ACCESS databases and could tell how it works?