Error message when importing data from Excel

[Yiting]

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

[alexal]

@Yiting,

You have to install the following package:

sudo yum -y install sas-cdfbase

[Yiting]

Thanks! Where or how shall I install these?

Thanks!

@alexal

[alexal]

@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.

[Yiting]

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?

[alexal]

@Yiting,

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

[Yiting]

@alexal

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

[alexal]

@Yiting,

sas-cdfbase

[Yiting]

Thanks a lot for help!

[Yiting]

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

1. Advanced Programming for SAS LASR Analytic Server
2. BASE Infrastructure to support Hadoop
3. Base SAS
4. DataFlux API for Hadoop
5. Deployment Backup and Recovery Tool Help and Documentation
6. GfK GeoMarketing CITIES Maps for SAS/GRAPH
7. GfK GeoMarketing WORLD Maps for SAS/GRAPH
8. Report Fonts for Clients
9. SAS Accelerator Publishing Agent for Oracle
10. SAS Add-in for Microsoft Office
11. SAS Client Connection Profile Configuration
12. SAS Configuration Manager
13. SAS Deployment Tester - Client
14. SAS Deployment Tester - Server
15. SAS Deployment Tester Plug-in for SAS Management Console
16. SAS Diagram Control
17. SAS Drivers for JDBC
18. SAS Drivers for ODBC
19. SAS Enterprise Guide
20. SAS Environment Manager
21. SAS Environment Manager Agent
22. SAS Environment Manager Library Module
23. SAS Environment Manager Mid-Tier
24. SAS Environment Manager Server Module
25. SAS Environment Manager User Module
26. SAS Flex Application Themes
27. SAS Flex Application Themes Help and Documentation
28. SAS Foundation Services
29. SAS Help Viewer for the Web
30. SAS High-Performance Server
31. SAS High-Performance Statistics Server Components
32. SAS Hive SerDe for SPDE Data
33. SAS Home
34. SAS Information Retrieval Studio for SAS
35. SAS Integration Technologies
36. SAS Integration Technologies Client
37. SAS Intelligence Platform Object Framework
38. SAS LASR Analytic Server
39. SAS LASR Analytic Server Access Tools
40. SAS Management Console
41. SAS ODS Graphics Designer
42. SAS ODS Graphics Editor
43. SAS PC Files Server
44. SAS Package Reader
45. SAS Personal Login Manager
46. SAS Providers for OLE DB
47. SAS Remote Browser Server
48. SAS Scalable Performance Data Client
49. SAS Scalable Performance Data Server Plug-in for SAS Management Console
50. SAS Shared Services
51. SAS Staging Utility Mid Tier
52. SAS Staging Utility Server Tier
53. SAS Studio Basic
54. SAS Studio Mid-Tier
55. SAS Threaded Kernel Extensions for Data Mining
56. SAS Threaded Kernel Extensions for SAS Text Analytics
57. SAS Universal Viewer
58. SAS Visual Analytics Administrator
59. SAS Visual Analytics Configuration Data
60. SAS Visual Analytics Designer
61. SAS Visual Analytics Explorer
62. SAS Visual Analytics Explorer Configuration Data
63. SAS Visual Analytics Explorer Logical Types
64. SAS Visual Analytics Extensions for Services
65. SAS Visual Analytics Graph Builder
66. SAS Visual Analytics Graph Builder Configuration Data
67. SAS Visual Analytics Graph Builder Logical Types
68. SAS Visual Analytics High-Performance Configuration
69. SAS Visual Analytics Logical Types
70. SAS Visual Analytics Print Service
71. SAS Visual Analytics Report Viewer
72. SAS Visual Analytics Server Components
73. SAS Visual Analytics Services
74. SAS Visual Data Builder
75. SAS Visual Data Builder Configuration Data
76. SAS Visual Data Builder Logical Types
77. SAS Visual Data Builder Macros
78. SAS Web Application Server
79. SAS Web Application Themes
80. SAS Web Infrastructure Platform
81. SAS Web Infrastructure Platform Data Server
82. SAS Web Infrastructure Platform Help and Documentation
83. SAS Web Infrastructure Platform Scheduling Services
84. SAS Web Parts Service for Microsoft SharePoint
85. SAS Web Parts for Microsoft SharePoint
86. SAS Web Server
87. SAS Workflow Studio
88. SAS XML Mapper
89. SAS/ACCESS Interface Products Samples
90. SAS/ACCESS Interface to ODBC
91. SAS/ACCESS Interface to Oracle
92. SAS/ACCESS Interface to PC Files
93. SAS/GRAPH
94. SAS/GRAPH ActiveX Control
95. SAS/GRAPH Java Applets for Web Servers
96. SAS/GRAPH Obsolete Maps Data
97. SAS/SECURE Client Components
98. SAS/SECURE Toolkit Libraries from RSA (R)
99. SAS/STAT
100. SAS/Secure SSL
101. Search Interface to SAS Content
102. Standalone Formats

[alexal]

@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

[Yiting]

Thanks, where shall i run it?

[alexal]

@Yiting,

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

[Yiting]

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

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

[alexal]

@Yiting,

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