LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2001, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 12 Jan 2001 09:05:00 -0800
Reply-To:   "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Subject:   Re: PROC ACCESS for Excel 2000 Files
Comments:   To: Terry Fudin <t.fudin@GENAISSANCE.COM>
Content-Type:   text/plain; charset="iso-8859-1"

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.

-----Original Message----- From: Terry Fudin [mailto:t.fudin@GENAISSANCE.COM] Sent: Friday, January 12, 2001 8:50 AM To: SAS-L@LISTSERV.UGA.EDU 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 example?

Thank you!

Terry Fudin Cyberlytical, LLC SAS Consultant to Genaissance, Inc.

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu