topic Re: Libname error using PCFILES engine for Access in SAS Studio

Libname error using PCFILES engine for Access

San_0611 — Wed, 22 Aug 2018 17:28:48 GMT

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:)

Re: Libname error using PCFILES engine for Access

Kurt_Bremser — Wed, 22 Aug 2018 18:19:54 GMT

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

Re: Libname error using PCFILES engine for Access

SuryaKiran — Wed, 22 Aug 2018 18:40:48 GMT

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;