BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
binitp18
Calcite | Level 5

Tried this 

libname orionx pcfiles Path="/folders/myfolders/sales.xls"; - Not working - Getting this error. 

ERROR: The SERVER= option is required for establishing a connection through the SAS/ACCESS Interface to PC Files.
ERROR: Error in the LIBNAME statement
 
 
Tried this (no error message- it actually created library but I cannot see any files in the library. 
libname orionx XLSX "/folders/myfolders/sales.xls";
NOTE: Libref ORIONX was successfully assigned as follows:
Engine: XLSX
Physical Name: /folders/myfolders/sales.xls
 
 
Not sure what to do next? I am on chapter 7  SAS Programming 1: Essentials e-course. 
 
Using SAS Studio. 
1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
Diamond | Level 26

Hi:

  When we wrote the course, we put explicit instructions inside the course, telling the student that they should study the code, but NOT to submit the code. Please review the highlighted section for the practice:

prg1_do_not_submit_code_to_read_Excel_files.png

  There are many configurations that may not have the PCFILE server installed, as we explain. We do not intend for you to run code in Lesson 7, only study the PCFILE server syntax that is illustrated. As you discovered there are differences in the various LIBNAME engines and when you use SAS at different jobs, you will have to learn the method that is used at your company.

 

cynthia

 

View solution in original post

2 REPLIES 2
Cynthia_sas
Diamond | Level 26

Hi:

  When we wrote the course, we put explicit instructions inside the course, telling the student that they should study the code, but NOT to submit the code. Please review the highlighted section for the practice:

prg1_do_not_submit_code_to_read_Excel_files.png

  There are many configurations that may not have the PCFILE server installed, as we explain. We do not intend for you to run code in Lesson 7, only study the PCFILE server syntax that is illustrated. As you discovered there are differences in the various LIBNAME engines and when you use SAS at different jobs, you will have to learn the method that is used at your company.

 

cynthia

 

Reeza
Super User

Doesn't SAS UE allow you to connect now using XLSX engine? 

 

Maybe the dourse can be updated to reflect this @Cynthia_sas

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1871 views
  • 2 likes
  • 3 in conversation