Bibliothèque de Codes SAS | CAS Only

26 Codes trouvés CAS Only VIYA Only

Réinitialiser

ETL

Stop Struggling with Data Ingestion: Efficiently Move CSVs to Memory with PROC CASUTIL

The CASUTIL procedure offers several table and caslib management functions, including displaying table metadata, dele...

View code

Tools

From SAS 9 to Viya: The Ultimate Guide to Migrating User-Defined Formats to CAS

In the SAS Viya platform, you can store user-defined formats in catalogs for use in a SAS session, or you can store t...

View code

Data Manipulation

Beyond the Basics: Using PARTITION and ALTERTABLE to Reshape CAS Data

This example uses three PROC CASUTIL statements to load, partition, and modify a data table in the SAS Cloud Analytic...

View code

Data Management

Fixed vs. Variable: Why You Should Start Using VARCHAR in SAS Viya

This document describes the data types supported by the SAS Viya Platform CAS server, including CHARACTER, NUMERIC, I...

View code

Data Analysis

Beyond PROC FREQ: Generating High-Performance Frequency Tables with SAS Viya Actions

This document explains how to create a frequency table and count the number of people qualified for credit using a DA...

View code

Data Analysis

High-Speed Aggregation: How to Filter and Group Data Instantly with SAS Viya

This example illustrates how to create a grouped table in SAS Viya using CAS's simple.groupBy action. It groups data ...

View code

Reporting

SAS Viya to Excel: Automating Professional Reports with ODS EXCEL and CAS

This SAS script demonstrates how to generate Excel files (XLSX format) from SAS procedure results, using the ODS EXCE...

View code

Général

Mastering table.tableInfo: How to Search, Filter, and Manage CAS Tables Like a Pro

Displays detailed information about a CAS table, including metadata such as structure, number of rows, and other prop...

View code

Data Management

Is Your CAS Table Too Big? How to Audit Memory Usage with tableDetails

The 'tableDetails' CAS action allows obtaining detailed information about a table loaded in memory on a CAS server. T...

View code

FedSQL

Bypass the Parser: How to Run Native Database SQL Directly in SAS Viya

This example illustrates how to use the CONNECTION TO component of the FROM clause of a FedSQL SELECT statement to se...

View code

ETL

From Raw CSV to Formatted Table: The Efficient Way to Load Local Data to CAS

This SAS script demonstrates how to upload a local CSV file to a CAS (Cloud Analytic Services) server and apply custo...

View code

ETL

Forget PROC IMPORT: The Fast Way to Upload Local CSVs to SAS Cloud

This script illustrates how to download and load a CSV file located on an external HTTP server into SAS Cloud Analyti...

View code

ETL

From Memory to Disk: The Complete Guide to Saving CAS Tables as SAS7BDAT

This example shows how to use the 'save' action and the 'exportOptions' parameter to save an in-memory table as a SAS...

View code

ETL

From CSV to Memory: A Quick Start Guide to Loading Data with PROC CASUTIL

The CASUTIL procedure provides management functions for caslibs and tables in SAS Cloud Analytic Services (CAS). It a...

View code

ETL

SAS Viya Data Loading: How to Read CSVs and Manage In-Memory CAS Tables

This document provides SAS code examples for interacting with CAS (Cloud Analytic Services) tables. It shows how to l...

View code

ETL

High-Performance Aggregation in SAS Viya: Mastering CAS GroupBy Actions

This example groups the CreditQualify table by State variables and State FIPS codes, then uses Credit_Score as a weig...

View code

ETL

High-Speed Feature Engineering: Mastering the CAS DATA Step in SAS Viya

This example shows how to use the DATA step to create new variables and conditionally filter data. It uses LENGTH and...

View code

Statistical

Weighted Data Analysis: How to Calculate Qualification Rates in SAS CA

This example demonstrates how to use an IF-THEN statement to count credit-qualified individuals, and then how to crea...

View code

Data Manipulation

Mastering SAS CAS: How to Dynamically Alter Table Labels and Formats with PROC CAS

This example applies labels and formats to columns of a CAS table using the ALTERTABLE action, then displays the form...

View code

Statistics

Processing Millions of Rows with SAS PROC ASSESS

This documentation explains how to use the ASSESS procedure to evaluate the performance of binary classification mode...

View code

Data Manipulation

Scalable Data Pipelines: Appending CAS Tables without Full Reloads via PROC CAS

This action allows you to append the rows of a source table to the end of an existing target table in a SAS Cloud Ana...

View code

Data Manipulation

Smart Partitioning: How to Filter and Append Large-Scale CAS Tables in One Step

This feature allows adding rows from a source table to an existing target table in CAS, using the 'WHERE' parameter t...

View code

Data Access

Streamline Your Data Pipeline: How to Create Global Oracle Caslibs for Distributed Analytics

This feature allows adding a caslib to connect to an Oracle database in SAS Viya 4, making data accessible in memory ...

View code

Data Access

Beyond the Work Library: Mounting Server Directories in CAS using table.addCaslib

This feature allows adding a caslib (CAS library) based on a file system path, facilitating access to data stored on ...

View code

Development

Unlock SAS Viya Flexibility: The Pro Way to Generate and Run Dynamic Code on the Fly

The SOURCE statement in PROC CAS allows you to embed text or SAS/CASL code directly into a CASL program and assign it...

View code

Development

Mastering SAS Viya Syntax: How to Use Parameter Coercion for Cleaner CASL Code

Explains the concept of parameter coercion in CASL, a feature that simplifies code writing by allowing the omission o...

View code

Derniers codes ajoutés

Boost Performance & Security: Creating Composite Indexes and Passwords with PROC DATASETS This example illustrates the modification of two SAS data sets using the MODIFY statement and its sub-statements. It shows how to: modify SAS files, label a SAS data set, add a read password to a SAS data set, indicate the current sort order of a SAS data set, create an index for a SAS data set, assign informats and formats to variables, rename variables, and label variables in a SAS data set.	ETL
SAS Data Step Efficiency: When to Use Explicit OUTPUT vs. Implicit Rules Writes the current observation to a SAS dataset.	Data Manipulation CAS
Stop Struggling with Data Ingestion: Efficiently Move CSVs to Memory with PROC CASUTIL 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.	ETL CAS
Beyond the WORK Library: Mastering the 4 Default SAS Libraries You Must Know This document describes the default SAS libraries: Work (temporary), User (user), Sashelp, and Sasuser. It explains their role and behavior within the SAS Viya 4 environment.	Data Access
Seamless Integration: How to Attach Data Step Outputs Directly to SAS Viya Jobs The SAS Viya Platform File Service allows storing, retrieving, and deleting files kept in the SAS Infrastructure Data Server database repository. This repository is not considered a complete 'file system' but contains individual files directly accessible by their file identifier (UUID).	Administration
From SAS 9 to Viya: The Ultimate Guide to Migrating User-Defined Formats to CAS In the SAS Viya platform, you can store user-defined formats in catalogs for use in a SAS session, or you can store them in a format library on the CAS server. Format libraries are associated with a CAS session, or they can be promoted to global scope to be available to all CAS sessions. User-defined formats in a format library are server-side formats that the server uses when an analysis is performed based on formatted values. You can migrate existing user-defined formats from SAS to the SAS Viya platform.	Tools CAS
Instant Performance Boost: Creating Indexes on the Fly with the INDEX= Data Set Option Defines one or more indexes for a new output SAS data set.	Général
Stop Bloating Your Datasets: The Definitive Guide to Variable Selection with KEEP Specifies variables to include in output SAS data sets.	ETL CAS
Combine and Conquer: Mixing Physical Paths and Existing Librefs in One LIBNAME Statement Explains the concept of SAS library concatenation, allowing several libraries to be logically grouped under a single reference (libref).	Data Access
Stop Importing, Start Connecting: A Master Class in SAS/ACCESS Engines and SQL Pass-Through This document provides examples of using SAS engines to access and process various types of external data, including delimited files, Excel files, databases (DBMS), XML, and JSON.	Data Access

Catégories

CAS Only VIYA Only

All categories Macro 537 Statistical 300 ETL 201 Général 113 Reporting 104 Administration 89 Data Manipulation 50 Statistics 46 Utility 37 Test 27 Data Access 26 Data Management 21