• Print |
• E-mail  |
• Bookmark

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