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...
Folders Are Dead: Understanding the Flat Architecture of the SAS Viya Files Service
The SAS Viya Platform Files Service allows you to store, retrieve, and delete files managed within the SAS Infrastruc...
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...
Boost Your Performance: Optimizing CAS Data Loading with the DVR Memory Format
This document explains how to read and write data from external files using SAS, detailing the use of the DATA step, ...
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...
Stop Slowing Down Viya: How to properly Mix SAS Macros with CAS Action
This documentation describes the support for the SAS macro language within the SAS Viya platform. The macro language ...
Secure, Sort, and Index: A Comprehensive Guide to Managing SAS Data Sets
This example demonstrates how to modify SAS data sets using the MODIFY statement and subordinate statements within PR...
Slim Down Your Data: How to Optimize SAS Storage with the KEEP Statement
Specifies which variables to include in output SAS data sets.
Supercharge Your Lookups: Mastering Simple and Composite Indexes in the SAS DATA Step
Defines an index for a new output SAS data set.
Stop Wasting Compute: Validated vs. Unvalidated Sorting in SAS Data Sets
This article provides practical examples on how to sort SAS data sets and display their descriptive information. It e...
Connect Anything: How to Leverage SAS Engines for Teradata, XML, and Web-Ready JSON
This document provides detailed examples on how to use SAS engines to interact with various external data formats, in...
Modern SAS Data Architecture: Leveraging Cloud (CAS) and Distributed Engines
This document provides examples of using various SAS engines (V9, SPD, CVP, CAS) to manipulate and manage SAS data, i...
WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya
This document provides examples of using WHERE statements and options in SAS for conditional selection of data rows, ...
Fixing SAS Merge Errors: How to Standardize Attributes and Data Types
This document contains detailed examples on preparing and manipulating SAS data before combining it, addressing vario...
SAS Data Step Logic: A Deep Dive into First.Variable and Last.Variable
This documentation provides examples of using the automatic FIRST. and LAST. variables in a SAS DATA step to process ...
How to Organize and Process SAS Datasets with BY Groups and PROC SORT
This document presents practical examples on how to group and process data observations using the BY statement in a D...
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...
How to Interleave SAS Datasets: Combining Data While Preserving Sort Order
This document provides examples illustrating how to interleave SAS datasets using the SORT procedure and the BY state...
Copy, Port, or Import? 3 Essential Methods to Transfer SAS Libraries Fast
This document provides key examples and insights for managing SAS libraries, including migration, copying, and using ...
SAS Merge Without a BY Statement? Avoiding Common Data Step Pitfalls
This document explains how to merge SAS data sets using the MERGE statement without the BY statement, an operation of...
Dynamic SAS Library Management: Using %SYSFUNC and Macros for Automated Access
This document provides detailed examples on how to access data in the SAS environment using librefs. It covers assign...
One-to-One Reading in SAS: How to Combine Datasets Without a BY Statement
This example illustrates the use of two SET statements to combine observations from two datasets ('animal' and 'plant...
Stop Rebuilding Tables: Faster Ways to Append Data in SAS Using PROC APPEND and OPEN=DEFER
This document explains how to concatenate SAS datasets using various methods, including the SET statement, PROC SQL p...
How to Filter SAS Data Faster: Mastering WHERE, KEEP, and Observation Options
This document provides practical examples on how to control which variables and observations are read and written whe...
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...
Beyond Local Data: How to Access Azure ADLS ORC Tables Using SAS LIBNAME
This example illustrates how to read an ORC (Optimized Row Columnar) format table stored in Azure Data Lake Storage G...
Stop Using Nested IF-THEN: Mastering the SELECT WHEN Statement in SAS
This example shows how to use the DATA step's SELECT statement to subset a SAS dataset and apply conditional modifica...
How to Generate and Filter Data Efficiently in a SAS DATA Step
This example shows how to use the FIRSTOBS= and OBS= data set options with the WHERE statement to specify a segment o...
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...
Mastering SAS In-Place Updates: How to Handle Complex Transactions with IORC
This example illustrates how to modify a master dataset by adding or updating observations from a transaction dataset...
Skip the Libref: How to Access SAS Data Directly via File Paths
This document describes the key elements of assigning a SAS library, including the library name (libref), the library...
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...
Beyond Local Files: Streamlining Big Data with the SAS Parquet Engine on GCS
This example demonstrates how to create a Parquet table in a Google Cloud Storage bucket. The LIBNAME statement estab...
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...
Mastering PROC DATASETS: How to Generate a SAS Data Dictionary Fast
This example illustrates the output of the CONTENTS statement for the Group data set. The output shows the modificati...
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...
Don't Over-Index! The Expert Guide to Smarter SAS PROC SQL Indexing
An index is a file associated with a table that allows access to rows by index value. Indexes can speed up access to ...
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...
