124 Codes trouvés CAS Only
RéinitialiserSupercharge Your CAS Queries: A Complete Guide to Table Indexing in SA
This script illustrates the creation of an in-memory table with indexed columns in SAS Viya. Indexing can significant...
SAS Data Step Efficiency: When to Use Explicit OUTPUT vs. Implicit Rules
Writes the current observation to a SAS dataset.
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...
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...
Stop Bloating Your Datasets: The Definitive Guide to Variable Selection with KEEP
Specifies variables to include in output SAS data sets.
Logic Traps: Mastering Operator Precedence and Parentheses in Complex SAS Filters
This document provides examples illustrating the use of the WHERE clause to conditionally select rows in SAS tables, ...
Stop Copy-Pasting: Automate Your CSV Generation with the DBMS=CSV Option
This example explains how to export a SAS dataset to a CSV file using the EXPORT procedure.
Examples: Reading and Creating CAS Tables
This document provides detailed examples on how to read external files (like a CSV file) and convert them into in-mem...
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...
DROP vs. KEEP: When to Exclude Variables and Why You Should Never Mix Them
The DROP statement allows variables to be excluded from output SAS data sets, while still making them available for p...
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...
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...
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 ...
Subsetting IF vs. DELETE: Which Statement Should You Use to Filter SAS Observations?
Stops processing the current observation and prevents it from being written to a SAS data set.
Mastering PROC SGMAP: A Guide to Creating and Exporting Choropleth Maps
This example opens the PDF destination, which produces PDF output. For the purpose of this example, re-run the 'Creat...
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...
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...
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...
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...
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...
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...
Stop Overwriting Your Data: How to Perform In-Place Updates with table.update
This functionality allows modifying existing row values in a CAS table using the `table.update` action. It supports u...
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...
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...
Slim Down Your Data: How to Optimize SAS Storage with the KEEP Statement
Specifies which variables to include in output SAS data sets.
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...
DO WHILE vs. DO UNTIL: Choosing the Right Loop for Your SAS Data Step
This document provides examples of using DO loops in SAS, including simple iterative, nested, with value lists (DOLIS...
Beyond the DATA Step: How to Filter and Alter CAS Tables Faster with PROC CASUTIL
This example uses three PROC CASUTIL statements to load, partition, and modify a CAS table. It demonstrates how to lo...
Faster Merging in SAS: Why Hash Objects Outperform Traditional Joins
This example illustrates the use of a hash table to merge two datasets sharing a common variable. The hash table is c...
Deploying Boolean Rules: A Guide to Scoring Models with PROC BOOLRULE and SAS ASTORE
This functionality describes how to apply boolean rules generated by the BOOLRULE procedure to new data. Scoring allo...
The SAS Viya Data Type Matrix: Optimizing Storage with VARCHAR and VARBINARY
This document describes the data types supported by the SAS Viya CAS server, including traditional SAS types (CHARACT...
Cleaning SAS Datasets: How to Use the DROP Statement to Manage Variables
Excludes variables from output SAS datasets.
Visualizing US Geospatial Data: A Guide to PROC SGMAP and Choropleth Maps
This SAS script analyzes and visualizes data to create a gradient map of the United States, excluding Alaska, Hawaii,...
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...
Scaling the SAS DATA Step: Mastering MPP and Multithreading in SAS Viya
The DATA step is a fundamental component of SAS programming, enabling data manipulation and transformation. In the SA...
From Local Work to CAS: 4 Essential Scripts for SAS Viya Table Promotion
This feature allows creating a copy of an existing table loaded into memory within a SAS Cloud Analytic Services (CAS...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
SAS Viya Data Lifecycle: How to Upload, Persist, and Drop CAS Tables with PROC CAS
This script illustrates the actions of the 'table' action set in SAS Viya 4 for managing in-memory tables. It covers ...
Mastering Hybrid SAS: How to Orchestrate SAS/CONNECT and CAS Sessions
This SAS script establishes and manages SAS/CONNECT and CAS sessions on a SAS Viya environment. It demonstrates local...
CAS Session and Connect Management and Data Creation
This SAS script configures and manages a CAS session and a SAS/CONNECT session for code execution both locally and on...
Sans titre
This SAS script demonstrates the use of the ODBC data connector in SAS Viya 4 to access column metadata for a CAS tab...
Loading Data with CAS Connector (Example)
This SAS script demonstrates how to use the SAS data connector to load data from an external relational database mana...
CAS Disk Cache Monitoring
Script for monitoring and displaying CAS disk cache information.
