Usage Note 17075: SAS/ACCESS Interface to PC File Formats support on Windows 64-bit
Platforms
On Windows 64-bit Itanium platform, we support all the same file
formats as on Windows 32-bit such as DBF, WKn, JMP, SPSS, Stata, etc.
The only file formats that aren't supported are the ones that utilize
the MS Jet data provider (Excel 97/2000 and MS Access). Therefore, the
LIBNAME access method, PROC IMPORT/EXPORT, and the Import/Export wizards
can not be used with Excel 97/2000 and MS Access files. Earlier Excel
files such as Excel 4 or Excel 5/95 didn't use the MS Jet engine, and
can still be used with PROC IMPORT/EXPORT. The reason stems from the
fact that the MS Jet provider is 32-bit and Microsoft has no plans
to provide a 64-bit Jet provider version.
Using PC Files server is our solution to MS ACCESS and EXCEL on IA-64
and AMD-64. Although this solution is typically used to import/export
Excel and MS Access files on a Unix platform, the same solution will
work for a 64-bit Windows machine as well. The user would install
SAS/ACCESS Interface for PC File Formats on the 64-bit Windows machine,
and the PC Files Server on the machine where Excel and MS Access are
installed. If Excel and Access are installed on the 64-bit machine, the
PC Files Server can be installed on the same 64-bit PC with SAS 64-bit
as a client.
For related information see SAS Note #016568 and 019381.
When using PC File Server with Excel files, the value for DBMS= option
is excelcs. The syntax for PROC IMPORT would look as follows:
proc import dbms=excelcs
out=work.prices
datafile="D:\Temp\sas.xls" replace;
server="BMFSV5391SASP";
port=11012;
sheet="Plan1";
run;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Usage Note |
Priority: | low |
Date Modified: | 2007-08-17 10:46:02 |
Date Created: | 2006-02-17 10:19:38 |