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...
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 ...
CAS vs. Compute Server: Where Should You Run Your FedSQL Code in SAS Viya
FedSQL is a proprietary SAS implementation of the ANSI SQL:1999 standard, offering scalable, multi-threaded, high-per...
SAS Viya Essentials: How to Read, Write, and Persist In-Memory CAS Tables
This document provides detailed examples on how to read external files (like a CSV file) and convert them into in-mem...
Stop Wasting CPU: How to Use the SAS SORTEDBY= Option to 'Fake' a Sort
This document provides examples on how to sort a data set, display descriptive information for a data set, and view s...
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 ...
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 ...
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...
The Big Four: Decoding the Differences Between Work, User, Sashelp, and Sasuser
This document describes the default SAS libraries (Work, User, Sashelp, Sasuser) provided by SAS, their role, use, an...
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, ...
Buffers and Benchmarks: How to Optimize ODBC Read/Write Speeds in SAS Viya
Allows transferring data between an ODBC data source and SAS Cloud Analytic Services (CAS).
Bridge the Gap: Reading and Writing Excel Files Directly from the CAS Server
The PC Files Data Connector allows SAS Cloud Analytic Services (CAS) to access data stored in common PC file formats,...
Beyond Physical Files: Unlocking the Logical Power of the SAS Dataset Mode
This document explains how SAS engines manage access and processing of data files in the SAS Compute Server, includin...
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...
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...
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...
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...
Beyond the Basics: Mastering SAS Data Access Models and Record-Level Locking
This document describes the characteristics of SAS engines, including a summary of commonly used engines, the default...
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...
SAS Table Structure: Optimize Your Metadata and Sorting (V9/SPD)
This document defines what a SAS data set is, its components (data and metadata), and how it is stored depending on t...
Connecting SAS Viya 4 to Greenplum: A Complete Guide to the Data Connector
Enables data transfer between a Greenplum database and SAS Cloud Analytic Services (CAS). This connector facilitates ...
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 ...
Parsing JSON at Scale: Building a Dynamic SAS Macro for Multi-Year API Extractions
Macro script to extract statistical data from the Korean public API (KOSIS), transform it, and save it as SAS tables.
SAS Performance Tuning: Supercharge Your Hadoop Uploads with BULKLOAD=YES
This SAS script demonstrates and compares different methods for loading data into a Hadoop environment using SAS/ACCE...
Netezza Data Connector
The Netezza data connector enables SAS Cloud Analytic Services (CAS) to connect to and access data stored in a Netezz...
Hadoop Data Connector
Allows data transfer between Hive and SAS Cloud Analytic Services (CAS).
Informix Data Connector
This document describes the SAS Cloud Analytic Services (CAS) data connector for Informix, allowing data to be read f...
Greenplum Data Connector
Enables data transfer between a Greenplum database and SAS Cloud Analytic Services (CAS).