• Contents
  • About
  • Title Page
  • What's New in SAS/ACCESS 9.3 Interface to PC Files
  • Using This Document
  • Introduction to SAS/ACCESS 9.3 Interface to PC Files
    • Working with SAS/ACCESS 9.3 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
      • Importing and Exporting Data with the Wizards
      • Using the External File Interface (EFI)
    • The IMPORT Procedure
      • Syntax: IMPORT Procedure
        • PROC IMPORT
      • Overview: PROC IMPORT
    • The EXPORT Procedure
      • Syntax: EXPORT Procedure
        • PROC EXPORT
      • Overview: PROC EXPORT
    • File Format-Specific Reference for the IMPORT and EXPORT Procedures
      • Delimited Files
      • Microsoft Excel Workbook Files
      • Microsoft Access Database Files
      • Lotus 1-2-3 WKn Files
      • dBase DBF Files
      • dBase DBF MEMO Files
      • JMP Files
      • Paradox DB File Formats
      • SPSS SAV Files
      • Stata DTA Files
  • LIBNAME Access and Excel Engines on Microsoft Windows
    • Interaction and Functionality
      • Overview of LIBNAME Statement for Access and Excel on Microsoft Windows
      • Sorting PC Files Data
      • Using SAS Functions with PC Files Data
      • Assigning a Libref Interactively
    • The LIBNAME Engines
      • Overview: LIBNAME Engines
      • Software Requirements
      • Macro Variables
      • System Options
      • SASTRACE
      • SASTRACELOC
    • The LIBNAME Statement for Access and Excel on Microsoft Windows
      • LIBNAME Statement Syntax
    • Data Set Options
      • Overview of Data Set Options
      • AUTOCOMMIT
      • COMMAND_TIMEOUT
      • CURSOR_TYPE
      • DBCOMMIT
      • DBCONDITION
      • DBCREATE_TABLE_OPTS
      • DBFORCE
      • DBGEN_NAME
      • DBKEY
      • DBLABEL
      • DBMAX_TEXT
      • DBNULL
      • DBNULLKEYS
      • DBSASLABEL
      • DBSASTYPE
      • DBTYPE
      • DBTYPE
      • ERRLIMIT
      • INSERT_SQL
      • INSERTBUFF
      • NULLCHAR
      • NULLCHARVAL
      • READBUFF
      • SASDATEFMT
    • LIBNAME Options
      • LIBNAME Options
    • Pass-Through Facility for Access and Excel on Microsoft Windows
      • Pass-Through Facility on Microsoft Windows
      • SQL Procedure
      • CONNECT Statement
      • DISCONNECT Statement
      • EXECUTE Statement
      • CONNECTION TO Component
      • Microsoft Jet and Microsoft Ace Provider Supported Data Types
      • Ace and Jet Special Queries
      • Special Jet Commands
    • File-Specific Reference for Access and Excel on Microsoft Windows
      • Microsoft Excel Workbook Files
      • Microsoft Access Files
  • LIBNAME PCFILES Engine and PC Files Server on Microsoft Windows
    • PC Files Server Administration
      • Overview
      • Windows Service
      • Desktop Application
      • PC Files Server Configuration
      • Authentication
      • PC Files Server Autostart
      • Local Security Policy Configuration
      • Constraints
      • Shared Information
    • LIBNAME Statement for PCFILES Engine on Linux, UNIX, and Microsoft Windows
      • LIBNAME Statement for PCFILES Engine on Linux, UNIX, and Microsoft Windows
      • Syntax for PCFILES Engine on Linux, UNIX, and Microsoft Windows
      • SAS LIBNAME Options for PCFILES on Linux, UNIX, and Microsoft Windows
      • Data Set Options for PCFILES on Linux, UNIX, and Microsoft Windows
      • 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
    • Pass-Through Facility: PCFILES on Linux, UNIX, and Microsoft Windows
      • Overview: Pass-Through Facility for PCFILES on Linux, UNIX, and Microsoft Windows
      • Syntax for the Pass-Through Facility for PCFILES
      • CONNECT Statement
      • DISCONNECT Statement
      • EXECUTE Statement
      • CONNECTION TO Component
    • Special Query Support
      • Special PCFILES Queries
  • ACCESS and DBLOAD Procedures
    • The ACCESS Procedure for PC Files
      • Syntax: ACCESS Procedure
        • PROC ACCESS
        • ASSIGN
        • CREATE
        • DROP
        • FORMAT
        • LIST
        • MIXED
        • PATH
        • QUIT
        • RENAME
        • RESET
        • SELECT
        • SUBSET
        • TYPE
        • UNIQUE
        • UPDATE
      • Overview: ACCESS Procedure
      • SAS/ACCESS Descriptors for PC Files
      • SAS Passwords for Descriptors
      • Performance and Efficient View Descriptors for PC Files
    • The DBLOAD Procedure
      • Syntax: DBLOAD Procedure Procedure
        • PROC DBLOAD
        • ACCDESC
        • DELETE
        • ERRLIMIT
        • FMTLIB
        • LABEL
        • LIMIT
        • LIST
        • LOAD
        • PATH
        • QUIT
        • RENAME
        • RESET
        • WHERE
      • Overview: DBLOAD Procedure
    • 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
    • LIBNAME Statement for the JMP Engine
      • LIBNAME Statement for the JMP Engine
    • The DBF and DIF Procedures
      • Overview: DBF and DIF Procedures
      • The DBF Procedure
      • PROC DIF Statement Options
  • Recommended Reading
  • Glossary


ProductRelease
Base SAS9.3
SAS/ACCESS Interface to PC Files9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
08Mar2012