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
