Hello,
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";
System response:
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?
Thanks
Duane
Hi:
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.
Cynthia
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.