topic Re: Importing Excel 97-2003 in Microsoft Integration with SAS

Importing Excel 97-2003

PStat — Wed, 19 Aug 2009 23:47:49 GMT

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.

Re: Importing Excel 97-2003

LinusH — Thu, 20 Aug 2009 08:03:32 GMT

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

Re: Importing Excel 97-2003

PStat — Thu, 20 Aug 2009 19:47:24 GMT

Great, that resolved the issue perfectly. Thanks for your help.