topic Re: Excel Engine Not Found on SAS UE in SAS Programming

Excel Engine Not Found on SAS UE

vs213gm — Wed, 09 Dec 2015 17:40:38 GMT

I saw another post on this subject, but couldn't obtain solution for my trouble. I am using SAS Univ Edition (Linux version), installed on Oracle VirtualBox, which is installed atop Mac OS X 10.10 (Yosemite). Can you please help?

PS: My Excel workbook has 2 worksheets.

Re: Excel Engine Not Found on SAS UE

Reeza — Wed, 09 Dec 2015 17:47:43 GMT

Your question isn't clear. What are you trying to do that you can't do?

Import an Excel sheet? Use proc import with DBMS = XLSX. You can find the code for proc import in the snippets section.

Re: Excel Engine Not Found on SAS UE

vs213gm — Thu, 10 Dec 2015 13:24:22 GMT

While trying to assign a libref using either the Excel or the PCFILES PATH option, I encounter the error stated on my post title, i.e. "Excel Engine Not Found on SAS UE"

The other things I mentioned in my post were details. I'm using SAS Univ Edition, which is running on Oracle Virtual Box on Ubuntu, installed on Mac OS X 10.10.

And while I am not sure if I need to mention this too, I'm running SAS Studio on Firefox 42.0.

Kindly let me know if the above info suffices.

If so, please let me know how to assign & use a Excel file, which contains two worksheets (let us for this post's sake name the 2 sheets as Abc & Xyz). Thanks.

Re: Excel Engine Not Found on SAS UE

Reeza — Thu, 10 Dec 2015 15:24:06 GMT

Libname methods aren't supported on Unix, and because the VM is on Unix you can't use the libname method. You need to use proc import.

Re: Excel Engine Not Found on SAS UE

vs213gm — Thu, 10 Dec 2015 17:17:39 GMT

Ok, I think I need to first of all apologize, as I think I am being quite unclear & incoherent in the way i am expressing myself.

So let me may be reiterate by saying that I am using SAS Studio on a browser (Firefox, as I mentioned in the last post), which is running on Mac. It is the SAS engine that's running on a VM on Linux.

This clarification is important as I do not have a problem with using the LIBNAME statement per se (for regular folders). I am struggling only when I use the LIBNAME for Excel file.

Plus, I have used a script given to me in this community, which uses PROC IMPORT to convert xls/xlsx files to SAS Data Files.

With that being said, can someone help me to assign a LIBREF to an Excel File (before it's converted to a SAS Data File)

Re: Excel Engine Not Found on SAS UE

Reeza — Thu, 10 Dec 2015 17:23:41 GMT

You can't do what you want to do.
You cannot assign a LIBNAME to an Excel file using SAS Studio running SAS University Edition.

See the post from Cynthia Zender here:
https://communities.sas.com/t5/SAS-Procedures/Excel-and-Lib-statement-on-demand-Excel-Engine/m-p/217831/highlight/true#M53596

Re: Excel Engine Not Found on SAS UE

vs213gm — Wed, 30 Dec 2015 05:59:12 GMT

Have been away from the community for a while. Thanks anyways for the article URL. Will read & revert, if necessary. Thanks again. Appreciate much !!