Desktop productivity for business analysts and programmers

reading excel xlsx

Reply
N/A
Posts: 0

reading excel xlsx

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
Trusted Advisor
Posts: 2,114

Re: reading excel xlsx

You need to upgrade to SAS 9.2 Phase 2.

http://support.sas.com/kb/32/455.html
N/A
Posts: 0

Re: reading excel xlsx

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: reading excel xlsx

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.
Ask a Question
Discussion stats
  • 3 replies
  • 137 views
  • 0 likes
  • 3 in conversation