Methods for Accessing PC Files Data

You can use SAS/ACCESS Interface to PC Files to read data from PC files, to use that data in SAS reports or applications, and to use SAS data sets to create PC files in various formats. SAS/ACCESS Interface to PC Files includes the following features:

Import and Export Wizards, IMPORT procedure, and EXPORT procedure (OpenVMS, UNIX, and Microsoft Windows operating environments)

enables data transfer between SAS and several PC file formats, including Microsoft Access, Microsoft Excel, Lotus 1-2-3, and DBF. Not every PC file format is available under every operating environment. For a list of file formats that are supported under your operating environment, see Availability of the Import/Export Wizards and Procedures.

LIBNAME statement (Linux, UNIX, and Microsoft Windows operating environments)

provides direct, transparent access to Microsoft Access (97, 2000, 2002, and 2003) and Microsoft Excel (5, 95, 97, 2000, 2002, or 2003) data. To use the LIBNAME statement to access PC files on Linux and UNIX, you are required to install the PC Files Server. (For more information, see The PC Files Server on 32–Bit Microsoft Windows.)

Pass-Through Facility (Linux, UNIX, and Microsoft Windows operating environments)

enables access to Microsoft Access (97, 2000, 2002, or 2003) and Microsoft Excel (5, 95, 97, 2000, 2002, or 2003) data using the SQL syntax to the data source without leaving your SAS session. SQL statements are passed directly to the data source for processing.

ACCESS procedure (Microsoft Windows operating environments)

creates descriptor files that describe data in a PC file to SAS so you can directly read, update, or extract PC files data into a SAS data file. You can use the ACCESS procedure with Microsoft Excel (4, 5, 95), Lotus 1-2-3 (WK1, WK3, WK4), DBF, and DIF file formats.

DBLOAD procedure (Microsoft Windows operating environments)

creates PC files and loads them with data from a SAS data set. You can use the DBLOAD procedure with any file formats that the ACCESS procedure supports.

DBF and DIF procedures (Linux, UNIX, Microsoft Windows, and z/OS operating environments)

enable conversion between dBASE (DBF) files and SAS data sets and between data interchange format (DIF) files and SAS data sets. The DIF procedure is not available under z/OS.

Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.