Supercharge Your CAS Queries: A Complete Guide to Table Indexing in SAS
This script illustrates the creation of an in-memory table with indexed columns in SAS Viya. Indexing can significant...
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.
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...
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...
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...
Session vs. Global: Mastering User-Defined Format Scopes in SAS Viya
This feature allows user-defined formats to be stored in SAS catalogs or in a format library on the CAS server. These...
SAS Library Management: 3 Essential Ways to Audit and Locate Your Data
This document provides SAS code examples to display information about SAS libraries and their members. It shows how t...
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 ...
Creating Custom Format for Cylinders
Definition of a library and creation of a value format for cylinders.
Sans titre
Calculation of time differences and date incrementation.
SAS Date Management and Formatting
Example of manipulating internal dates and their formatting.
Generation of Test Data Sets (JES)
Script for generating multiple test tables (Contacts, TimeStamp, Poisson, Units, Fails, Rates) using static and simul...
Permanent Formats Provided by SAS
This document explains that SAS provides permanent formats usable with SAS Cloud Analytic Services. For a complete li...
Index an Existing SASHDAT File
This script explains how to create an index on an existing SASHDAT file directly on disk, without requiring the full ...
Handling Missing Values in Arithmetic Calculations
Illustration of missing value propagation during addition operations in a DATA step.
Password Protection for Data Tables
Example of creating an encrypted and password-protected SAS table.
Picture Formats and Date Directives
Demonstration of creating and using custom picture formats for dates and times using directives.
Export and Display JSON of sashelp.orsales
Exports the sashelp.orsales table to JSON format in a temporary file and displays the result in the log.
Creating a format for cylinders
Definition of a custom format for the textual display of the number of cylinders.
Attempt to modify SASHELP.Orsales
This script attempts to create or overwrite the system table `sashelp.Orsales` with a DATA step. It contains a `WHERE...
Creation of format for US states
Definition of a custom format associating numeric codes with state names.
Definition of Custom Formats for States and Sex
Creation of two SAS formats to convert numeric codes into explicit labels.