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:)
UE does not support the PCFiles server. See https://communities.sas.com/t5/SAS-Programming/pcfiles-serverr-with-SAS-University-Edition/td-p/2440...
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;
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.