SAS 9.4 excel option

Reply
Frequent Contributor
Posts: 131

SAS 9.4 excel option

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!

Regular Contributor
Posts: 233

Re: SAS 9.4 excel option

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

Capture.JPG

Can you share your code?

Super User
Posts: 19,059

Re: SAS 9.4 excel option

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

Ask a Question
Discussion stats
  • 2 replies
  • 239 views
  • 0 likes
  • 3 in conversation