SAS/ACCESS(R) 9.2 Interface to PC Files: Reference
 |
|
| Features and Supported Data Sources |
Supported Data Sources and Platforms
The IMPORT and EXPORT procedures work within the same limited range of file formats if these reside locally on UNIX, but they also work with a wider range of PC file formats if these are on the PC.
This table shows the availability of Import and Export Wizards and procedures with respect to the data source components and platforms.
The Import and Export Wizards and procedures are part of Base SAS software. If you do not have a license to SAS/ACCESS Interface to PC Files, however, you can access only CSV, TXT, and delimited files.
You can also use alternate methods to access data in PC file formats under Linux, UNIX, Microsoft Windows, and z/OS operating environments.
| Data Source Description | Data Source Identifier | Import | Export | Supported Platforms | Supported SAS Releases on Platforms | ||
|---|---|---|---|---|---|---|---|
| Wizard | PROC | Wizard | PROC | ||||
| Excel using LIBNAME engine |
EXCEL
EXCEL97 EXCEL2000 EXCEL2002 EXCEL2003 |
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 v4 using PROC ACCESS and DBLOAD | EXCEL4 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 SP1 or higher |
| Excel v5 using PROC ACCESS and DBLOAD | EXCEL5 | Yes | Yes | Yes | Yes |
32-bit Windows
64-bit Windows |
8.2 or higher
9.1.3 SP1 or higher |
| Access2000+ using LIBNAME engine |
ACCESS
ACCESS2000 ACCESS2002 ACCESS2003 |
Yes | Yes | Yes | Yes | 32-bit Windows | 9.0 or higher |
| Access97 using LIBNAME engine | ACCESS97 | 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 |
32-bit Windows
64-bit Windows Linux, UNIX Open VMS |
9.1 or higher |
|
|
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.