This document describes concepts and methods for designating or managing superuser privileges in SAS Cloud Analytic Services (CAS) within the SAS Viya 4 environment. Superusers have extended rights to administer the CAS server, manage sessions, libraries (caslibs) and data, as well as configure a...
This example shows how to join three external tables using the fedSql.execDirect action. It combines a Base SAS dataset named Customers, an SPD Engine dataset named Products, and a Teradata table named Sales. The example explains how to assign caslibs to data sources and how to identify tables in...
This feature allows listing files present in a data source associated with a CAS caslib, displaying detailed information such as permissions, size, and modification date. It is essential for managing and exploring data stored in the CAS environment.
This document explains how to use the `table.loadTable` action to load CSV data compressed in GZ (gzip) format into a CAS in-memory table for fast, distributed analysis. It details the configuration of a caslib and the import options specific to GZ archives and CSV files.
Explains how to make a user-defined SAS format library available to all CAS sessions or promote it for use by other users. In SAS Viya, this often involves creating and managing formats directly within a caslib.
Analyzes effective (net) access to a table or caslib in SAS Viya using the `accessControl.whatIsEffective` action.
This SAS script demonstrates the use of the ODBC data connector in SAS Viya 4 to access column metadata for a CAS table. It configures an ODBC connection via a CASLIB, creates an in-memory table from embedded data (datalines), and then uses the `table.columnInfo` action of PROC CAS to display var...
This SAS script demonstrates how to use the SAS data connector to load data from an external relational database management system (DBMS) into the CAS server. It illustrates creating a temporary table in the external DBMS via a DATA STEP, then using the 'addCaslib' and 'loadtable' actions of PROC...
This feature allows adding a caslib (CAS library) based on a file system path, facilitating access to data stored on a Linux server or similar for distributed in-memory processing by SAS Cloud Analytic Services (CAS).
This feature allows adding a caslib to connect to an Oracle database in SAS Viya 4, making data accessible in memory for CAS processing.