SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Importing Excel 97-2003

Reply
New Contributor
Posts: 2

Importing Excel 97-2003

I'm trying to get a fresh SAS 9.2 install operational, and I need to be able to import Excel 97-2003 spreadsheets. Proc import doesn't work, and it isn't listed as an option in the import wizard. I do, however, get options for Excel 4 and Excel 5 or 95. I have searched around extensively in the SAS knowledge base and using Google.

I am running Windows Server 2003 (x64) and have Office 2007 installed. Thank you.
Esteemed Advisor
Posts: 5,086

Re: Importing Excel 97-2003

Given this table:
http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a003094743.htm
it seems you should be able to import your Excel file using PROC IMPORT and using the source identifier XLS.
If not so, please attach any LOG or messages from your attempts when "Proc import doesn't work", and potentially, you could open a track to SAS tech support.

/Linus
Data never sleeps
New Contributor
Posts: 2

Re: Importing Excel 97-2003

Great, that resolved the issue perfectly. Thanks for your help.
Post a Question
Discussion Stats
  • 2 replies
  • 453 views
  • 0 likes
  • 2 in conversation