Re: SAS 9.4 excel option - SAS Support Communities

Quartz | Level 8

Quartz | Level 8

SAS 9.4 excel option

Posted 09-09-2014 01:36 PM (1083 views)

Hi!

Is "EXCEL" not a DBMS option in SAS 9.4 proc import/export anymore? Is it that only XLS, XLSX, CSV, etc are valid now?

Should I clarify?

Thanks!

2 REPLIES 2

Obsidian | Level 7

Obsidian | Level 7

Re: SAS 9.4 excel option

Posted 09-09-2014 01:42 PM (1040 views) | In reply to Maisha_Huq

As per the documentation below, the option 'EXCEL' exists for sas 9.4

SAS/ACCESS(R) 9.4 Interface to PC Files: Reference, Third Edition

Can you share your code?

Super User

Super User

Re: SAS 9.4 excel option

Posted 09-09-2014 01:54 PM (1040 views) | In reply to Maisha_Huq

Its valid, if you're having issues post the code/issues. My guess is that there's a 64bit/32bit incompatibility.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!