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...
The 'Factory Reset' for Permissions: Using remAllAcsData to Clean Up CAS Tables
This feature allows you to remove all direct access controls applied to a CAS table, thus reverting it to inherit its...
Stop Moving Files: How to Map Multiple Folders to a Single SAS Library
When you concatenate two or more SAS libraries, you logically join the contents of the libraries. Although the librar...
From Server Logs to Actionable Data: Automating Job Status Reports in SAS
This example generates a data set that provides information about tasks currently running or executed on a DataFlux D...
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...
Auditing SAS 9 Metadata: How to Automate Database Library and Connection Inventories
This script extracts information about database management system (DBMS) type libraries defined in a SAS 9 metadata s...
Beyond the Management Console: Automating SAS Deployment Reports with Metadata Functions
This SAS script extracts the list of deployment directories defined in SAS metadata, along with associated files and ...
Unlock System Metadata: Using the SAS PIPE Engine to Read OS-Level Commands
Macro to write system and user environment variables to a SAS dataset.
Orphan Foreign Key Cleanup in Metadata
Identifies and, optionally, deletes foreign keys (ForeignKey) that do not have a 'PartnerUniqueKey' association in SA...
Unlock a SAS Dataset
Utility macro to remove the lock on a SAS dataset.
Netezza Database Schema Modification for CI360
This script modifies the structure of the Common Data Model (CDM) for CI360 on a Netezza database to align with 'Sche...
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...
Copying Members Between SAS 9 Metadata Groups
SAS 9 script to extract members from one metadata group and add them to another. This script is specifically for SAS ...
Updating Server Contexts for SAS Libraries
Administration script for SAS 9 that associates an application server context (e.g., SASSTP) with a set of SAS librar...
Configuring OneDrive Authentication via OAuth2
One-time setup script to obtain the OAuth2 authentication tokens required for interacting with Microsoft OneDrive.
Session Options and Memory Configuration Overview
Script to view the current SAS session options and specifically inspect the memory configuration.
List available ODS styles
This SAS script lists the ODS styles available in the SAS environment using both PROC TEMPLATE and PROC SQL.
Displaying SAS System Options
Displays the complete list of SAS system options and their current values in the log.
Orchestrating and Testing SAS Viya Job Flows
This SAS script demonstrates the creation, configuration, and execution of job flows in SAS Viya, including error han...
Extracting Metadata Deployment Directories
This script extracts and lists deployment directories and their associated files directly from SAS metadata.
Extracting File Paths from Metadata
Administration script querying the metadata server to list all registered file paths (Directory and SASFileRef).
Extracting extended library attributes (SAS 9 Metadata)
Script extracting extended attributes of a LASR library by querying a SAS 9 Metadata Server.
Stored Process Source Code Extraction via Metadata
Script to extract and potentially modify the source code of Stored Processes stored in the SAS metadata server.
Extracting Stored Process Source Code (SAS Metadata)
This program retrieves the source code of Stored Processes registered in the SAS 9 Metadata Server and writes it to t...
Extracting User IDs by Group (SAS 9 Metadata)
Script listing user IDs for each member of a given group via the SAS 9 metadata server.
CAS Disk Cache Monitoring
Script for monitoring and displaying CAS disk cache information.
Deleting Users from Metadata
Program that deletes a defined list of users and their associated logins from the metadata server.
View effective access to a table
Analyzes effective (net) access to a table or caslib in SAS Viya using the `accessControl.whatIsEffective` action.
Simple Row-Level Filtering
This document explains how to define a simple row-level filter to control user access to data in a CAS table.
Remove a Direct Access Control
This example explains how to remove a direct access control on a CAS table, allowing access to be inherited or derive...
Promote a Format Library
Explains how to make a user-defined SAS format library available to all CAS sessions or promote it for use by other u...
Make a new global CAS library available
This example makes the data in a new global CAS library available to a specific group. To provide read access to CAS ...
SAS License Verification
Displays information related to the SAS software license.
List files in a caslib data source
This feature allows listing files present in a data source associated with a CAS caslib, displaying detailed informat...
Hide a column for most users
This example illustrates how to modify access controls on a specific column of a CAS table to hide it from all users,...
Designating CAS Superuser
This document describes concepts and methods for designating or managing superuser privileges in SAS Cloud Analytic S...
Text Search by Unix System Command
Utility script to search for character strings in server files via Unix system commands.
DMS Tasks and Logs Cleanup
This functionality allows generating a report on DataFlux Data Management Server tasks, then using this report to sto...
Staging Git Files
This macro allows you to stage files from a local Git repository for the next commit.
Recursive Folder Deletion Macro
SAS macro to recursively delete a folder and all its subfolders and files.
Macro for deleting table constraints
This macro dynamically deletes constraints (primary, unique, not-null keys) from SAS tables by generating and executi...
Update Stored Process Server Type
This macro updates the server type (Workspace or Stored Process) of a SAS Viya 4 stored process by modifying its meta...
Creating a Metadata Folder
SAS macro to create a folder in the SAS metadata repository. It uses system calls to execute an external command and ...
Deleting a Stored Process via Metadata
SAS macro for deleting a Stored Process using its metadata path as a reference. It interacts directly with the SAS me...
Deleting a Library via SAS Metadata
SAS macro to delete a library definition from the metadata server (OMR) using its name.
Delete a Metadata Document
SAS macro for deleting a 'Document' type object from the SAS metadata repository using its full path.
Extracting User IDs from DefaultAuth Domain
This SAS script connects to the SAS metadata server to extract a list of all user IDs defined under the 'DefaultAuth'...
Managing user-defined formats in CAS for Viya
This SAS script demonstrates how to create, save, promote, and make user-defined formats accessible in the SAS Cloud ...
Clean Up "Ghost" Sessions: A Safe Macro to Terminate Stuck SAS Processes on Windows
Utility macro to terminate a specific SAS session on Windows via the taskkill system command.
Automatic Launch of Excel via DDE
Script checking if Excel is open via DDE protocol and launching it via Windows system commands if necessary.
Environment Configuration and Dependency Loading
Configuration script defining the working directory, initializing a library, and loading several external utility mac...
List and locate SAS VA reports via REST API
This script uses the SAS Viya REST API to retrieve the list of SAS Visual Analytics reports, then determines and disp...
Extracting Extended Library Attributes via Metadata
Administration script querying the metadata server to extract extended attributes of a specific SAS library.
Extracting Stored Process Prompts (Metadata API)
Retrieves the list of prompts associated with Stored Processes by querying the metadata server.
Extracting Database Library Metadata
Retrieves detailed information about database libraries defined in the metadata server.
Querying SAS Workload Orchestrator Job Information
This script queries the SAS Workload Orchestrator API to retrieve job information, then formats and displays the resu...
Querying SAS Workload Orchestrator jobs via API
This script queries the SAS Workload Orchestrator API to retrieve information about jobs, then processes the JSON res...
Extracting Job Source Paths from Metadata
Script retrieving the full source file path for each Job defined in the SAS metadata server (SAS 9 Architecture).
Retrieving Metadata Libraries
SAS macro retrieving the list of libraries defined in the SAS metadata server (SAS 9) and generating an output table.
Extraction of Stored Process Source Paths (SAS 9 Metadata)
Administration script (legacy SAS 9) to extract the source file paths of Stored Processes from the metadata server.
Metadata Server Port and Service Extraction
Script retrieving the list of servers and connection ports configured in the SAS metadata server.
Rename a CAS table
This SAS script demonstrates how to rename an existing CAS table in a SAS Viya 4 environment using PROC CAS actions.
Managing SAS Session Options
Saving, temporarily modifying, and restoring SAS system options.
Fileref and File Manipulation
This SAS script demonstrates the use of file I/O functions to check existence, assign, open, retrieve information, an...
Extracting file information via OS command
This SAS macro executes an operating system command to get information about a file and stores the file's date, time,...
Opening FSP help via Windows system command
Retrieves system environment variables to attempt opening a specific help file via an external command.
Remote SAS Session Management and System Command
This SAS script manages the initiation and termination of a remote SAS session via SAS/CONNECT, while executing a Win...
Managing SAS Formats in CAS
This SAS script demonstrates comprehensive management of user-defined formats in the SAS Viya CAS environment, includ...
Displaying operating system information
Displays the current operating system identifiers in the SAS log.
Using PROC SCAPROC for Flow Analysis
Script illustrating the use of PROC SCAPROC to record the inputs/outputs of a DATA step.
System Environment Management via Macro
Use of the %sysexec command to modify the working directory and environment variables of the underlying system.
Checking system options and macro variables
This SAS script checks a system option (`SASAUTOS`) and displays the values of environment or macro variables (`advte...
Definition and Management of User-Defined CAS Actions
This SAS script defines and manages User-Defined Actions (UDAs) for SAS Cloud Analytic Services (CAS), enabling detai...
Listing System Drives via DRIVEMAP
This script attempts to list the drives accessible to the operating system using the specific DRIVEMAP facility.
External File Deletion Macro
SAS macro to delete an external file if it exists, using the system functions filename and fdelete.
File Listing via System Pipe (Windows)
Execution of a system command to list files in a directory and loading the result into a SAS table.
SAS Viya CAS Environment Information
This SAS Viya script provides detailed information about the Cloud Analytic Services (CAS) environment, including the...
Windows Temporary Directory Cleanup
SAS macro to delete a specific temporary directory (`c:\tempwork`) and its contents on a Windows operating system.
Re-associating File Objects via SAS 9 Metadata
Administrative script designed to reassign file objects from an old directory to a new one in the metadata server.
Updating Windows Login Domains
This script searches for logins associated with a specific Windows domain and updates them by replacing the old domai...
Dynamic SAS Environment Configuration
This macro dynamically configures SAS session options, including search paths for autocall macros (sasautos) and form...
Management and Connectivity to the SAS/SHARE Server
This document describes examples of managing a SAS/SHARE server (starting, stopping) and accessing remote data via a ...
Lilly Macro Library Refresh
This SAS macro, named AHGrefreshlilly, is designed to automate the refreshing and backup of a SAS macro library. It s...
System write macro via XCMD
Macro writing a value to a text file via a system command.
Massive addition of groups in SAS 9 metadata
Administration script to add all existing user groups to a target parent group via the metadata server.
Automatic Server Context Assignment (SAS 9 Metadata)
Administration script interacting with a SAS 9 metadata server to assign an application server context (SASSTP) to a ...