search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS/ACCESS(R) 9.2 Interface to PC Files: Reference
PDF
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
Features and Supported Data Sources
Features of the Import and Export Wizards and Procedures
Supported Data Sources and Platforms
Using the SAS Import and Export Wizards
Using the Import Wizard
Using the Export Wizard
External File Interface (EFI)
Using the IMPORT Procedure
Overview of the IMPORT Procedure
Syntax: IMPORT Procedure
PROC IMPORT Statement
Using the EXPORT Procedure
Overview of the EXPORT Procedure
Syntax: EXPORT Procedure
PROC EXPORT Statement
File Format-Specific Reference
Delimited Files
Microsoft Excel Workbook Files
Microsoft Access Database Files
Lotus 1–2–3 WKn Files
dBase DBF Files
dBase DBFMEMO Files
JMP Files
Paradox DB Files
SPSS SAV Files
Stata DTA Files
LIBNAME Statement and Pass-Through Facility on 32-Bit Microsoft Windows
The LIBNAME Engines
Overview of the LIBNAME Engines
Software Requirements
Macro Variables
SAS Trace System Options
SASTRACE= System Option
SASTRACELOC= System Option
The LIBNAME Statement for PC Files on Microsoft Windows
Overview of the LIBNAME Statement for PC Files on Microsoft Windows
Assigning a Libref Interactively
LIBNAME Statement Syntax for PC Files on Microsoft Windows
LIBNAME Options for PC Files on Microsoft Windows
Data Set Options for PC Files on Microsoft Windows
AUTOCOMMIT= Data Set Option
COMMAND_TIMEOUT= Data Set Option
CURSOR_TYPE= Data Set Option
DBCOMMIT= Data Set Option
DBCONDITION= Data Set Option
DBCREATE_TABLE_OPTS= Data Set Option
DBENCODING= Data Set Option
DBFORCE= Data Set Option
DBGEN_NAME= Data Set Option
DBKEY= Data Set Option
DBLABEL= Data Set Option
DBMAX_TEXT= Data Set Option
DBNULL= Data Set Option
DBNULLKEYS= Data Set Option
DBSASLABEL= Data Set Option
DBSASTYPE= Data Set Option
DBTYPE= Data Set Option
ERRLIMIT= Data Set Option
INSERT_SQL= Data Set Option
INSERTBUFF= Data Set Option
NULLCHAR= Data Set Option
NULLCHARVAL= Data Set Option
READBUFF= Data Set Option
SASDATEFMT= Data Set Option
The Pass-Through Facility for PC Files on Microsoft Windows
Overview of the Pass-Through Facility for PC Files on Microsoft Windows
Syntax for the Pass-Through Facility for PC Files
CONNECT Statement
DISCONNECT Statement
EXECUTE Statement
CONNECTION TO Component
Microsoft Jet Provider Supported Data Types
Special Jet 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
The PC Files Server on 32–Bit Microsoft Windows
Overview of the PC Files Server
Installing the PC Files Server
Starting the PC Files Server
Configuring the PC Files Server
Constraints
Shared Information
The LIBNAME Statement for PC Files on Linux, UNIX, and 64–bit Microsoft Windows
Overview of the LIBNAME Statement for PC Files on Linux, UNIX, and 64–Bit Microsoft Windows
LIBNAME Statement Syntax for PC Files on Linux and UNIX
LIBNAME Options for PC Files on Linux and UNIX
Data Set Options for PC Files on Linux and UNIX
AUTOCOMMIT= Data Set Option
COMMAND_TIMEOUT= Data Set Option
CURSOR_TYPE= Data Set Option
DBCOMMIT= Data Set Option
DBCONDITION= Data Set Option
DBCREATE_TABLE_OPTS= Data Set Option
DBFORCE= Data Set Option
DBGEN_NAME= Data Set Option
DBKEY= Data Set Option
DBLABEL= Data Set Option
DBMAX_TEXT= Data Set Option
DBNULL= Data Set Option
DBNULLKEYS= Data Set Option
DBSASTYPE= Data Set Option
DBTYPE= Data Set Option
ERRLIMIT= Data Set Option
INSERT_SQL= Data Set Option
INSERTBUFF= Data Set Option
NULLCHAR= Data Set Option
NULLCHARVAL= Data Set Option
READBUFF= Data Set Option
SASDATEFMT= Data Set Option
The Pass-Through Facility for PC Files on Linux, UNIX, and 64–bit Microsoft Windows
Overview of the 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 of the ACCESS Procedure for PC Files
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 for PC Files
Overview of the DBLOAD Procedure for PC Files
DBLOAD Procedure Naming Conventions
DBLOAD Procedure Syntax
PROC DBLOAD Statement
ACCDESC= Statement
DELETE Statement
ERRLIMIT= Statement
LABEL Statement
LIMIT= Statement
LIST Statement
LOAD Statement
PATH= Statement
QUIT Statement
RENAME Statement
RESET Statement
WHERE Statement
File-Specific Reference
ACCESS Procedure: XLS Specifics
DBLOAD Procedure: XLS Specifics
Setting Environment Variables for XLS Files
ACCESS Procedure: WKn Specifics
DBLOAD Procedure: WKn Specifics
Setting Environment Variables for WKn Files
ACCESS Procedure: DBF Specifics (Windows)
DBLOAD Procedure: DBF Specifics (Windows)
ACCESS Procedure: DIF Specifics
DBLOAD Procedure: DIF Specifics
Setting Environment Variables for DIF Files
Appendixes
The DBF and DIF Procedures
Introduction to the DBF and DIF Procedures
The DBF Procedure
The DIF Procedure
Sample Data
Introduction to Sample Data
Sample PC Files
Recommended Reading
Glossary
Index here
Product
Release
SAS/ACCESS Interface to PC Files
9.2
Type
Usage and Reference
Copyright Date
March 2008
Last Updated
15Apr2008
Previous Page
|
Next Page
Previous Page
|
Next Page
SAS/ACCESS 9.2 for PC Files: Reference
The Pass-Through Facility for PC Files on Microsoft Windows
Overview of the Pass-Through Facility for PC Files on Microsoft Windows
Syntax for the Pass-Through Facility for PC Files
CONNECT Statement
DISCONNECT Statement
EXECUTE Statement
CONNECTION TO Component
Microsoft Jet Provider Supported Data Types
Special Jet Queries
Special Jet Commands
Previous Page
|
Next Page
|
Top of Page
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
Previous Page
|
Next Page
|
Top of Page