Interactive SAS macro that uses a series of windows to allow the user to specify a data set, variables, and options t...
View code
Macro
Extract Paths from SASAUTOS Option
SAS macro to parse the SASAUTOS system option and extract the list of macro search paths.
View code
Macro
Defining Graphic Parameters for GIF Output
SAS macro to configure GOPTIONS graphic options for generating files in GIF format.
View code
Macro
Frequency Analysis on Multiple Tables with a Macro
This SAS script creates two tables (males and females) and uses a macro to perform a frequency analysis (PROC FREQ) o...
View code
Macro
Extract File Name and Path from an Absolute Path
Macro-program to decompose an absolute file path into file name and parent path.
View code
Macro
Macro for editing a list of items
Function-style macro that allows editing a list of space-delimited items by applying a modification string to each item.
View code
Macro
Write environment variables to a SAS dataset
Macro to write system and user environment variables to a SAS dataset.
View code
Macro
Dynamic Graph Generation by Stock
This script uses a SAS macro to dynamically generate a distinct PDF report for each stock present in the SASHELP.STOC...
View code
Macro
Deleting Macros from work.sasmacr Catalog by SQL Pattern
Macro to delete macros from the work.sasmacr catalog using a user-specified SQL search pattern.
View code
Macro
Utility Macro for Truncating a SAS Table
SAS macro that deletes all observations from a table while preserving its structure, indexes, and integrity constraints.
View code
Macro
Converting Double Quotes and Commas in a String
Macro-function that converts double quotes to single quotes in a character string, after replacing all commas with sp...
View code
Macro
Remove option modifiers from a dataset name
Function-type macro that cleans a character string by removing option modifiers (e.g., where, drop) from SAS dataset ...
View code
Macro
commaparms - Add commas to macro parameters
Function-style macro to reinsert commas between macro parameters in a character string.
View code
Macro
SAS Macro for Table Version Retrieval (`AHGtabver`)
This macro allows retrieving the version number of a table or component by executing an external system command (`tab...
View code
Macro
Assertion of a Non-Empty Dataset
Generates an event if a specified dataset does not exist or is empty (contains no observations).
View code
Macro
Test of the SASUnit assertMustFail macro
This script is a test scenario for the SASUnit `%assertMustFail` macro, designed to validate that a test condition fa...
View code
Macro
Utility macro to determine the extension of SAS catalogs
Macro that determines the SAS catalog file extension (.sas7bcat, .sc2, etc.) based on a SAS version number provided a...
View code
Macro
Verification of Macro Calling Sequence
Verifies if SASUnit framework internal macros, such as 'initScenario' and 'Assert', are called in the correct context...
View code
Derniers codes ajoutés
Titre
Category
Voir
Modifying SAS Data Sets
This example illustrates the modification of two SAS data sets using the MODIFY statement and its sub-statements. It shows how to: modify SAS files, label a SAS data set, add a read password to a SAS data set, indicate the current sort order of a SAS data set, create an index for a SAS data set, assign informats and formats to variables, rename variables, and label variables in a SAS data set.
ETL
OUTPUT Statement
Writes the current observation to a SAS dataset.
ActionCAS
PROC CASUTIL
The CASUTIL procedure offers several table and caslib management functions, including displaying table metadata, deleting files, unloading and loading tables, promoting tables, and saving tables.
ETLCAS
Default SAS Libraries
This document describes the default SAS libraries: Work (temporary), User (user), Sashelp, and Sasuser. It explains their role and behavior within the SAS Viya 4 environment.
Data Access
SAS Viya Platform File Service
The SAS Viya Platform File Service allows storing, retrieving, and deleting files kept in the SAS Infrastructure Data Server database repository. This repository is not considered a complete 'file system' but contains individual files directly accessible by their file identifier (UUID).
Administration
User-Defined Formats
In the SAS Viya platform, you can store user-defined formats in catalogs for use in a SAS session, or you can store them in a format library on the CAS server. Format libraries are associated with a CAS session, or they can be promoted to global scope to be available to all CAS sessions. User-defined formats in a format library are server-side formats that the server uses when an analysis is performed based on formatted values. You can migrate existing user-defined formats from SAS to the SAS Viya platform.
ToolsCAS
Sans titre
Defines one or more indexes for a new output SAS data set.
Général
KEEP Statement
Specifies variables to include in output SAS data sets.
ETLCAS
SAS Library Concatenation
Explains the concept of SAS library concatenation, allowing several libraries to be logically grouped under a single reference (libref).
Data Access
Examples: Using a SAS Engine to Process External Data
This document provides examples of using SAS engines to access and process various types of external data, including delimited files, Excel files, databases (DBMS), XML, and JSON.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.
This site uses technical and analytical cookies to improve your experience.
Read more.