This feature allows creating a copy of an existing table loaded into memory within a SAS Cloud Analytic Services (CAS) environment. The copy can be made within the same caslib (CAS library) or to another caslib, with options to specify the new table's name, replacement, and other properties.
This example groups the CreditQualify table by State variables and State FIPS codes, then uses Credit_Score as a weighting variable. The resulting group-by table is saved as ScorePerState.sashdat in the active caslib for later use.
This SAS script demonstrates how to load a CSV file from a CAS caslib and apply SAS informats to correctly interpret data types, including dates and formatted numeric values (such as commas or percentages).
The PC Files Data Connector allows SAS Cloud Analytic Services (CAS) to access data stored in common PC file formats, such as Microsoft Excel spreadsheets or Microsoft Access databases. It facilitates loading and unloading data between the client's file system or a caslib and in-memory CAS tables.
The CASUTIL procedure provides management functions for caslibs and tables in SAS Cloud Analytic Services (CAS). It allows viewing table metadata, deleting files, unloading tables, listing tables, loading tables, promoting tables to global scope, and saving tables to a data source.
This feature allows you to remove all direct access controls applied to a CAS table, thus reverting it to inherit its permissions from the parent caslib. It does not affect column-level access controls.
This example shows how to use the 'save' action and the 'exportOptions' parameter to save an in-memory table as a SAS data set to a caslib. The code sets the active caslib to 'CASUSER' because this personal caslib is file-system based.
This example illustrates how to use the CONNECTION TO component of the FROM clause of a FedSQL SELECT statement to select data, allowing explicit pass-through of database-specific SQL queries to an external data source (here simulated by Teradata) via a caslib.
The CASUTIL procedure offers several table and caslib management functions, including displaying table metadata, deleting files, unloading and loading tables, promoting tables, and saving tables.
cas sessopts=(metrics=true); caslib _all_ assign;