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
Advanced Search
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
|
Purchase
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 Server
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
Import and Export Wizards Overview
Using the External File Interface (EFI)
Using the IMPORT Procedure
IMPORT Procedure Overview
Syntax: IMPORT Procedure
PROC IMPORT Statement
Using the EXPORT Procedure
EXPORT Procedure Overview
Syntax: EXPORT Procedure
PROC EXPORT Statement
File Format-Specific Reference
Overview Delimited Files
Microsoft Excel Workbook Files
Importing and Exporting Microsoft Excel Files with the ACCESS and DBLOAD Procedures
Microsoft Access Database Files
Lotus 1-2-3 WK n 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
SAS Trace 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
The 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: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows
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= 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
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 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
DBLOAD Procedure Overview
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
Recommended Reading
Glossary
Index here
Product
Release
SAS/ACCESS Interface to PC Files
9.2
Type
Usage and Reference
Copyright Date
February 2009
Last Updated
30Sep2009
Previous Page
|
Next Page
Previous Page
|
Next Page
SAS/ACCESS 9.2 for PC Files: Reference
The ACCESS Procedure for PC Files
Overview: 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
Previous Page
|
Next Page
|
Top of Page
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
Previous Page
|
Next Page
|
Top of Page