1676 Codes trouvés
Supercharge 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...
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 ...
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...
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 t...
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...
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...
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.
Stop Bloating Your Datasets: The Definitive Guide to Variable Selection with KEEP
Specifies variables to include in output SAS data sets.
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 ...
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 ...
Stop Data Truncation! How to Master the CVP Engine for Safe SAS Encoding Migrations
This document provides detailed examples on using different SAS engines (V9, SPD, CVP, CAS) to manage, process, and a...
Beyond PROC CONTENTS: The Efficient Way to Scan Library Members with PROC DATASETS
This document provides SAS code examples to display and manage information related to SAS libraries and their members...
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.
The Universal Translator: Why SAS Can Analyze Data Without Physically Owning It
This document explains how SAS engines interact with files, including SAS datasets and external file types, within th...
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...
Examples: Sorting and Displaying Descriptor Information for Data Sets
This document provides examples on how to sort a data set, display descriptive information for a data set, and view s...
Master & Transaction Logic: The Definitive Guide to Applying Sequential Updates in SAS
This document presents examples of using the UPDATE statement in SAS to modify a master dataset from the values of a ...
Variable Mismatches? No Problem. How to Standardize Metadata with ATTRIB and PROC SQL
This document provides detailed examples on preparing and combining SAS datasets, addressing common issues such as in...
Mastering BY-Group Processing: A Deep Dive into FIRST. and LAST. Variables in SAS
This document explains and demonstrates the use of automatic FIRST. and LAST. variables in the SAS DATA step for proc...
Mastering Data Segmentation: The Definitive Guide to BY-Group Processing in SAS
This document provides examples illustrating how to process BY groups (BY-Groups) in a SAS DATA step. It covers the u...
Don't Lose Your Data: How to Prevent Truncation When Migrating SAS Libraries to UTF-8
This document provides examples for managing SAS libraries, including migration, copying, and transferring libraries ...
The 'Many-to-Many' Trap: Handling Duplicate Keys and Missing Values in SAS Merges
This document provides examples of match-merging SAS datasets using the MERGE and BY statements in a DATA Step. It co...
Side-by-Side Data: Mastering Positional Merging with MERGE vs. Double SET Statements
This document presents examples of using the MERGE statement without the BY statement to perform one-to-one data merg...
Read Less, Run Faster: Optimizing SAS Performance with KEEP, WHERE, and OBS
This document provides SAS code examples for controlling variables and observations when manipulating SAS datasets.
No Input File? No Problem: How to Generate and Read SAS Data Sets from Scratch
This document provides detailed examples on creating, reading, and manipulating SAS data sets, including the use of u...
DO WHILE vs. DO UNTIL: How to Avoid Logic Errors in Your SAS Loops
This documentation provides examples illustrating the use of different forms of DO loops in SAS DATA steps, including...
Perfect Order: Preserving Sort Logic When Stacking Multiple SAS Tables
This documentation presents examples of interleaving SAS datasets. Interleaving combines observations from two or mor...
Cleaner, Faster, Better: Refactoring Your SAS Logic with SELECT Groups
This example demonstrates how to use the SELECT statement in the DATA step to subset a SAS dataset.
Dynamic Data Access: How to Automate Librefs with Macros and DLCREATEDIR
This document provides detailed examples on how to access SAS data using librefs. It covers assigning librefs via the...
Skip the Libname: A Guide to Direct File Access and Path References in SAS
This document provides examples illustrating different methods of accessing SAS data without explicitly resorting to ...
Stitching Data Without Keys: Mastering One-to-One Reading in the SAS Data Step
This example illustrates combining observations from two datasets using the SET statement. It highlights the behavior...
Insert or Update? Handling Transactional Logic with _IORC_ and %SYSRC
This example illustrates how to use the `MODIFY` statement in a DATA Step to update a master data set (`master`) from...
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...
Unlocking ADLS Gen2: The Secret to Reading Distributed ORC Tables with SAS
This example demonstrates how to read an ORC format table located in an Azure Data Lake Storage (ADLS) location using...
Go Cloud-Native: How to Convert and Upload SAS Data to Parquet on Google Cloud
This example shows how to create a Parquet table in a Google Cloud Storage bucket using the LIBNAME statement and PRO...
Physical vs. Logical: Unlocking the Hidden Behavior of SAS Data Set Options
This example shows how to use the FIRSTOBS= and OBS= data set options with the WHERE statement to specify a segment o...
Beyond the MERGE Statement: Mastering In-Memory Joins with SAS Hash Objects
This example illustrates the use of a hash table to merge two SAS datasets (one-to-many or many-to-many) using a comm...
Packed vs. Zoned Decimal: How to Handle Complex Binary Data in SAS External Files
This document provides definitions for key terms related to external files in SAS.
The Anatomy of a SAS Dataset: Understanding Metadata, Engines, and Storage Models
A SAS dataset is a collection of tabular data in a SAS file format, containing both data and metadata. This document ...
Stop Scrolling the Log: How to Export SAS Metadata to a Dataset with PROC DATASETS
This example demonstrates how to use the DATASETS procedure and the CONTENTS statement to describe an existing SAS da...
Beyond the Basics: Unlocking the Power of SAS Library Engines and Options
This document explains the constituent elements of assigning a SAS library, including the library name (libref), the ...
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 ...
Stop Indexing Everything: Balancing Query Performance vs. Disk Space in SAS
An index is a file associated with a table that allows access to rows by index value. Indexes can speed up access to ...
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.
The 'Missing Variable' Trap: Why You Can't Process Variables Dropped on Input
For an input data set, excludes specified variables from processing; for an output data set, excludes specified varia...
