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:)
... View more