DATA Step, Macro, Functions and more

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

Reply
New Contributor
Posts: 3

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

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

Super User
Posts: 23,662

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

Posted in reply to jcorlette

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


 

New Contributor
Posts: 3

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

Thanks, I will try that.

Ask a Question
Discussion stats
  • 2 replies
  • 74 views
  • 0 likes
  • 2 in conversation