SAS/ACCESS(R) 9.2 Interface to PC Files: Reference
- What's New in SAS/ACCESS 9.2 Interface to PC Files
SAS/ACCESS 9.2 Interface to PC Files: Reference- Import and Export Wizards and Procedures
LIBNAME Statement and Pass-Through Facility on 32-Bit Microsoft Windows- The LIBNAME Engines
- 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
- File-Specific Reference
- LIBNAME Statement and Pass-Through Facility on Linux, UNIX, and 64-Bit Microsoft Windows
- The PC Files Server on 32–Bit Microsoft Windows
- 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
- ACCESS and DBLOAD Procedures
- The ACCESS Procedure for PC Files
- The DBLOAD Procedure for PC Files
- 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
- 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 |
| The LIBNAME Statement for PC Files on Microsoft Windows |
AUTOCOMMIT= Data Set Option
determines whether the ACCESS engine commits (saves) updates as soon as the user submits them.
| Valid in: | DATA and PROC steps |
| Default: | LIBNAME option setting |
| Syntax | |
| Syntax Description |
Syntax |
| AUTOCOMMIT=YES | NO |
Syntax Description
- YES
-
specifies that updates are committed to a table as soon as they are submitted, and no rollback is possible.
- NO
-
specifies that the SAS/ACCESS engine automatically performs the commit when it reaches the end of the file.
|
|
| Previous Page | | | Next Page | | | Top of Page |
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.