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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.