Re: reading excel xlsx

deleted_user · Posted 07-31-2009 02:07 PM

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 · Posted 07-31-2009 02:53 PM

You need to upgrade to SAS 9.2 Phase 2.

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

deleted_user · Posted 07-31-2009 03:37 PM

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 · Posted 07-31-2009 04:07 PM

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.

reading excel xlsx