reading excel xlsx

[deleted_user]

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

[Doc_Duke]

You need to upgrade to SAS 9.2 Phase 2.

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

[deleted_user]

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.

[sbb]

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.