topic Re: Error message when importing data from Excel in SAS Visual Analytics

Error message when importing data from Excel

Yiting — Wed, 19 Dec 2018 15:31:32 GMT

Hi,

When I am trying to import an Excel dataset from local disk to SAS VA, I got the error message below... do youo know which SAS component is required for this step?

Thanks.

Best,

Yiting

Re: Error message when importing data from Excel

alexal — Wed, 19 Dec 2018 15:34:41 GMT

@Yiting,

You have to install the following package:

sudo yum -y install sas-cdfbase

Re: Error message when importing data from Excel

Yiting — Wed, 19 Dec 2018 15:39:30 GMT

Thanks! Where or how shall I install these?

Thanks!

@alexal

Re: Error message when importing data from Excel

alexal — Wed, 19 Dec 2018 15:41:58 GMT

@Yiting,

You have to log in to SAS Viya server via SSH and run that command. If you do not know how to do that, please ask your SAS Administrator.

Re: Error message when importing data from Excel

Yiting — Wed, 19 Dec 2018 15:45:47 GMT

Ah, thank you! I dont know how to do that… I dont even know who my SAS Adminstrator is... 😄

Is it a Component that I should have installed when installing SAS but did not install? Can I install it by going back to the installation stage?

Re: Error message when importing data from Excel

alexal — Wed, 19 Dec 2018 15:48:07 GMT

@Yiting,

Correct. That package should be installed during the initial install, but for some reason, it wasn't installed.

Re: Error message when importing data from Excel

Yiting — Wed, 19 Dec 2018 15:49:55 GMT

@alexal

What is its name? I plan to go back to the installation stage to install it... 🙂

Re: Error message when importing data from Excel

alexal — Wed, 19 Dec 2018 15:52:59 GMT

@Yiting,

sas-cdfbase

Re: Error message when importing data from Excel

Yiting — Wed, 19 Dec 2018 15:55:11 GMT

Thanks a lot for help!

Re: Error message when importing data from Excel

Yiting — Thu, 20 Dec 2018 09:12:55 GMT

Hi, I dont find cdfbase… which one should i install here?

Advanced Programming for SAS LASR Analytic Server
BASE Infrastructure to support Hadoop
Base SAS
DataFlux API for Hadoop
Deployment Backup and Recovery Tool Help and Documentation
GfK GeoMarketing CITIES Maps for SAS/GRAPH
GfK GeoMarketing WORLD Maps for SAS/GRAPH
Report Fonts for Clients
SAS Accelerator Publishing Agent for Oracle
SAS Add-in for Microsoft Office
SAS Client Connection Profile Configuration
SAS Configuration Manager
SAS Deployment Tester - Client
SAS Deployment Tester - Server
SAS Deployment Tester Plug-in for SAS Management Console
SAS Diagram Control
SAS Drivers for JDBC
SAS Drivers for ODBC
SAS Enterprise Guide
SAS Environment Manager
SAS Environment Manager Agent
SAS Environment Manager Library Module
SAS Environment Manager Mid-Tier
SAS Environment Manager Server Module
SAS Environment Manager User Module
SAS Flex Application Themes
SAS Flex Application Themes Help and Documentation
SAS Foundation Services
SAS Help Viewer for the Web
SAS High-Performance Server
SAS High-Performance Statistics Server Components
SAS Hive SerDe for SPDE Data
SAS Home
SAS Information Retrieval Studio for SAS
SAS Integration Technologies
SAS Integration Technologies Client
SAS Intelligence Platform Object Framework
SAS LASR Analytic Server
SAS LASR Analytic Server Access Tools
SAS Management Console
SAS ODS Graphics Designer
SAS ODS Graphics Editor
SAS PC Files Server
SAS Package Reader
SAS Personal Login Manager
SAS Providers for OLE DB
SAS Remote Browser Server
SAS Scalable Performance Data Client
SAS Scalable Performance Data Server Plug-in for SAS Management Console
SAS Shared Services
SAS Staging Utility Mid Tier
SAS Staging Utility Server Tier
SAS Studio Basic
SAS Studio Mid-Tier
SAS Threaded Kernel Extensions for Data Mining
SAS Threaded Kernel Extensions for SAS Text Analytics
SAS Universal Viewer
SAS Visual Analytics Administrator
SAS Visual Analytics Configuration Data
SAS Visual Analytics Designer
SAS Visual Analytics Explorer
SAS Visual Analytics Explorer Configuration Data
SAS Visual Analytics Explorer Logical Types
SAS Visual Analytics Extensions for Services
SAS Visual Analytics Graph Builder
SAS Visual Analytics Graph Builder Configuration Data
SAS Visual Analytics Graph Builder Logical Types
SAS Visual Analytics High-Performance Configuration
SAS Visual Analytics Logical Types
SAS Visual Analytics Print Service
SAS Visual Analytics Report Viewer
SAS Visual Analytics Server Components
SAS Visual Analytics Services
SAS Visual Data Builder
SAS Visual Data Builder Configuration Data
SAS Visual Data Builder Logical Types
SAS Visual Data Builder Macros
SAS Web Application Server
SAS Web Application Themes
SAS Web Infrastructure Platform
SAS Web Infrastructure Platform Data Server
SAS Web Infrastructure Platform Help and Documentation
SAS Web Infrastructure Platform Scheduling Services
SAS Web Parts Service for Microsoft SharePoint
SAS Web Parts for Microsoft SharePoint
SAS Web Server
SAS Workflow Studio
SAS XML Mapper
SAS/ACCESS Interface Products Samples
SAS/ACCESS Interface to ODBC
SAS/ACCESS Interface to Oracle
SAS/ACCESS Interface to PC Files
SAS/GRAPH
SAS/GRAPH ActiveX Control
SAS/GRAPH Java Applets for Web Servers
SAS/GRAPH Obsolete Maps Data
SAS/SECURE Client Components
SAS/SECURE Toolkit Libraries from RSA (R)
SAS/STAT
SAS/Secure SSL
Search Interface to SAS Content
Standalone Formats

Re: Error message when importing data from Excel

alexal — Thu, 20 Dec 2018 12:01:10 GMT

@Yiting,

That list is from SAS 9.4. Your screenshot is from SAS Viya. The following command could help you find a package on SAS Viya server:

sudo yum search cdfbase

Re: Error message when importing data from Excel

Yiting — Thu, 20 Dec 2018 14:34:43 GMT

Thanks, where shall i run it?

Re: Error message when importing data from Excel

alexal — Thu, 20 Dec 2018 14:38:52 GMT

@Yiting,

In a command line. Who did install SAS Viya for you?

Re: Error message when importing data from Excel

Yiting — Thu, 20 Dec 2018 15:06:48 GMT

sudo is not recognized as internal or external command...

I did not install SAS VA, i used it web-based...

Re: Error message when importing data from Excel

alexal — Thu, 20 Dec 2018 15:14:00 GMT

@Yiting,

You need to find out who installed and manages your SAS Viya server. They can help you with package installation.