The details of how you access your SAS data sources depend
on which ODBC-compliant application you are using (for example, Microsoft
Access or Excel), and on whether you are accessing local or remote
data. To access your data source, complete these steps:
-
Install the SAS Drivers
for ODBC. (See the installation instructions for the driver.) The
installation program provides the drivers for the ODBC Data Source
Administrator to use.
-
Double-click the ODBC
Data Sources or ODBC Administrator icon in the Control Panel window
to access the ODBC dialog box and the
SAS ODBC Driver
Configuration dialog box.
-
Use both of these dialog
boxes to provide the driver with the necessary information about your
SAS data sources. (
For more information, see Defining Your Data Sources.) SAS data sources can include
SAS data sets, DATA step views, PROC SQL views, or
SAS/ACCESS views. All of these contain definitions
of data that is stored elsewhere from the physical data itself. (For
more information, see
Types of Data Accessed with the SAS Drivers for ODBC and
SAS Data Sets.)
-
For information about
how to access or import data from other sources, see the documentation
for your Windows application. From the list of available data sources,
select the name of your SAS data source.
-
Select or enter the
name of the SAS library.
-
Select or enter the
name of the SAS data file or view.
For information about
configuring file data source names (DSN) for applications that use
file DSNs only (such as Microsoft Excel 97), see the online Help that
is available when you configure data sources in the
ODBC
Data Source Administrator.