TS-626 Configuring the SAS V8/V9 ODBC Drivers

• V8.2 - C:\Program Files\SAS Institute\ODBC
• V9.0 - C:\Program Files\SAS\ODBC

NOTE: Before installing, be sure to uninstall any older versions of the SAS ODBC Driver and to turn-off any virus detection software. SAS V9.0 requires Microsoft Data Access Components (MDAC) Version 2.7 or higher. MDAC is available for download at Microsoft Universal Data Access page. You can install the SAS V9 ODBC Driver on WINNT, WIN2000, or WINXP. Other Versions of Windows have not been tested for use with the SAS V9 ODBC Driver.

Below you will find step by step instructions for configuring the SAS V8/V9 ODBC drivers. To install under WINNT or WIN2000, administrator privileges are required. Documentation to configure and use the SAS ODBC driver is included in two forms: SAS ODBC Driver User's Guide and Programmer's Reference and SAS online Help. SAS ODBC Driver User's Guide and Programmer's Reference is available on the SAS OnlineDoc CD. The online Help is available by selecting the Help button when you configure SAS ODBC Driver Data Sources in the ODBC Data Source Administrator dialog box.

• Go to Start | Programs | ODBC | 32bit ODBC Administrator
  
• The ODBC Data Source Administrator box will appear. (The User DSN window will be the active window) -- Select ADD
• Choose SAS and select Finish
• 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
  • Records to Buffer: keep the default settings
  • SQL Options: keep the default settings
    
    
• Choose the SERVERS tab and fill in the Server Settings fields as follows:
  
  
  • Name: enter the name defined in the SERVICES file
    (ie. shr1 for local(single user) or machine.shr2 for SAS/SHARE(multi-user)).
    
    NOTE: The server name must be defined in c:\windows\services OR c:\winnt\system32\drivers\etc\services. To define the server name in the SERVICES file add the following line:

    
                 servername   number/tcp   # comment
    

    For number, choose a number that is not already used in the SERVICES file, and that is higher than 1024. For example, your entry may look like:

    
                 shr1        1234/tcp      # My SAS Server
    

    Then in your SERVER tab of the ODBC Driver, you would enter shr1 for the server name. You may have to reboot your PC after editing this file.
    
    
  • Password: leave blank
    
    
• Select the Configure button
  
  
  • For Local(Single User) the Local Options box will appear. Fill in the SAS Settings fields as follows:
    
    • 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 location of the sas.exe. NOTE: Do not quote the SAS library path even if containing space(s) and remove the -config option.
    • Working Directory: fully qualified path name for the directory you want to use as the SAS working directory. Remove all quotes.
    • Startup Parameters: 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. If the directory name contains spaces, you must enclose in either single or double quotes. (ie. -config "C:\Program Files\SAS Institute\SAS\V8\SASV8.CFG"). Also remove the option -comamid dde, if present.
    • Timeout: 60
      
      
  • For SAS/SHARE(multi-user) the SAS/SHARE Options box will appear. Fill in the Server Settings fields as follows:
    
    • Server Address: automatically filled with the node name that you specified in the Name field of the Servers page
    • User Name: enter your userid
    • User Password: enter your password
    • Connect Options: optional (used when connecting to an SPDS server)
      
      
• Click OK
• This brings you back to the SAS ODBC Driver Configuration box -- NOW select ADD. This will add the server to the list of Servers.
• Now select the Libraries tab. Fill in the Library Settings fields as follows:
  
  
  • 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 remaining boxes blank
  • Then click ADD -- this libname will be added to your libraries. You can add as many libraries as you like.
    
    
• Click OK
• This will bring you back to the SAS ODBC Driver Configuration box -- select OK
  
  NOTE: A FILE DSN is automatically created (ie. sas32(not sharable).dsn).