If you are running SAS Windows 8.x and have SAS/Access for PC Formats then
you can use Proc Import to read Excel 97/2000 files. Unfortunately for me,
my company strangely decided not to renew my license for SAS/Access for PC
Formats. Now I have to use DDE or import CSV files.
From: Terry Fudin [mailto:t.fudin@GENAISSANCE.COM]
Sent: Friday, January 12, 2001 8:50 AM
Subject: PROC ACCESS for Excel 2000 Files
In SAS Version 6.12 one could NOT use PROC ACCESS to read Excel Windows 97
and Windows 2000 files. Is this still true in Versopn 8.1? I don't want to
use the Import/Export Facility but I want to use my SAS program to read and
convert the EXCEL 2000 files to a SAS dataset. Does anybody know what the
best way to accomplish this in a SAS program is, and can you give me an
SAS Consultant to Genaissance, Inc.