SAS/ACCESS(R) 9.2 Interface to PC Files: Reference
 |
|
| Supported Data Sources and Environments |
Supported Data Sources and Environments
The IMPORT and EXPORT procedures work within the limited range of available PC file formats if they reside locally on UNIX. The procedures work with a wider range of PC file formats if they reside locally on a PC.
The Import and Export Wizards and the IMPORT and EXPORT procedures are part of Base SAS software. If SAS/ACCESS Interface to PC files is not licensed, access is limited to CSV, TXT, and delimited files.
Alternate methods to access data are described in Methods for Accessing PC Files Data.
Note: The PC File Server
version MUST match the SAS version. ![[cautionend]](../../../../common/62850/HTML/default/images/cautend.gif)
| Data Source Description | Data Source Identifier | Import | Export | Supported Platforms | Supported SAS Platforms by Release | ||
|---|---|---|---|---|---|---|---|
| Wizard | PROC | Wizard | PROC | ||||
| Excel using a LIBNAME engine |
EXCEL
EXCEL 97 EXCEL 2000 EXCEL 2002 EXCEL 2003 EXCEL 2007 |
Yes | Yes | Yes | Yes | 32-bit Windows | 9.0 or higher |
| Excel using PC Files Server | EXCELCS | No | Yes | No | Yes |
64-bit Windows
Linux, UNIX |
9.1.3 or higher
9.1 or higher |
| Excel using .xls file formats | XLS | No | Yes | No | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
9.1.3 SP3 or higher |
| Excel 4 using PROC ACCESS and PROC DBLOAD | EXCEL 4 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 SP1 or higher |
| Excel 5 using PROC ACCESS and PROC DBLOAD | EXCEL 5 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 SP1 or higher |
| Access 2000 using LIBNAME engine |
ACCESS
ACCESS 2000 ACCESS 2002 ACCESS 2003 ACCESS 2007 |
Yes | Yes | Yes | Yes | 32-bit Windows | 9.0 or higher |
| Access 97 using LIBNAME engine | ACCESS 97 | Yes | Yes | Yes | Yes | 32-bit Windows | V9.0 or higher |
| Access using PC Files Server | ACCESSCS | No | Yes | No | Yes |
64-bit Windows
Linux, UNIX |
9.1.3 or higher
9.1 or higher |
| dBase using .DBF file formats | DBF | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
8.2 or higher
9.1.3 SP1 or higher 8.1 or higher |
| dBase file formats with MEMO support | DBFMEMO | No | Yes | No | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
9.2 |
| JMP using .JMP file formats | JMP | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
9.1 or higher
9.1.3 or higher 9.1 or higher |
| Paradox using .DB file formats | DB | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
9.2 |
| SPSS using .SAV file formats | SAV | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
9.1.3 SP3 or higher |
| Stata using .DTA file formats | DTA | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX |
9.1.3 SP3 or higher |
| Lotus 1-2-3 using .WK1 file formats | WK1 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 or higher |
| Lotus 1-2-3 using .WK3 file formats | WK3 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 or higher |
| Lotus 1-2-3 using .WK4 file formats | WK4 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 or higher |
| comma-separated file | CSV | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX Open VMS |
8.2 or higher |
| tab-separated file | TAB | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX Open VMS |
8.2 or higher |
| delimiter-separated file | DLM | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows Linux, UNIX Open VMS |
V8.2 or higher |
| data files using client/server model | PCFS | No | Yes | No | Yes |
64-bit Windows
Linux, UNIX |
9.1 or higher |
|
|
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
