topic Re: Trying to use either pcfiles or excel engines to access an Excel workbook in SAS Programming

Trying to use either pcfiles or excel engines to access an Excel workbook

jcorlette — Tue, 26 Jun 2018 18:05:59 GMT

Working through SAS VLE course Programming 1: Essentials, Lesson 7 Reading Spreadsheet and Database Data. I am working with SAS Base for Windows (NOT accessing remotely with either EG or SAS University). I tried running the code with both “pcfiles” and “excel” and get the messages below. I could be mistaken in using pcfiles as I want to access an Excel file, but was trying to follow along with the exercise. My license list is below, do I even have the necessary engines to run either of these?

Any help is appreciated.

libname orionx pcfiles path="&path/sales.xls";

ERROR: Unable to locate pcfserver.exe. Please install PC Files Server.

ERROR: Error in the LIBNAME statement.

libname custfm excel path="&path/custfm.xls";

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

I ran proc setinit to find what I have within my license and I see this:

Operating System: WX64_WKS. (MICROSOFT version used is 32-bit)

---Base SAS Software

---SAS/STAT

---SAS/GRAPH

---SAS/ETS

---SAS/FSP

---SAS/OR

---SAS/AF

---SAS/IML

---SAS/QC

---SAS/SHARE

---SAS/ASSIST

---SAS/CONNECT

---SAS/EIS

---SAS/GIS

---SAS/SHARE*NET

---SAS Enterprise Miner

---SAS/IntrNet

---MDDB Server common products

---SAS Integration Technologies

---SAS/Secure 168-bit

---SAS/Secure Windows

---SAS Text Miner

---SAS/Genetics

---SAS Enterprise Guide

---SAS Bridge for ESRI

---OR OPT

---OR PRS

---OR IVS

---OR LSO

---SAS/ACCESS Interface to DB2

---SAS/ACCESS Interface to Oracle

---SAS/ACCESS Interface to SAP ASE

---SAS/ACCESS Interface to PC Files

---SAS/ACCESS Interface to ODBC

---SAS/ACCESS Interface to OLE DB

---SAS/ACCESS Interface to Teradata

---SAS/ACCESS Interface to Microsoft SQL Server

---SAS/ACCESS Interface to MySQL

---Text Miner for French

---SAS Enterprise Miner for Desktop

---SAS/IML Studio

---SAS Workspace Server for Local Access

---SAS/ACCESS Interface to Netezza

---SAS/ACCESS Interface to Aster nCluster

---SAS/ACCESS Interface to Greenplum

---SAS/ACCESS Interface to SAP IQ

---SAS/ACCESS to Hadoop

---SAS/ACCESS to Vertica

---SAS/ACCESS to Postgres

---SAS/ACCESS to Impala

---SAS/ACCESS to HAWQ

---SAS/ACCESS to Amazon Redshift

---High Performance Suite

---SAS Add-in for Microsoft Excel

---SAS/ACCESS to SAP HANA

---SAS/ACCESS Interface to the PI System

Re: Trying to use either pcfiles or excel engines to access an Excel workbook

Reeza — Tue, 26 Jun 2018 20:06:07 GMT

Go to Windows, click on SAS, click on PC Files Server and make sure it’s running.

If it’s not running you won’t be able to access the file.

Another option is to try the Excel libname.

@jcorlette wrote:

Working through SAS VLE course Programming 1: Essentials, Lesson 7 Reading Spreadsheet and Database Data. I am working with SAS Base for Windows (NOT accessing remotely with either EG or SAS University). I tried running the code with both “pcfiles” and “excel” and get the messages below. I could be mistaken in using pcfiles as I want to access an Excel file, but was trying to follow along with the exercise. My license list is below, do I even have the necessary engines to run either of these?

Any help is appreciated.

libname orionx pcfiles path="&path/sales.xls";

ERROR: Unable to locate pcfserver.exe. Please install PC Files Server.

ERROR: Error in the LIBNAME statement.

libname custfm excel path="&path/custfm.xls";

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

I ran proc setinit to find what I have within my license and I see this:

Operating System: WX64_WKS. (MICROSOFT version used is 32-bit)

---Base SAS Software

---SAS/STAT

---SAS/GRAPH

---SAS/ETS

---SAS/FSP

---SAS/OR

---SAS/AF

---SAS/IML

---SAS/QC

---SAS/SHARE

---SAS/ASSIST

---SAS/CONNECT

---SAS/EIS

---SAS/GIS

---SAS/SHARE*NET

---SAS Enterprise Miner

---SAS/IntrNet

---MDDB Server common products

---SAS Integration Technologies

---SAS/Secure 168-bit

---SAS/Secure Windows

---SAS Text Miner

---SAS/Genetics

---SAS Enterprise Guide

---SAS Bridge for ESRI

---OR OPT

---OR PRS

---OR IVS

---OR LSO

---SAS/ACCESS Interface to DB2

---SAS/ACCESS Interface to Oracle

---SAS/ACCESS Interface to SAP ASE

---SAS/ACCESS Interface to PC Files

---SAS/ACCESS Interface to ODBC

---SAS/ACCESS Interface to OLE DB

---SAS/ACCESS Interface to Teradata

---SAS/ACCESS Interface to Microsoft SQL Server

---SAS/ACCESS Interface to MySQL

---Text Miner for French

---SAS Enterprise Miner for Desktop

---SAS/IML Studio

---SAS Workspace Server for Local Access

---SAS/ACCESS Interface to Netezza

---SAS/ACCESS Interface to Aster nCluster

---SAS/ACCESS Interface to Greenplum

---SAS/ACCESS Interface to SAP IQ

---SAS/ACCESS to Hadoop

---SAS/ACCESS to Vertica

---SAS/ACCESS to Postgres

---SAS/ACCESS to Impala

---SAS/ACCESS to HAWQ

---SAS/ACCESS to Amazon Redshift

---High Performance Suite

---SAS Add-in for Microsoft Excel

---SAS/ACCESS to SAP HANA

---SAS/ACCESS Interface to the PI System

Re: Trying to use either pcfiles or excel engines to access an Excel workbook

jcorlette — Sat, 30 Jun 2018 00:39:47 GMT

Thanks, I will try that.