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

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) ... View more

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. ... View more