12-09-2015 12:40 PM
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.
12-09-2015 12:47 PM
12-10-2015 08:24 AM
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.
12-10-2015 12:17 PM
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)
12-10-2015 12:23 PM