04-12-2018 08:52 AM
I'm sure this question is common.
I'm in lesson 7 of the e-course "Programming 1 Essentials" where I am to execute the code:
libname orionx pcfiles path="&path/sales.xls";
ERROR: The SERVER= option is required for establishing a
connection through the SAS/ACCESS Interface to PC Files.
This may mean I don't have the Oracle virtual-box setting correctly?
I do have "Shared Folders" configured for a folder in my Window's 7 PC hard drive - in the virtual-box config.
Can someone point me to the steps I need to perform to ensure I'm able to continue?
04-12-2018 09:34 AM - edited 04-12-2018 09:35 AM
Please read this previous response to the same question:
Bottom line, we knew, in advance, that students using the Univ Edition would not have the correct PC File Server helper files to use the LIBNAME engine. So the Excel files (sales.xls, custfm.xls, etc) were not provided in the course for UE students.
Please note the screen shot in the previous posting. You are explicitly instructed to write the code, but NOT submit the code. You are to compare your code to the solution to see if you understand how the LIBNAME engine for EXCEL works.
04-12-2018 10:21 AM
04-12-2018 12:15 PM