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.
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.
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)
Have been away from the community for a while. Thanks anyways for the article URL. Will read & revert, if necessary. Thanks again. Appreciate much !!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.