Administration - WeAreCAS

CODE SAS

SAS Viya Platform File Service

The SAS Viya Platform File Service allows storing, retrieving, and deleting files kept in the SAS...

CODE SAS

Revert a Table to Inherited Access

This feature allows you to remove all direct access controls applied to a CAS table, thus reverti...

CODE SAS

Generate a Job Status Data Set

This example generates a data set that provides information about tasks currently running or exec...

CODE SAS

Describe a SAS Data Set

This example illustrates the output of the CONTENTS statement for the Group data set. The output ...

CODE SAS

Add an Oracle Caslib

This feature allows adding a caslib to connect to an Oracle database in SAS Viya 4, making data a...

CODE SAS

Add a File System Path Caslib

This feature allows adding a caslib (CAS library) based on a file system path, facilitating acces...

CODE SAS

Extracting database library information from metadata

This script extracts information about database management system (DBMS) type libraries defined i...

CODE SAS

Extracting Deployment Directories from SAS Metadata

This SAS script extracts the list of deployment directories defined in SAS metadata, along with a...

CODE SAS

Orphan Foreign Key Cleanup in Metadata

Identifies and, optionally, deletes foreign keys (ForeignKey) that do not have a 'PartnerUniqueKe...

CODE SAS

Unlock a SAS Dataset

Utility macro to remove the lock on a SAS dataset.

CODE SAS

Netezza Database Schema Modification for CI360

This script modifies the structure of the Common Data Model (CDM) for CI360 on a Netezza database...

CODE SAS

SAS/CONNECT and CAS Session Management

This SAS script establishes and manages SAS/CONNECT and CAS sessions on a SAS Viya environment. I...

CODE SAS

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...

CODE SAS

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 s...

CODE SAS

Updating Server Contexts for SAS Libraries

Administration script for SAS 9 that associates an application server context (e.g., SASSTP) with...

CODE SAS

Configuring OneDrive Authentication via OAuth2

One-time setup script to obtain the OAuth2 authentication tokens required for interacting with Mi...

CODE SAS

Session Options and Memory Configuration Overview

Script to view the current SAS session options and specifically inspect the memory configuration.

CODE SAS

List available ODS styles

This SAS script lists the ODS styles available in the SAS environment using both PROC TEMPLATE an...

CODE SAS

Displaying SAS System Options

Displays the complete list of SAS system options and their current values in the log.

CODE SAS

Orchestrating and Testing SAS Viya Job Flows

This SAS script demonstrates the creation, configuration, and execution of job flows in SAS Viya,...

CODE SAS

Extracting Metadata Deployment Directories

This script extracts and lists deployment directories and their associated files directly from SA...

CODE SAS

Extracting File Paths from Metadata

Administration script querying the metadata server to list all registered file paths (Directory a...

CODE SAS

Extracting extended library attributes (SAS 9 Metadata)

Script extracting extended attributes of a LASR library by querying a SAS 9 Metadata Server.

CODE SAS

Stored Process Source Code Extraction via Metadata

Script to extract and potentially modify the source code of Stored Processes stored in the SAS me...

CODE SAS

Extracting Stored Process Source Code (SAS Metadata)

This program retrieves the source code of Stored Processes registered in the SAS 9 Metadata Serve...

CODE SAS

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.

CODE SAS

CAS Disk Cache Monitoring

Script for monitoring and displaying CAS disk cache information.

CODE SAS

Deleting Users from Metadata

Program that deletes a defined list of users and their associated logins from the metadata server.

CODE SAS

File Backup to H: with Timestamp

Macro performing a backup copy of a file to a drive (default H:) by adding the date to the file n...

CODE SAS

Macro AHGtoLocal - File copy to local

Utility macro to copy a file from a source location to a local destination directory via system c...

CODE SAS

System File Creation Macro

Utility macro to create a text file containing a specific string using system commands (X command).

CODE SAS

View effective access to a table

Analyzes effective (net) access to a table or caslib in SAS Viya using the `accessControl.whatIsE...

CODE SAS

Simple Row-Level Filtering

This document explains how to define a simple row-level filter to control user access to data in ...

CODE SAS

Remove a Direct Access Control

This example explains how to remove a direct access control on a CAS table, allowing access to be...

CODE SAS

Promote a Format Library

Explains how to make a user-defined SAS format library available to all CAS sessions or promote i...

CODE SAS

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...

CODE SAS

SAS License Verification

Displays information related to the SAS software license.

CODE SAS

List files in a caslib data source

This feature allows listing files present in a data source associated with a CAS caslib, displayi...

CODE SAS

Hide a column for most users

This example illustrates how to modify access controls on a specific column of a CAS table to hid...

CODE SAS

Designating CAS Superuser

This document describes concepts and methods for designating or managing superuser privileges in ...

CODE SAS

Text Search by Unix System Command

Utility script to search for character strings in server files via Unix system commands.

CODE SAS

DMS Tasks and Logs Cleanup

This functionality allows generating a report on DataFlux Data Management Server tasks, then usin...

CODE SAS

Staging Git Files

This macro allows you to stage files from a local Git repository for the next commit.

CODE SAS

Recursive Folder Deletion Macro

SAS macro to recursively delete a folder and all its subfolders and files.

CODE SAS

Macro for deleting table constraints

This macro dynamically deletes constraints (primary, unique, not-null keys) from SAS tables by ge...

CODE SAS

Update Stored Process Server Type

This macro updates the server type (Workspace or Stored Process) of a SAS Viya 4 stored process b...

CODE SAS

Creating a Metadata Folder

SAS macro to create a folder in the SAS metadata repository. It uses system calls to execute an e...

CODE SAS

Deleting a Stored Process via Metadata

SAS macro for deleting a Stored Process using its metadata path as a reference. It interacts dire...

CODE SAS

Deleting a Library via SAS Metadata

SAS macro to delete a library definition from the metadata server (OMR) using its name.

CODE SAS

Delete a Metadata Document

SAS macro for deleting a 'Document' type object from the SAS metadata repository using its full p...

CODE SAS

Extracting User IDs from DefaultAuth Domain

This SAS script connects to the SAS metadata server to extract a list of all user IDs defined und...

CODE SAS

Managing user-defined formats in CAS for Viya

This SAS script demonstrates how to create, save, promote, and make user-defined formats accessib...

CODE SAS

Killsess - SAS Windows Session Termination

Utility macro to terminate a specific SAS session on Windows via the taskkill system command.

CODE SAS

Automatic Launch of Excel via DDE

Script checking if Excel is open via DDE protocol and launching it via Windows system commands if...

CODE SAS

Environment Configuration and Dependency Loading

Configuration script defining the working directory, initializing a library, and loading several ...

CODE SAS

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...

CODE SAS

Extracting Extended Library Attributes via Metadata

Administration script querying the metadata server to extract extended attributes of a specific S...

CODE SAS

Extracting Stored Process Prompts (Metadata API)

Retrieves the list of prompts associated with Stored Processes by querying the metadata server.

CODE SAS

Extracting Database Library Metadata

Retrieves detailed information about database libraries defined in the metadata server.

CODE SAS

Querying SAS Workload Orchestrator Job Information

This script queries the SAS Workload Orchestrator API to retrieve job information, then formats a...

CODE SAS

Querying SAS Workload Orchestrator jobs via API

This script queries the SAS Workload Orchestrator API to retrieve information about jobs, then pr...

CODE SAS

Extracting Job Source Paths from Metadata

Script retrieving the full source file path for each Job defined in the SAS metadata server (SAS ...

CODE SAS

Retrieving Metadata Libraries

SAS macro retrieving the list of libraries defined in the SAS metadata server (SAS 9) and generat...

CODE SAS

Extraction of Stored Process Source Paths (SAS 9 Metadata)

Administration script (legacy SAS 9) to extract the source file paths of Stored Processes from th...

CODE SAS

Metadata Server Port and Service Extraction

Script retrieving the list of servers and connection ports configured in the SAS metadata server.

CODE SAS

Rename a CAS table

This SAS script demonstrates how to rename an existing CAS table in a SAS Viya 4 environment usin...

CODE SAS

Managing SAS Session Options

Saving, temporarily modifying, and restoring SAS system options.

CODE SAS

Fileref and File Manipulation

This SAS script demonstrates the use of file I/O functions to check existence, assign, open, retr...

CODE SAS

Extracting file information via OS command

This SAS macro executes an operating system command to get information about a file and stores th...

CODE SAS

Opening FSP help via Windows system command

Retrieves system environment variables to attempt opening a specific help file via an external co...

CODE SAS

Remote SAS Session Management and System Command

This SAS script manages the initiation and termination of a remote SAS session via SAS/CONNECT, w...

CODE SAS

Managing SAS Formats in CAS

This SAS script demonstrates comprehensive management of user-defined formats in the SAS Viya CAS...

CODE SAS

Displaying operating system information

Displays the current operating system identifiers in the SAS log.

CODE SAS

Using PROC SCAPROC for Flow Analysis

Script illustrating the use of PROC SCAPROC to record the inputs/outputs of a DATA step.

CODE SAS

System Environment Management via Macro

Use of the %sysexec command to modify the working directory and environment variables of the unde...

CODE SAS

Checking system options and macro variables

This SAS script checks a system option (`SASAUTOS`) and displays the values of environment or mac...

CODE SAS

Definition and Management of User-Defined CAS Actions

This SAS script defines and manages User-Defined Actions (UDAs) for SAS Cloud Analytic Services (...

CODE SAS

Listing System Drives via DRIVEMAP

This script attempts to list the drives accessible to the operating system using the specific DRI...

CODE SAS

External File Deletion Macro

SAS macro to delete an external file if it exists, using the system functions filename and fdelete.

CODE SAS

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.

CODE SAS

SAS Viya CAS Environment Information

This SAS Viya script provides detailed information about the Cloud Analytic Services (CAS) enviro...

CODE SAS

Creation of SAS Viya role via DATA step and Metadata functions

This SAS DATA step script creates a new role in SAS Viya using Metadata functions. It adds attrib...

CODE SAS

Adding Deployment Directories to SAS Metadata

This script adds a list of deployment directories to a specific application context (e.g., SASApp...

CODE SAS

Creation of Authentication Domains

This SAS script creates authentication domains on the SAS metadata server using PROC METADATA.

CODE SAS

Windows Temporary Directory Cleanup

SAS macro to delete a specific temporary directory (`c:\tempwork`) and its contents on a Windows ...

CODE SAS

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...

CODE SAS

Updating Windows Login Domains

This script searches for logins associated with a specific Windows domain and updates them by rep...

CODE SAS

System File Copy Macro (AHGtoSDD)

Utility macro to copy a physical file from one directory to another using system commands.

CODE SAS

Dynamic SAS Environment Configuration

This macro dynamically configures SAS session options, including search paths for autocall macros...

CODE SAS

Management and Connectivity to the SAS/SHARE Server

This document describes examples of managing a SAS/SHARE server (starting, stopping) and accessin...

CODE SAS

Lilly Macro Library Refresh

This SAS macro, named AHGrefreshlilly, is designed to automate the refreshing and backup of a SAS...

CODE SAS

System write macro via XCMD

Macro writing a value to a text file via a system command.

CODE SAS

Massive addition of groups in SAS 9 metadata

Administration script to add all existing user groups to a target parent group via the metadata s...

CODE SAS

Automatic Server Context Assignment (SAS 9 Metadata)

Administration script interacting with a SAS 9 metadata server to assign an application server co...