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
Product
Release
Base SAS
9.3
SAS/ACCESS Interface to PC Files
9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
08Mar2012