topic Re: reading excel xlsx in SAS Enterprise Guide

reading excel xlsx

deleted_user — Fri, 31 Jul 2009 18:07:56 GMT

With the new version of excel SAS nolonger seems to be able to read spreadsheets. Any suggestions on how to import an excel xlsx spreadsheet?

ODBC is currently broken and until IT can install updates to get it working again import does not know about xlsx format. I am not looking forward to saving all the spreadsheets as xls

Re: reading excel xlsx

Doc_Duke — Fri, 31 Jul 2009 18:53:15 GMT

You need to upgrade to SAS 9.2 Phase 2.

http://support.sas.com/kb/32/455.html

Re: reading excel xlsx

deleted_user — Fri, 31 Jul 2009 19:37:37 GMT

Supposedly that is included in the upgrades but everyone at SAS tech support seems to be on vacation. Our IT has called every day on this and other issues and we are still waiting (2 weeks so far).

I need a solution in the interim. While I'm waiting for SAS to help the IT administrator do the upgrade.

Re: reading excel xlsx

sbb — Fri, 31 Jul 2009 20:07:35 GMT

As the referernced document suggests, you can convert your xlsx file to xls using Excel FILE SAVE_AS option. This would be one of a few options that are documented for your review in the SAS technical note.

Scott Barry
SBBWorks, Inc.