TS-593

CONFIGURING THE SAS V6.12 32-bit ODBC DRIVER

Download the SAS V6.12 32-bit ODBC driver from http://www.sas.com. Select Service & Support, then select Demos and Downloads, under SAS System Software Products, select ODBC Drivers, under 'For Version 6 of the SAS System', select SAS ODBC Drivers, select 32-bit version of the SAS ODBC Driver. After downloading the file, run SASODBC.EXE to install the driver. At the end of the install process, a dialog box appears that lists the ODBC datasources, close this box so that the setup program will complete.

Below you will find step by step instructions for configuring the SAS V6.12 32-bit ODBC driver. This ODBC driver is implemented on the Microsoft Windows 9x and Windows NT platforms. For more detailed information, refer to the SAS ODBC Driver Technical Report: User's Guide and Programmer's Reference.

 1.  Go to Start | Programs | ODBC | 32bit ODBC Administrator
 2.  The ODBC Data Source Administrator box will appear. (The User DSN window will
     be the active window) -- Select ADD
 3.  Choose SAS and select Finish
 4.  The SAS ODBC Driver Configuration box will appear. Fill in the fields as
     follows:

     -- Data Source Name: enter a name (The name must begin with a letter, ie. SAS32)
     -- Description:  leave blank
     -- Server:  leave blank

 5.  Choose the SERVERS tab and fill in the fields as follows:

     -- Server Name: enter a name (it must be less than 8 characters, ie. LOCAL)
     -- Password:  leave blank
     -- Access Method:  select DDE (Make sure Single User Local Server is selected)

        NOTE: DDE is used to access local SAS data sets.  For information on 
        configuring a SAS server to access SAS data sets cross host using TCP
        refer to the SAS ODBC Driver Technical Report: User's Guide and
        Programmer's Reference.

 6. Select the Configure button
 7. The Local DDE Options box will appear.  Fill in the fields as follows:

    -- SAS Path: specify the fully qualified path name for the SAS executable (SAS.EXE)
       that you use to start a SAS session. If you are unsure of that location, go to 
       your SAS Icon and right click -- select Properties -- select Shortcut. Under 
       Target check the directory and subdirectory location of the sas.exe.
    -- Working Directory: fully qualified path name for the directory you 
       use as the SAS working directory.
    -- SAS Parameter:  should not need to change this unless SAS is on a 
       network and you have a local config.sas. In this case, add the config option 
       to your parameters. (ie. -config c:\sas\config.sas)

 8. Click OK
 9. This brings you back to the SAS ODBC Driver Configuration box -- NOW select
    ADD. This will add the server to the list of Servers.
10. Now select the Libraries tab. Fill in the fields as follows:

    -- Library Name: enter a SAS library name. The name can be up to eight characters 
       long. (ie. USER).  For users familiar with SAS, this field corresponds to the
       libref in the SAS Libname statement.  NOTE: Microsoft Access users will need the
       Library name USER in order to create or update SAS data sets from MSACCESS.
    -- Host File Name: type in the location of the SAS datasets (ie. c:\foo)
    -- Leave the rest of the boxes blank
    -- Then click ADD -- this libname will be added to your libraries. You can add as
       many libraries as you like.

11. Click OK
12. This will bring you back to the SAS ODBC Driver Configuration box -- select OK
13. Select the File DSN tab. Click the Add button
14. Select SAS and click Next
15. Type in the name of the SAS User DSN that you just created (ie. SAS32)
16. Click NEXT, and then click FINISH
17. Ignore the message that you receive and click Yes to save
18. The SAS Data Source will be listed as a File DSN, click OK
19. Next, go to START | FIND | FILES OR FOLDERS | and Under Named: enter the SAS Data
    Source name created above (ie. SAS32.dsn) and then click on FIND NOW.  File DSNs
    are stored by default in C:\Program Files\Common Files\Odbc\Data Sources.
20. This file will appear in the window, double click to open the file in Notepad to
    correct the data source file.
21. You will see

    [ODBC] 
    DRIVER=SAS 

    You must correct it to read 
   
    [ODBC] 
    DSN=SAS32 

22. From the File pull-down menu in Notepad, select Save, and then select Exit