• Contents
  • About
  • What's New in SAS/ACCESS 9.2 Interface to PC Files
  • SAS/ACCESS 9.2 Interface to PC Files: Reference
    • Working with SAS/ACCESS Interface to PC Files
      • Methods for Accessing PC Files Data
      • Using This Document
      • Sample Data in This Document
  • Import and Export Wizards and Procedures
    • Supported Data Sources and Environments
      • Reading and Writing Data between SAS Data Sets and PC Files
      • Supported Data Sources and Environments
    • Using the SAS Import and Export Wizards
      • Overview
      • Importing and Exporting Data with the Wizards
      • Using the External File Interface (EFI)
    • The IMPORT Procedure
      • Overview: PROC IMPORT
      • Syntax: IMPORT Procedure
        • PROC IMPORT Statement
    • The EXPORT Procedure
      • Overview: PROC EXPORT
      • Syntax: EXPORT Procedure
        • PROC EXPORT Statement
    • File Format-Specific Reference
      • Delimited Files
      • Microsoft Excel Workbook Files
      • Microsoft Access Database Files
      • Microsoft Access Data Types
      • The Conversion of Date and Time Values between SAS Data Sets and Microsoft Access Database
      • The IMPORT and EXPORT Procedure Statements for Access Files
      • Lotus 1-2-3 WKn Files
      • dBase DBF Files
      • dBase DBFMEMO Files
      • JMP Files
      • Paradox DB File Formats
      • SPSS SAV Files
      • Stata DTA Files
  • LIBNAME Statement and Pass-Through Facility on 32-Bit Microsoft Windows
    • The LIBNAME Engines
      • Overview: LIBNAME Engines
      • Software Requirements
      • Macro Variables
      • System Options
      • SASTRACE
      • SASTRACELOC
    • LIBNAME Statement: PC Files on Microsoft Windows
      • LIBNAME Statement: PC Files on Microsoft Windows
      • LIBNAME Statement Syntax
      • LIBNAME Options
      • Data Set Options
      • AUTOCOMMIT
      • COMMAND_TIMEOUT
      • CURSOR_TYPE
      • DBCOMMIT
      • DBCONDITION
      • DBCREATE_TABLE_OPTS
      • DBENCODING
      • DBFORCE
      • DBGEN_NAME
      • DBKEY
      • DBLABEL
      • DBMAX_TEXT
      • DBNULL
      • DBNULLKEYS
      • DBSASLABEL
      • DBSASTYPE
      • DBTYPE
      • ERRLIMIT
      • INSERT_SQL
      • INSERTBUFF
      • NULLCHAR
      • NULLCHARVAL
      • READBUFF
      • SASDATEFMT
    • LIBNAME Statement and Pass-Through Facility for PC Files on Microsoft Windows
      • LIBNAME Statement and Pass-Through Facility on Microsoft Windows
      • Syntax for the Pass-Through Facility for PC Files
      • CONNECT Statement
      • DISCONNECT Statement
      • EXECUTE Statement
      • CONNECTION TO Component
      • Microsoft Jet and Microsoft Ace Provider Supported Data Types
      • Special Jet and Ace Queries
      • Special Jet Commands
    • File-Specific Reference
      • Microsoft Excel Workbook Files
      • Microsoft Access Files
  • LIBNAME Statement and Pass-Through Facility on Linux, UNIX, and 64-Bit Microsoft Windows
    • PC Files Server Administration
      • Overview
      • Windows Service
      • Desktop Application
      • Configuring PC Files Server
      • Authentication
      • PC Files Server Autostart
      • Local Security Policy Configuration
      • Constraints
      • Shared Information
    • LIBNAME Statement
      • LIBNAME Statement for PC Files on Linux, UNIX, and 64-Bit Microsoft Windows
      • Syntax for PC Files on Linux, UNIX, and 64-Bit Microsoft Windows
      • SAS LIBNAME Options for PC Files on Linux and UNIX
      • Data Set Options for PC Files on Linux and UNIX, and 64-Bit Windows
      • AUTOCOMMIT
      • COMMAND_TIMEOUT
      • CURSOR_TYPE
      • DBCOMMIT
      • DBCONDITION
      • DBCREATE_TABLE_OPTS
      • DBFORCE
      • DBGEN_NAME
      • DBKEY
      • DBLABEL
      • DBMAX_TEXT
      • DBNULL
      • DBNULLKEYS
      • DBSASTYPE
      • DBTYPE
      • ERRLIMIT
      • INSERT_SQL
      • INSERTBUFF
      • NULLCHAR
      • NULLCHARVAL
      • READBUFF
      • SASDATEFMT
    • Pass-Through Facility: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows
      • Overview: Pass-Through Facility for PC Files on Linux, UNIX, and 64-Bit Microsoft Windows
      • Syntax for the Pass-Through Facility for PC Files
      • CONNECT Statement
      • DISCONNECT Statement
      • EXECUTE Statement
      • CONNECTION TO Component
      • Special PC Files Queries
  • ACCESS and DBLOAD Procedures
    • The ACCESS Procedure for PC Files
      • Overview: ACCESS Procedure
      • SAS/ACCESS Descriptors for PC Files
      • SAS Passwords for Descriptors
      • Performance and Efficient View Descriptors for PC Files
      • ACCESS Procedure Syntax
        • PROC ACCESS Statement
        • ASSIGN Statement
        • CREATE Statement
        • DROP Statement
        • FORMAT Statement
        • LIST Statement
        • MIXED Statement
        • PATH= Statement
        • QUIT Statement
        • RENAME Statement
        • RESET Statement
        • SELECT Statement
        • SUBSET Statement
        • TYPE Statement
        • UNIQUE Statement
        • UPDATE Statement
    • The DBLOAD Procedure
      • Overview: DBLOAD Procedure
      • Syntax: DBLOAD Procedure
        • PROC DBLOAD Statement
    • File-Specific Reference for the ACCESS and DBLOAD Procedures
      • Overview: ACCESS Procedure and DBLOAD Procedure
      • ACCESS Procedure: XLS Files
      • DBLOAD Procedure: XLS Specifics
      • ACCESS Procedure: WKn Specifics
      • DBLOAD Procedure: WKn Specifics
      • ACCESS Procedure: DBF Specifics
      • DBLOAD Procedure: DBF Specifics (Windows)
      • ACCESS Procedure: DIF Specifics
      • DBLOAD Procedure: DIF Specifics
  • Appendixes
    • The DBF and DIF Procedures
      • Overview: DBF and DIF Procedures
      • The DBF Procedure
      • The DIF Procedure
    • Recommended Reading
  • Glossary


ProductRelease
Base SAS9.2
SAS/ACCESS Interface to PC Files9.2
Type
Usage and Reference
Copyright Date
May 2010
Last Updated
20May2010