Attention : This code requires administrator privileges.
The CASUTIL procedure is an essential tool for data management in the SAS© Cloud Analytic Services (CAS) environment. It allows users to interact directly with caslibs and CAS tables for operations such as displaying table details, deleting data from a source, unloading tables from caslibs, listing available tables, loading new data into caslibs, promoting tables to global scope to make them accessible to other sessions, and saving CAS tables to external data sources. The provided example illustrates loading a CSV file into a CAS caslib.
Data Analysis
Type : CREATION_INTERNE
The example shows how to load a local CSV file ('County_Population.csv') into a CAS caslib, thereby creating a CAS table from external data. The IMPORTOPTIONS=(filetype="csv" getnames="true") option is used to specify the file type and ensure that column names are imported correctly. Access to the data source is managed via a DNFS (Distributed Network File System) type caslib.
1 Code Block
PROC CASUTIL Data
Explanation :
This SAS code illustrates the process of loading a CSV file into SAS Cloud Analytic Services (CAS). The first step is to define a caslib named 'csvfiles' of type DNFS, specifying the path to the CSV files. This allows CAS to access the data stored in this directory. Then, the PROC CASUTIL procedure is used to list the available files in this caslib (list files). The 'load' command is then employed to load the 'County_Population.csv' file into CAS. The 'importoptions=(filetype="csv" getnames="true")' option indicates that the file is in CSV format and that the first row contains the variable names. The resulting CAS table will be named 'county_population'. Finally, 'list tables' displays the CAS tables currently loaded in the caslib.
This SAS code illustrates the process of loading a CSV file into SAS Cloud Analytic Services (CAS). The first step is to define a caslib named 'csvfiles' of type DNFS, specifying the path to the CSV files. This allows CAS to access the data stored in this directory. Then, the PROC CASUTIL procedure is used to list the available files in this caslib (list files). The 'load' command is then employed to load the 'County_Population.csv' file into CAS. The 'importoptions=(filetype="csv" getnames="true")' option indicates that the file is in CSV format and that the first row contains the variable names. The resulting CAS table will be named 'county_population'. Finally, 'list tables' displays the CAS tables currently loaded in the caslib.
Copied!
| 1 | caslib csvfiles task=add type=dnfs |
| 2 | path="/data/csv/" |
| 3 | desc="Spreadsheets and CSV source data."; |
| 4 | |
| 5 | PROC CASUTIL; |
| 6 | list files; |
| 7 | |
| 8 | load casdata="County_Population.csv" |
| 9 | importoptions=(filetype="csv" getnames="true") |
| 10 | casout="county_population"; |
| 11 | |
| 12 | list tables; |
| 13 | QUIT; |
This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.
Copyright Info : Copyright © SAS Institute Inc. All Rights Reserved.
Expert Advice
Michael
Responsable de l'infrastructure Viya.
« In the SAS Viya ecosystem, PROC CASUTIL serves as the primary "utility knife" for managing data between your persistent storage (physical files) and the CAS in-memory environment. Unlike standard Base SAS procedures, CASUTIL is specifically optimized to handle the distributed nature of Cloud Analytic Services, ensuring that data is loaded and managed across all worker nodes efficiently. »