Libname error using PCFILES engine for Access

[San_0611]

Hi there  .

I am  using SAS University  Edition  and  trying to  access excel workbook products.xlsx using  excel and  pcfiles  engines.

I am  using  Excel 2013  with 64 bit  and SAS University  edition  with 64 bit  on my personal  computer.

The  path I  am  using is  "path=/folders/myfolders/products.xlsx;

The  code  is  as  follows ,

options  validvarname=V7;

libname  prod pcfiles path="&path\products.xlsx";

proc contents data= prod._all_;
run;

I am  getting  the  following  errors,

         libname  prod pcfiles path="&path\products.xlsx";
 ERROR: The SERVER= option is required for establishing a connection through the SAS/ACCESS Interface to PC Files.
 ERROR: Error in the LIBNAME statement.
        
         proc contents data= prod._all_;
         run;
 
 ERROR: Libref PROD is not assigned.
 NOTE: Statements not processed because of errors noted above.

 I  am not  getting  why  this  error comes  there  when I  try to use  excel  and  pcfiles  engines . Please help 

Thanks  in advance ,

Sanika:)

[Kurt_Bremser]

UE does not support the PCFiles server. See https://communities.sas.com/t5/SAS-Programming/pcfiles-serverr-with-SAS-University-Edition/td-p/2440...

[SuryaKiran]

Did you check XLSX libname engine.

/* because Excel field names often have spaces */
options validvarname=any;
 
libname xl XLSX '/folders/myfolders/sas_tech_talks_15.xlsx';
 
/* discover member (DATA) names */
proc datasets lib=xl; quit;
 
libname xl CLEAR;