This category gathers a vast collection of scripts, functions, and utilities designed to solve common technical challenges and automate complex processes. Whether you are working on ETL pipelines, statistical analysis, or application development, you will find ready-to-use solutions for:
String Manipulation & Parsing: Macros to extract words (like LASTWORD), handle delimiters, use Regex, and clean text data efficiently.
System & File Interaction: Utilities to scan directories, manage OS paths, handle file extensions, and interact with external systems (Windows/Unix).
Workflow Automation: Scripts for dynamic variable creation, library auditing (SASAUTOS), and environment initialization.
Data Management & Reporting: Tools for dynamic graph generation, PDF reporting, variable counting, and integrity checks.
Testing & Quality Control: Frameworks for unit testing (SASUnit), assertions, and debugging tools to ensure robust code execution.
Explore these resources to optimize your SAS© environment, reduce code redundancy, and build flexible, high-performance analytical applications.
SAS Macro Programming: How to Extract the Last Word from Any Delimited String
The LASTWORD macro returns the last word from a delimited list of words. This is useful for some generic forms of BY ...
Building Interactive SAS Applications: Using %WINDOW and PROC PMENU for Dynamic Data Reporting
Interactive SAS macro that uses a series of windows to allow the user to specify a data set, variables, and options t...
Auditing the SASAUTOS Library: How to Map and Resolve Macro Autocall Paths
SAS macro to parse the SASAUTOS system option and extract the list of macro search paths.
Stop Copy-Pasting: A Universal SAS Macro to Automate Repetitive List Operation
Function-style macro that allows editing a list of space-delimited items by applying a modification string to each item.
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...
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.
Utility Macro for Truncating a SAS Table
SAS macro that deletes all observations from a table while preserving its structure, indexes, and integrity constraints.
commaparms - Add commas to macro parameters
Function-style macro to reinsert commas between macro parameters in a character string.
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...
Assertion of a Non-Empty Dataset
Generates an event if a specified dataset does not exist or is empty (contains no observations).
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...
Macro _COUNT: Count Elements in a List
A SAS macro that counts and returns the number of individual elements in a list of values.
Macro to check for dataset existence
This macro, _dsexist, returns 1 (true) if a SAS dataset exists and 0 (false) otherwise. It includes specific handling...
Macro to display a dataset
SAS Macro that encapsulates the PROC PRINT procedure to display the content of a dataset with formatting options.
Post-generation analytical graph annotation
Script demonstrating an advanced technique to add custom annotations to a graph generated by an analytical procedure ...
String Analysis Macro
This SAS macro allows you to split a character string into words or phrases according to specified delimiters, and th...
Multiple calls to the parsemacro macro
Execution of the %parsemacro macro on a list of components.
OS Path Variables Management
This macro creates global macro variables to reference operating system directories based on predefined global variab...
Macro to count numeric variables in a dataset
Function-type macro to return the number of numeric variables in a SAS dataset.
Managing Numeric Date Conversions with FCMP
This SAS script demonstrates the creation and use of FCMP functions to convert SAS date values into numeric format (Y...
Macro to Count Variables
SAS Macro to get the number of variables in a specified SAS dataset.
Macro nvars - Number of Variables
Utility macro returning the number of variables in a given SAS table.
Macro to get the number of observations
This macro returns the number of observations for a specified SAS dataset.
SAS Macro for Comma Removal
Functional macro to replace commas with spaces in a character string.
Macro `now` for timestamp
Function-style macro to return the current timestamp.
Utility Macro _version and String Management
Script containing macro utilities for SAS version management and string handling.
NEXT Graphic Configuration Macro
Macro defining global graphic options for the 'nxtcolor' device.
NEXTLPR Printing Macro
Defines a macro to configure the SAS graphical environment for printing via the 'lpr' system command.
mv_jobflow macro test for task orchestration
This SAS script is a comprehensive test case for the `mv_jobflow` macro, a task orchestration tool. It demonstrates d...
Macro Variable Existence Check with Scope
Checks the existence of a SAS macro variable, optionally limiting the search to a specific scope.
Cross-Platform Code Retrieval Macro
Generic macro to retrieve SAS code (Viya jobs, SAS 9 stored processes, or SASjs programs) based on the detected execu...
Macro mcrTwo Call
Invoking macro %mcrTwo with a specific parameter.
Hello World with Macro Variable
Introductory script displaying a personalized message in the SAS log.
SAS Viya Job Code Retrieval Test
Unit test script validating the creation of a SAS Job and the retrieval of its source code using utility macros.
Macro makehash - Hash Object Initialization
In-datastep utility macro to quickly initialize and configure a SAS Hash object.
Macro Maxlengths - Calculation of String Lengths
Utility macro to determine the actual maximum data length contained in character variables of a SAS table.
Company Name Resolution Macro
Macro displaying the full name of a company based on its abbreviation.
WHEROBS Macro - Filtered Observation Count
SAS macro to count the number of observations in a table by applying an optional WHERE filter.
Dynamic Recursive Execution of SAS Files
Macro to include and execute all SAS programs located in a directory and its subdirectories.
Directory Inspection using SAS Macro Functions
Macro script to list and count files in a given directory.
Listvar Macro: Extracting and Sorting Variable Metadata
Utility macro to list SAS table variables and create an output table containing their metadata sorted by position.
Autocall Macros Configuration and Testing
Script illustrating the definition of local macros, modifying the macro search path (sasautos), and calling macros.
Using the IN operator and MINDELIMITER in SAS macros
Example of using the IN operator in a macro with a custom delimiter.
Macro hasvarsc - Checking for presence of character variables
Macro function that returns true (1) if a dataset contains all character variables specified in a given list.
Macro-Variable Manipulation and Arithmetic Operations
Example of using the %LET and %PUT macro statements to define variables and display results.
Dynamic HTML Report Generation via Macros
Set of macros to dynamically generate an HTML page containing links to SAS libraries and system files.
Dynamic Creation of Vertical Macro Variables
Practical exercise to create a vertical list of macro variables during a Data Step execution.
Using Macro Variable Lists for Dynamic Programs
Dynamically creating macro variables from SASHELP.CLASS dataset and displaying them in the SAS log.
CSV Export Macro (ex_csv)
Utility macro to export a SAS table to a CSV file via PROC EXPORT.
Exercise: Dynamic Creation of Macro Variables with PROC SQL
Training exercise aimed at creating a horizontal list of values in a macro variable using PROC SQL's INTO syntax.
Dynamic creation of horizontal macro variable list
Script generating a list of values separated by a tilde (~) into a macro variable from a SAS table.
Macro dirfp2sas: Listing Windows files to SAS table
Utility macro to list full file paths matching a given pattern into a SAS table.
Macro appmvar - Conditional Concatenation of Macro Variables
Function-style macro to append a string to an existing macro variable.
Expected Error Assertion (FUTS Framework)
FUTS test framework utility macro checking if an expected error occurred during execution.
Differential Snapshot of WORK Datasets
Utility macro to identify newly created SAS tables in the WORK library between two steps.
Macro for Retrieving Table Names
Macro generating a list of all datasets present in a given SAS library via a global macro variable.
AHGlibpath Macro - Retrieving the Physical Path of a Library
Utility macro to retrieve the system path associated with a given SAS libref.
AHG Utility Macros for String Manipulation
Definition of three utility macros (AHGstartwith, AHGtestANDcut, AHGmask) for string manipulation and verification. T...
Left-Right Justified Alignment Macro
Utility macro for aligning text left and right over a defined width.
SAS Macro for Left Justification of Text
This SAS macro, named `_lj`, is designed to left-justify text based on the specified line size, handling up to 10 tex...
Macro _NULL: Determining the System's Null Device
This macro provides the null device path (_NULL) adapted to the current operating system (Unix or Windows), allowing ...
Dataset Option Extraction Macro
Utility macro to isolate and return the 'options' part of a SAS dataset name provided as a string.
_pdfjam Macro for Merging PDF Files
This SAS macro uses the external utility 'pdfjam' to merge a main PDF file with a series of sequentially numbered PDF...
Using the Macro Facility to Generate CAS DATA Step Code
This article explains how to use the SAS macro facility to dynamically generate SAS DATA Step code that interacts wit...
String Reversal Macro and Variable Tests
SAS script defining a macro to reverse a character string and performing simple tests to display macro variables.
Comparison of IF vs. WHERE filtering in a macro
Script generating test data and executing a macro to repeatedly compare two filtering methods (IF vs WHERE).
GET Function (Expression Engine Language)
The GET function returns the element at a specified index within an Expression Engine Language (EEL) dynamic array.
Extracting PROC FREQ statistics via text file
SAS macro extracting a specific statistic from PROC FREQ results by redirecting output to a text file and then parsin...
Creating and Testing a SAS Web Service for Object Sending
This SAS script uses macros to create and test a web service named 'sendObj'. The service is designed to return SAS t...
Test of the ms_getusers macro
Unit test script for the ms_getusers macro, validating user extraction and variable scope management.
Test of the ms_deletefile macro
Unit test script to validate the functionality of the ms_deletefile macro.
Macro mp_wait4file - Wait for file availability
Utility macro suspending program execution until a target file appears or a timeout expires.
Recursive Directory Scan
SAS macro that recursively scans a directory tree to list all subfolders and files.
SAS library write speed test macro
This macro evaluates write speed by creating a temporary dataset of a specified size in a SAS library, then measuring...
Workload Generation for Performance Testing
Macro executing a series of SAS processes (Data Step, SQL, Sort, Summary) for a determined duration to simulate syste...
Key-Value Manager in a Dataset
This SAS macro, `%mp_setkeyvalue`, allows storing and managing key-value pairs in a specified SAS dataset. It creates...
Macro mp_perflog - Performance Logging
Utility macro to record performance checkpoints (message, job ID, timestamp) in a SAS table.
Generating an MD5 hash expression
SAS macro to generate an MD5 hash expression for a set of character and numeric variables, intended for use in a DATA...
Table Locking Mechanism Test via Macros
This script is a test program for a SAS table locking macro system. It verifies the creation of a control table, tabl...
Generating DDL for a SAS table
Wrapper macro to generate the DDL (Data Definition Language) for a specific SAS table, allowing the specification of ...
Test of the mp_ds2cards and mp_assert macros
This SAS script tests the functionality of the `mp_ds2cards` macro, which converts a SAS dataset into `DATALINES/CARD...
SAS Macro mp_dropmembers
Macro to delete SAS tables and views without generating warnings in the log. Useful for conditional deletion or multi...
Extraction of Formatted Distinct Values
This macro extracts formatted distinct values of a specific variable from a SAS dataset.
Macro to create SQL dictionary views
This macro dynamically creates views in a specified SAS library (default WORK) for all entries in SAS SQL dictionary ...
Managing Core SASjs Tables (mp_coretable)
Centralized management macro for defining permanent tables (DDL) of the sasjs/core library.
Test of the `dostuff` macro with `mp_assertscope`
This script tests a macro named `dostuff` that manipulates global macro variables. It uses the test macros `mp_assert...
Binary File Concatenation
Macro to concatenate the content of multiple files in binary mode.
Get the last modification date of a dataset
Function-type macro that returns the date and time of the last modification of a SAS dataset, with a formatting option.
Retrieve Metadata Objects (mm_getobjects)
Macro to retrieve a list of objects of a specific type from the SAS metadata server (SAS 9 legacy).
Recursive directory creation macro
SAS macro to recursively create directories on the operating system.
Macro %mixcase for mixed case text formatting
SAS macro to convert a character string to mixed case, capitalizing the first letter of each word and handling specia...
Annotation Macro for Missing Data
This macro generates an annotation dataset to visualize observations with missing values for X or Y variables in a sc...
Min_Member_Length Macro
This macro takes a delimited list and returns the minimum length of any member in that list.
Checking for SASHDAT file existence in CAS
Macro checking if a .sashdat format table exists in a specified CAS library.
Macro for writing a text file
This macro allows creating or appending content to a text file using only SAS macro functions. It can write up to 10 ...
Macro for extracting unique words between two strings
This SAS macro compares two space-separated character strings and returns the words present in the first string (`Str...
Extract common words from two strings
SAS macro to identify and return common words from two space-separated character strings.
Macro Variable Verification (mf_verifymacvars)
Checks if a set of macro variables exist and contain non-empty values.
Removing Trailing Characters from String
SAS macro to remove a specific trailing string from another string if present.
Getting the format of a SAS variable
SAS macro that returns the format of a specified variable from a SAS dataset (table or view). It can also assign a de...
Test of the mf_getvarcount macro
Unit test script verifying variable counting in a SAS table via the mf_getvarcount macro.
Unique Fileref Generation
SAS macro that assigns and returns an unused temporary fileref, circumventing issues with native fileref recognition ...
Extract SAS Format Name
Macro to extract the base name of a SAS format, ignoring its length and decimals.
Get the SAS library engine type
This macro returns the engine type of a specified SAS library.
Dynamic determination of an application's root location
SAS macro to dynamically identify the root path (appLoc) of a SASjs application in the SAS logical folder tree.
DateTime Format Selection (mf_fmtdttm)
Macro determining the optimal date/time format (E8601DT26.6 or DATETIME19.3) based on the SAS environment version to ...
mf_existfunction Macro
Checks the existence of a specific SAS function.
Checking for variable existence in a dataset (mf_existvarlist)
This macro checks if all variables specified in 'varlist' exist in a given SAS dataset referenced by 'libds'. It retu...
String Deduplication
Macro to remove duplicates from a string based on a specified delimiter.
Detecting Maximum Indices of Titles and Footnotes
Utility macro to identify the highest numbers used for titles and footnotes in the current SAS session.
Loading Macro Library from GitHub
Initialization script that dynamically downloads and compiles a suite of SAS macros from a public GitHub repository.
Macro Marvel Messages
SAS macro displaying superhero quotes in the log.
Markcode Macro - Interactive Execution and Visualization (Legacy)
Utility macro designed for classic interactive SAS environments (Display Manager) to submit buffer code and open the ...
Macro markdsn - Interactive table opening
Utility macro designed to open a SAS table (dataset) whose name is stored in the system clipboard. Uses interactive c...
Creating and Assigning a Temporary Library
This macro checks for the existence of the 'c:\tempwork' directory and creates it if necessary on a Windows system, t...
SDTM Date Creation --DTC
This SAS macro generates an SDTM-formatted date variable (--DTC) from date and time components provided as separate S...
Macro Variable Manipulation and Data Creation
This SAS script demonstrates the creation of an internal dataset and the use of various macro functions to manipulate...
Path Test Macro
Analysis and demonstration of using the %SYSFUNC(DEQUOTE) macro to handle character strings with or without quotes.
Print and Frequency Test Macro
This SAS script defines a global macro variable and a macro to display version information and execute a simple frequ...
Deletion of compiled macros
Utility macro to delete compiled macros from the current session (WORK library).
Sans titre
Provides a %mabbrev macro-function that mimics REXX's 'abbrev' function, allowing to check if one string is a valid a...
Generic Utility Macro m_utl_xxx
Utility macro for a generic function. Provides a brief and detailed description of the macro's function.
m_val_xxx Validation Macro Skeleton
Basic structure for a validation macro with integrated Doxygen documentation.
m_uc_xxx Macro Definition Template
This file is a standardized template for creating SAS macros, including a detailed documentation structure.
Logging Macro m_log_xxx
SAS macro skeleton for logging, containing only the definition structure and documentation.
Generic header macro m_hdr_xxx
Standardized header macro for SAS scripts, facilitating documentation and parameter management such as help and debug...
Macro template m_cst_xxx
Definition skeleton for a custom SAS macro, including standardized header documentation.
Interactive Input via Macro Window (Legacy)
Defines and attempts to display a textual interactive window for parameter input.
SAS CALC Macro for Descriptive Analysis
This SAS macro, named CALC, validates variables in a specified dataset and executes the PROC MEANS procedure on valid...
SAS Variable Name Cleaning and Normalization
This SAS script illustrates three implementations of a '%fixname' macro, whose objective is to clean and normalize ch...
Simple Conditional Macro
This SAS script defines and uses a simple macro that takes a parameter and displays a corresponding company name base...
Company Name Display Macro
This SAS macro displays the full name of a company based on an abbreviation provided as a parameter in the SAS log.
Company Greeting Macro
This macro displays a company name or a generic phrase in the SAS log based on the provided argument.
Secure extraction of the first character of a macro variable with %SUPERQ
Demonstrates the importance of the %SUPERQ macro function for manipulating strings containing special characters in t...
Conditional State WHERE Macro
Defines and executes a SAS macro that determines a geographic region (Southeast, Northwest, Unknown) based on a US st...
Defining and calling the where macro
Definition of a simple macro using conditional logic to display a geographical region in the log based on a state code.
Handling special characters in macros
Example of using the quoting functions %STR and %NRSTR.
Managing space delimiter in %QSCAN
Illustration of using the %str function to define a space as a delimiter in the %qscan macro function.
Name Processing Macro
This script defines and uses a SAS macro to reorder a full name (format 'Last Name, First Name') into 'First Name Las...
Name Reordering Macro
SAS macro to reorder a full name (Last Name, First Name) to First Name Last Name.
String manipulation macro
This SAS macro takes a full name (in 'Last Name, First Name' format) as input, reverses the order to display 'First N...
Name extraction and reformatting
This script defines and calls a SAS macro to extract the first name and last name from a 'Last Name, First Name' form...
String Manipulation with %SCAN Macro
This SAS script defines and executes a macro that manipulates a full name string (format 'Last Name, First Name') to ...
Name Reorganization Macro
This SAS script defines a macro to reorganize a full name provided as 'Last Name, First Name' into 'First Name Last N...
Macro Deletion with %SYSMACDELETE
Illustration of deleting a macro definition and subsequent call attempt.
Analysis of the SAS Macro Catalog
This SAS script examines system options related to macro storage and lists the contents of a specific macro catalog f...
lsfp2sas Macro - Listing Unix/Linux files into SAS
Utility macro for listing Unix/Linux files matching a specific pattern and storing this list in a SAS table.
List files with full path (Unix)
Function-type macro that returns the list of files in a directory on a Unix system, with their full path and enclosed...
lscmd Macro - List files in a Unix directory
Function-style macro returning the list of members in a Unix directory via the 'ls -1' command.
Ljustify Macro
SAS macro to left-justify all character variables in a dataset.
SAS Macro Testing and Management
This script demonstrates the use of the %listmacro macro to inspect and manage SAS macros, integrating assertions to ...
SAS File Listing Macro
This script contains a SAS macro to list files in a given directory, including its subdirectories, with an option to ...
list2format Macro
Creates a SAS numeric format based on a list of values provided as a parameter.
Test of the _mkDir macro-program
This script is a SASUnit unit test for the _mkDir macro-program, which is used to create directories on the file system.
Macro _MIN: Find the Minimum
SAS macro that determines the minimum between two expressions, similar to the MIN() function of the DATA STEP, by han...
Macro _MAX for Maximum
This macro implements a function similar to the DATA STEP's MAX() function, returning the maximum of two arguments or...
Macro _LS for LINESIZE
Utility macro to retrieve the value of the SAS system option 'LINESIZE'.
Macro _LIB for extracting library name
This macro extracts the SAS library name from a full data set reference, or returns 'work' by default if none is spec...
Utility Macros for Data Analysis and SAS Metadata Manipulation
This script provides a set of three SAS macros. The 'DissGraphMakerLogOdds' macro performs in-depth data analysis, in...
Example of Data Creation and Conditional Macro
This SAS script illustrates the internal creation of datasets via DATA STEP and the definition/call of a macro includ...
Log Formatting and Time Tracking Macro
Utility macro to generate clean and framed log messages, including execution time calculation and timeout alerts.
Creating a left-aligned title
SAS macro to generate a left-aligned report title.
Lafootnote Macro
Creates a left-aligned footnote in SAS outputs.
Macro Variable Management
This SAS script illustrates the declaration, assignment, and display of macro variables.
Functional macro for ISO 8601 format
This functional macro generates a character string in ISO 8601 format (YYYY-MM-DDTHH:MM:SS) from two numeric SAS vari...
Definition of ISO formats for date and time
This SAS macro defines custom formats for dates and times according to the ISO 8601 standard, specifically handling t...
Macro addvar - Text variable splitting
SAS macro designed to manage and split text variables exceeding a specified maximum length (default 200 characters).
Macro jjqcclean - Cleaning the working environment
Utility macro to clear the WORK library and reset the DOMAIN variable.
Generation of a Delimited List of Numbers
Macro to create a delimited list of integers.
SAS Name Validity Check
Functional macro to check if a character string is a valid SAS name according to naming rules.
Extract ISO 8601 Date Part
Function-style macro to extract the date part from an ISO 8601 standard datetime text value.
Creating macro variables with leading zeros via PROC SQL
Script generating a series of numbered macro variables (name01 to name19) from the data in the SASHELP.CLASS table.
Issue a Warning Message via Log4SAS
Utility macro to send a warning message to a specified Log4SAS logger.
Utility Macro _LAST
Generates a logical expression to identify the last observation of a BY group or the last global observation of a dat...
Issuing fatal message via log4sas
SAS macro to issue a FATAL level message to a specified log4sas logger.
LOG4SAS Information Message Emission Macro
This SAS macro emits an informational message to a specified LOG4SAS logger, including parameter validity checks.
Macro to issue a trace message
This SAS macro issues a trace message to a specific logger using the `log4sas_logevent` function of the SASUnit frame...
Issues an error message in an 'assert' to a logger
Issues an error message within an assertion to a logger.
Assertion Log4SAS information message
Emits an assertion information message to a logger.
Warning Macro for SASUnit Assertion
This internal SASUnit macro emits a warning message via a logger, specifically during an assertion within the log4sas...
SAS Macro Definition and Verification
This script illustrates the definition of a simple SAS macro and the verification of its registration in the temporar...
Using %EVAL and %SYSEVALF Functions
Demonstrates the use of the %EVAL and %SYSEVALF macro functions to perform arithmetic calculations on macro variables...
Using the %INDEX macro function
This SAS script illustrates the use of the %INDEX macro function to search for a substring within a string, and highl...
Using the %SYSEVALF Macro Function
This SAS script demonstrates the use of the %SYSEVALF macro function to evaluate arithmetic and logical expressions, ...
Definition of the Prtlast macro
This script defines a utility macro named %prtlast that displays data from the most recently created table in the SAS...
Using the IFC macro function for OS detection
Example of using the `ifc` function via `%sysfunc` to execute immediate conditional logic in the macro language.
Macro Import - Dependency Management
Fundamental utility macro for intelligent import and dependency management of SAS macro files.
Graphic Resizing Macro
SAS macro to resize graphic parameters (size and position) while maintaining the aspect ratio of the cells.
Variable verification in a dataset
This function-type macro returns '1' if a dataset contains all variables specified in a user-provided list, and '0' o...
Search and Navigation Method for VIEWTABLE
This method, designed for use within a VIEWTABLE class (SAS/AF), intercepts commands to search for values in columns ...
Greenbar style macro for ODS
This macro implements a 'greenbar' effect (alternating colored rows) to improve the readability of reports generated ...
Verification of global macro variable existence
Function-style macro that returns 'true' (1) if all specified global macro variables exist in the SAS environment.
List of Global Macro Variables
This function-style macro returns a list of the names of current SAS global macro variables.
Extracting and Managing ODS Styles
This SAS script extracts the list of available ODS styles, exports them to Excel, then re-imports them to generate in...
GHI macro definition
Definition of a simple macro displaying a message in the log to verify autocall.
Git Repository Installation and Loading Macros
Two macros to clone a Git/GitHub repository and automatically load the contained SAS macros.
SAS Code Inclusion Macro from GitHub
This SAS macro allows the inclusion and execution of SAS code files stored in a specified GitHub repository, thereby ...
Delete entries from a graphics catalog
The GKILL macro deletes entries from a graphics catalog. This is useful when PROC GREPLAY is used repeatedly in a sin...
Retrieving Autocall Paths (SASAUTOS)
Utility macro to extract the autocall path configuration (SASAUTOS).
Utility Macros and SAS Version Check
This SAS script bundles the definition of several macros: a wrapper macro for group management, a SAS version check m...
Getpath Macro - File Inclusion Manager
Utility macro for dynamic file path resolution and conditional inclusion.
File Extension Extraction Macro
Utility macro returning the extension of a file from its path.
Extracting the Base Path of a File
Utility macro to extract the path of a file without its name or extension.
Extract file name without extension
Utility macro to extract a file's name without its extension from a full path.
Macro to list dataset variables
This SAS macro provides a fast and purely macro-based method to get a list of variable names from a specified dataset...
Macro _INDEXC
This macro implements a functionality similar to the DATASTEP INDEXC function, searching for the first occurrence of ...
Macro _INDEXW: Word Search in a String
SAS Macro encapsulating the DATASTEP INDEXW() function to find the position of a word within a character string.
Get File Extension
Gets the extension of a given filename, including the separator dot.
Macro _getPgmDesc - Documentation Extraction
SASUnit utility macro designed to extract the short description of a SAS program from Doxygen (brief) tags present in...
Utility Macro _IFELSE
Utility macro implementing ternary conditional logic (If-Then-Else).
Extract variable metadata and export to Excel
This SAS macro extracts detailed variable metadata (name, type, length, format) for one or more datasets specified in...
Macro GetProgramName - Retrieving Program Path
Utility macro returning the full path and name of the currently executing SAS program.
Data Creation and Retrieval of Observation Count
Script creating a test dataset and storing its observation count in a macro variable.
SAS Unit Test Template
Code skeleton for writing unit tests.
SQL Logical Condition Generator
Utility macro to generate a string of logical conditions (WHERE clause) from lists of columns and values.
GenFmt Macro: Dynamic Format Generation (Legacy)
Old macro generating a SAS format from a data table by writing the format code to an external file.
Dynamic column width calculation for export
Utility script analyzing metadata and content of the SASHELP.CLASS table to determine maximum variable and data lengt...
Aligned Text Formatting Macro
Utility macro to build a line of text with elements aligned to the left, center, and right.
FORMCHAR Macro for Formatting Character Management
SAS Macro to configure the FORMCHAR system option, allowing selection between standard characters or line drawing cha...
Begin and End of Month Functions (BeginMonth, EndMonth)
This SAS script defines two custom FCMP functions, BeginMonth and EndMonth, to determine the first and last day of th...
fixlen Macro: Numeric String Length Adjustment
Macro to adjust a character string (representing a number) to a fixed length for display purposes.
Documentation Generation via Code Diary
Configuration and execution script for the `%code_diary` macro to automatically generate technical documentation from...
Retrieving the format search path (fmtsearch)
Function macro that returns the complete and normalized list of format catalogs defined in the fmtsearch option.
Utility macro for managing the FMTSEARCH option
Checks for the presence of a library in the FMTSEARCH option and adds it if specified.
FILEREF Existence Check
This macro checks if a SAS fileref has been assigned and if the associated external file exists, returning a numeric ...
FIND_WORD Utility Macro
Macro function returning the ordinal position (nth word) of a specific word in a sentence.
Macro for calling the FIND method of a hash object
This SAS macro, designed for use within a DATA STEP, encapsulates the call to the FIND method of a hash object. It fa...
Factorial Calculation with PROC FCMP
Script defining and using custom functions for factorial calculation via PROC FCMP.
SAS Macro for Capturing and Displaying a Log Section
This SAS macro allows capturing a specific section of the SAS log (from a specified marker to the end of the log), sa...
Conditional Code Deactivation via Macro Variables
Technique for dynamically activating or deactivating a SAS code block using macro variables to generate comment tags.
Interaction Expansion Macro (Bar Operator)
Set of macros simulating the bar operator '|' used in statistical procedures to automatically generate main effects a...
GLM Formula Expansion Macros
Set of SAS macros to expand linear model specifications (vertical bar notation) into a full list of terms and interac...
Unit test of the _getAbsPathComponents macro
Unit test script for the _getAbsPathComponents macro, validating the extraction of the filename and parent path from ...
Search for program in autocall libraries
Searches for a specific program file in autocall libraries and returns the identifier of the library where it was found.
Test of the _getAutocallNumber macro
Unit test script for the _getAutocallNumber macro verifying the resolution of macro search paths (autocall).
Searching for .html/.htm endings with regular expressions
This SAS script uses regular expression (PRX) functions to detect if character strings end with '.html' or '.htm'. It...
SAS _FILE Macro to remove quotes
This SAS script defines a `%_file` macro that takes a character string as an argument and removes single or double qu...
Macro _FINFO - Extended File Information
Utility macro to retrieve detailed file information (date, permissions, size) via a system command.
Utility Macro _FIRST
Generates a SAS logical expression to identify the first observation of a BY group or the first general observation i...
File Variable Initialization (_FN)
Macro determining the name and path of the currently executing SAS program to initialize global output variables.
Test of the _executeCmdFile macro
Unit test script for the SASUnit _executeCmdFile macro.
Macro _EXIST - File Existence Check
Simple SAS macro to check for the existence of a file or directory on the file system.
Directory Existence Check
SAS macro to check if a given directory exists and is accessible.
Checks for the existence of a variable in a dataset
Macro-function that checks if a variable, with an optional type, exists in a SAS dataset.
Simple Inclusion Macro
This script defines a simple SAS macro that displays a message in the log when called.
OS Command File Execution
Executes an operating system command file via a SAS macro.
SAS Macro for the Number of Observations in a Table
This utility macro returns the number of observations in a SAS dataset specified by its identifier (DSID).
Using SAS Macro Variable Lists to Create Dynamic Data-Driven Programs
This SAS script is designed to extract student names from the SASHELP.CLASS dataset, concatenate them into a tilde-se...
Dynamic data segmentation via vertical macro variables
Script using a macro to dynamically divide the SASHELP.CARS table into several sub-tables based on the unique values ...
Creating a list of macro variables with PROC SQL
Exercise showing how to dynamically create a horizontal list of macro variables with PROC SQL.
Using SAS Macro Variable Lists to Create Dynamic Data-Driven Programs
Creates a simple macro variable at runtime using the SQL procedure to extract the weight of a specific vehicle.
Dynamic Macro-Variable Creation with PROC SQL
Exercise to create a macro-variable at runtime using the PROC SQL INTO clause.
Using SAS macro variable lists to create dynamic data-driven programs
Creating a macro variable at runtime from the DATA step.
Dynamic creation of macro variables via Data Step (Exercise 01)
Practical exercise aimed at creating a macro variable at runtime using a Data Step.
ETL Verification and Process Abort
Utility macro to check system return codes (SYSCC) and SQL return codes (SQLRC) and abort the SAS process in case of ...
equals.sas
Function-style macro for DATA STEP to compare two numerical values and determine if they are equal or very close.
Macro %EQUESUFF to suffix a list of words with an equal sign
This function-style macro adds an equal sign to the end of each element in a list of words or variables, primarily to...
Wrapper for Windows 7 environment variables extraction
Macro wrapper to save Windows 7 environment variables into a SAS table.
Macro to ensure a string ends with a specific character
Function-style macro that ensures a non-null value assigned to a macro variable ends with a specified character.
env2sas
Macro to write system and user environment variables to a SAS table.
Remote Submission End Macro
Utility macro to end a remote submission and close the session if a connection is defined.
Macro to draw an ellipse
This SAS macro generates the coordinates for drawing an ellipse, taking into account the center, axis lengths, tilt, ...
Macro eanend - Enhanced Analysis Shutdown
Utility macro used to terminate an analysis or debugging session (probably initiated by a corresponding 'eanbegin' ma...
Macro %Dups for duplicate management
Utility macro to identify duplicates and isolate unique records in a SAS table.
Generate a date scale for SAS/GRAPH
SAS macro to generate the start, end and step values for a date scale intended for SAS/GRAPH, based on a minimum, max...
Macro _escapeblanks (Escaping blanks)
Documented macro to escape blanks with backslashes under Linux/AIX, although the current implementation does not modi...
Automated Data Comparison Macro
Defines and uses an '%autocompare' macro to compare two datasets, identify differences, and present them in a readabl...
Trace the location of an autocall macro
This script configures autocall macro libraries in SAS and demonstrates the use of a built-in macro (%obscnt) to coun...
Dynamic creation of macro variables using SYMPUTX
This script illustrates the use of the CALL SYMPUTX routine to create macro variables whose names are dynamically det...
dsall.sas - Dataset List Expansion
Utility macro to expand the _ALL_ notation in a dataset list into all datasets present in the specified SAS libraries...
dsc_echofile_tolog Macro
Utility macro to display the content of external files (via filerefs) directly in the SAS log.
Wrapper Macro for DOSUBL
A utility macro for executing SAS code via the DOSUBL function.
Dquote Macro: Adding Double Quotes
Utility macro to enclose a character string in double quotes while protecting special characters.
Macro dropmodifiers
Utility macro to use in a Data Step to remove modifiers (dataset options) from a variable containing table names.
Dropvars Macro
Utility macro to delete a list of unwanted variables from one or more SAS datasets.
Directory Existence Check
SAS macro to check if a specified path corresponds to an existing directory.
dirfp2ds
Lists full path (Windows) filenames into a SAS dataset.
Macro dirfpq - List of files with full path (Windows)
Macro returning a list of files from a Windows directory with their full paths, based on a specified pattern.
Count the number of observations in a dataset
SAS macro-function to determine the number of observations in a specified dataset.
List files from a directory into a SAS dataset
SAS macro to list file names from a specified directory (via a pattern) into a SAS dataset.
List Directory Content
Function-type macro that returns the list of members in a directory on a WINDOWS platform.
String Dequoting
Function-style macro to remove matching quotes at the beginning and end of a macro string and return the result.
Error Return Code Management
SAS macro to capture and propagate the highest error code encountered during the execution of an ETL process or similar.
Macro deleteSasmacN - Cleaning numbered SASMAC catalogs
Macro deleting all numbered 'sasmacr#' catalogs in the WORK library, without deleting the main 'sasmacr' catalog.
Delete entries from a graphics catalog
This macro deletes specific entries or all entries from a SAS graphics catalog.
Macro Variable Existence Check (Defined)
Macro checking if a macro variable is defined in the global environment.
Macro variable existence check (defined)
Macro function that determines if a specific macro variable is defined in the global environment.
Macro _DIRCHAR for directory character
This macro returns the appropriate directory separator character for the operating system.
DROPMISS Macro - Deleting Empty Variables
SAS macro to delete variables from a table that contain no data (only missing values).
Deletion of Temporary Datasets
Utility macro to delete specific temporary datasets (starting with 'DATA') from the WORK library.
DeBlackHole Debug Macro
Utility macro designed to reset the SAS interpreter in case of persistent syntax errors (open quotes, unclosed commen...
DBMSlist Macro - Batch Database Querying
SAS macro designed to query a relational database using values from a SAS dataset as filtering criteria, processed in...
SAS Table Existence Assertion Macro
Utility macro used in unit tests to verify the existence (or non-existence) of a given SAS table and raise an asserti...
Temporary File Name Generation
Macro to create a unique temporary file name in a specific folder.
Dynamic CSV export macro csv_vnext
Utility macro to export a SAS dataset to a delimited file (CSV) using a DATA _NULL_ step and the CALL VNEXT routine t...
SAS Macro for Centered Title with Form Feed
This SAS macro creates a centered page title and adds a form feed character at the far right (FFx).
Numeric variable categorization macro (cut)
This SAS macro categorizes a numeric variable into user-defined classes (bins). It creates a new variable containing ...
Space Cleaning Command Macro
Command-type macro to replace multiple spaces with single spaces.
Test Macro for Cross-Referencing
Test macro designed to demonstrate and validate the cross-referencing functionality of macro calls within the SASUnit...
Cross-reference Test Macro
This SAS macro, named 'CrossReferenceTest2', is a component of the SASUnit test framework. It creates a temporary dat...
Test macro for cross-referencing
Simple test macro to demonstrate cross-referencing and numerical parameter evaluation.
Creation of EXA Test Data Table
Macro to create the EXA test database table for the SASUnit framework.
TSU Test Data Table Creation Macro
SAS macro to create a test data table named 'tsu' in a specified library. This table is used to store test parameters...
Pre-processing macro for a unit test
This macro prepares the environment for test execution. It cleans up previous test artifacts, inventories existing ma...
Creation of the test database
Creates a test database for the SASUnit framework.
Creation of the SASUnit test case table
Macro creating the 'cas' table intended to store test case metadata and results within the SASUnit framework.
Code Diary Documentation Generation
Script for configuring and executing the generation of technical documentation from SAS code.
String List Formatting Utility (CQUOTE)
Converts a space-separated list of values into a comma-separated quoted list.
List Conversion and Formatting Macro
This utility macro converts a list of elements (provided as a delimited string) into a new formatted list. It offers ...
Macro %compress for string management
This SAS macro encapsulates the COMPRESS function to remove specified characters from a text string, with error handl...
Colnames Macro: List Variables (R-style)
Utility macro simulating R's colnames() function to list variables of a SAS table located in the WORK library.
Macro to replace the last comma with ' and '
This macro replaces the last occurrence of the sequence ', ' (comma-space) with ' and ' in a given character string, ...
Global Test Execution
This script initializes the environment via autoexec and launches all tests defined by the %test macro.
Macro assertTrue - Check if a condition is true
SASUNIT Macro to evaluate a condition and assert that it is true, handling numeric and character types.
cmd2sas Macro
SAS macro to execute a local system command and write its output to a data set.
Macro Management and Exploration via SAS Catalog
This SAS script defines, stores, copies, and lists macros contained within a SAS macro catalog.
Simple Macro Definition and Call
This SAS script defines a simple macro named 'test' that creates an empty dataset 'test'. The macro is then called. I...
Numeric String Alignment Macro
SAS macro to vertically align character variables representing numbers based on separators (dot, comma, parenthesis).
Variable Reordering / Selection Macro
Main SAS macro (`%chn_dt_ordvar`) designed to reorder a dataset by placing a specified set of variables at the beginn...
Token Counting Macro
This SAS macro counts the number of tokens (words) in a given string, using a specified delimiter.
Execution and Reporting Pilot Script (Chapter 8)
Orchestrator script that cleans the environment, loads a series of external SAS programs, and defines a reporting macro.
Autocall Library Verification
Simple macro to verify the proper functioning of the autocall library by writing a message to the log window.
Macros for Canonical Naming and Versioning Management
Script defining utility macros for normalizing names via handlers and checking SAS version.
Case Replacement Macro
Function-style macro to force the case of a specific substring within a source string.
CAT Macro: Concatenation of Variable Values
This SAS macro concatenates the values of a list of variables into a single output variable, using a specified separa...
Macro for dynamic macro re-execution with dataset parameters
This macro allows repeated execution of another macro by passing parameters dynamically read from a dataset. It overc...
Documentation Automation with Code Diary
Configuration and execution script to generate SAS project documentation in Markdown and HTML format.
Graphic Shape Drawing Macros (Brackets, Arcs, Lines)
This SAS script defines three utility macros (%bracket, %arcpie, %line) to facilitate the drawing of basic graphic sh...
Test macro with log display
Defines a simple macro that writes the value of its parameter to the SAS log and configures log display options.
Remove the last BY title and store it in a macro variable
Macro to remove the last title if it's a title generated by a 'BY' clause and store its content in the global macro v...
Deletion of macro variables and macros
Macro for deleting macro variables (potentially macro variable arrays) and, optionally, compiled macros from the WORK...
Macro boxanno - Scatter plot annotation with box plots
Set of macros (boxaxis and boxanno) to create annotation datasets for adding univariate box plots to the axes of a sc...
Creation of Base Datasets
This SAS script defines a `%basedatasets` macro that creates three temporary datasets (Customer, Contracts, CustomerC...
Retrieve a numeric attribute from a dataset
Macro-function to retrieve the value of a numeric attribute from a SAS dataset (e.g., number of observations or creat...
Retrieve a numeric attribute from a dataset
Macro-function to retrieve a numeric attribute from a SAS dataset, such as the number of observations (NOBS) or the m...
Macro assert_not_exist - Table non-existence assertion
Test macro generating an event if a specified SAS table exists.
Macro assert_not_fileexist - Assertion for file absence
Generates an event if a specified file exists, used to validate that a file should not be present.
Macro assert_not_null - Non-Nullity Assertion
Test utility macro generating an event if the specified argument is null or has zero length.
Macro assert_not_zero - Non-nullity Assertion
Generates an event (error/alert) if the argument value is equal to zero.
Macro assert_null - Non-null value assertion
Test macro checking if an argument is not null and generating an event accordingly.
Macro assert_zero - Null Value Assertion
Unit test macro checking if a given value is equal to zero and generating an event in case of failure.
assertManual Macro
SAS Macro for handling manual assertions in the SASUnit testing framework.
Macro assert_exist - Table existence verification
Unit test macro verifying the existence of a SAS table and generating an event in case of failure.
Sans titre
Unit test macro verifying the presence of a physical file and generating an event if it is absent.
Substring Extraction After Target Character
SAS functional macro to extract the part of a string located after the first occurrence of a target character.
Allocation Macro for Read-Only Libraries (allocr)
Example macro to allocate data and format libraries in read-only mode for a specific clinical study (Spectre Clinical).
AHGwt Macro - Writing to a file
Utility macro to write a specific character string to a text file.
AHGzero Macro for Numeric Formatting
This macro formats a given number into a character string of a specified length, using the %SYSFUNC(PUTN()) function.
Formatting Macro for Clipboard
SAS Macro to read clipboard content, format it, and save it to a text file for Microsoft Word.
Decimal Point Alignment Macro (aligndp.sas)
This SAS macro, designed for use in a DATA step, formats a numeric variable into a character variable by aligning dec...
Macro allafter
This function-style macro returns the part of a character string that follows the first occurrence of a given target ...
AHGwhere Utility Macro
Macro systematically returning the value 1, likely acting as an 'always true' condition.
Operating System Detection (Windows/Unix)
Utility macro to determine if the SAS execution environment is Windows or Unix.
Windows Temporary Path Macro
Macro defining a Windows-specific temporary directory path.
Word Relationship Management
This SAS macro manages word relationships by storing and deduplicating them in a SAS table 'allstd.wordtowords'.
AHGuncompress Macro - Character Retention
Utility macro that allows retaining only specified characters in a text string, acting as a positive filter.
AHGuseLabel Macro - Variable Renaming by Label
This SAS macro allows renaming variables in a dataset using their label as the basis for the new variable name. It in...
User Path Definition Macro
Defines a macro that returns a network path specific to the current user.
AHGsome Utility Macro
Defines a utility macro called AHGsome, which checks if a given character string is not empty using the internal macr...
AHGsubsetdsn In-place Filtering Macro
SAS macro to filter an existing dataset, replacing it with a subset based on a globally provided condition.
String Normalization Macro AHGtabnoStr
Utility macro to replace dots and spaces with underscores in a character string.
AHGtag Macro
Utility macro for generating simple HTML or XML tags.
AHGscanxy Macro for Substring Extraction
This utility macro extracts a specific element from a character string using coordinate-based (x, y) scanning logic.
AHGsetprint Macro: Merging and Formatting SAS Tables
Macro for combining (stacking) multiple SAS tables while standardizing variables to character format for easier displ...
Definition of the AHGshortpath macro
Definition of a SAS macro named AHGshortpath. Currently empty.
Macro AHGRTFtotxt - RTF Conversion and Parsing
Utility macro designed to convert an RTF file into a flat text file or a SAS dataset. It cleans RTF formatting tags a...
RTF to Text File Conversion
SAS macro to convert an RTF file to a plain text file by cleaning up formatting tags.
Macro to configure Autocall macro paths
SAS macro that dynamically configures the SASAUTOS system option to define autocall macro search paths based on the e...
Definition of the AHGsavecommandline macro
Definition of an empty SAS macro with parameters.
AHGsavedsn Macro - Table backup with suffix
Macro for duplicating a SAS table by adding a suffix to the output table name.
Nested String Parsing Macro
Utility macro for extracting substrings from a string with nested delimiters.
Random String Generation
This SAS macro generates a random string of uppercase letters (from A to X) of a specified length. It can be used to ...
AHGprocMeansBy Macro - Statistics by segments
Utility macro to calculate statistics on data segments (defined by a 'by' variable) and consolidate the results.
PROC PRINT Macro for Printing
This macro simplifies the use of PROC PRINT for printing datasets.
AHGPtoL Display Macro
Simple macro displaying the content of a parameter in the SAS log.
SAS Pure Table Name Extraction (AHGpureName Macro)
Utility macro to extract the root name of a SAS table, ignoring dataset options (such as WHERE or KEEP/DROP filters i...
ahgputc Macro: INPUT Conversion with Default Format
Utility macro applying the INPUT function to a variable with automatic default format management.
Format application macro and left alignment
Utility macro to format a variable and left-align the result.
Macro _begin for IN: operator
SAS _begin macro that generates a list of items for the IN: operator, designed to replace the %_in macro and handle c...
Macro _BIN: Generating IN Operators
Utility macro designed to generate lists of values for the IN() operator in a more robust way than %_IN().
Analysis of the _BY macro
This SAS macro, named _BY, is designed to dynamically manipulate the list of variables used in a BY statement. It int...
Change Directory (OS-independent)
SAS macro to change the current directory in an OS-independent manner (Unix/Windows).
Runtime Environment Verification (_checkRunEnvironment)
Validation macro checking if the operating system and SAS version are supported.
Counting Subjects by Treatment Group
This SAS program generates the count of unique subjects per treatment group from an adsl dataset, using dummy treatme...
Extracting the first element of a string with %SCAN
This SAS script demonstrates the use of the %SCAN macro function to extract the first element of a comma-delimited st...
get_append_base Macro for Structure Generation
Macro displaying in the log the SAS code to recreate the structure (formats) of a given table.
Data Preparation for EM5BATCH
This SAS script prepares the 'workspace' and 'actions' datasets, which are used as input parameters for the '%em5batc...
Macro AHGNum2date - Numeric Date Formatting
Utility macro to convert a SAS numeric value (representing a date) into a formatted character string.
Windows Operating System Check
This macro checks if the operating system is Windows.
AHGopenby Macro - Automated File Opening
Utility macro for searching and opening (or listing) files matching a specific mask in predefined folders based on th...
AHGppt Utility Macro
Utility macro to assign a string and generate output in a DATA step.
SAS Table Merge Macro (AHGmergedsn)
Utility macro to merge two SAS tables with automatic sorting and join type management (Left, Right, Full, Matched).
AHGnonblank Macro - Non-empty String Check
Utility macro returning the logical inverse of the %AHGblank macro.
Server Detection Macro
Checks for the presence of the string 'sddsrv' in the server's hostname.
AHGLIKE Macro for Word Filtering
This macro allows filtering words from a character string by comparing each word (after removing digits) to a given w...
Macro AHGlinebyline: Vertical display of words
Utility macro displaying each word from a provided list of parameters on a distinct line in the log.
Macro for local macro variable creation
Definition of a utility macro to create a local macro variable whose name and value are passed as parameters.
Macro AHGlocf - LOCF Imputation
SAS macro designed to implement a 'Last Observation Carried Forward' (LOCF) logic by generating an additional observa...
AHGkill Macro for Deleting SAS Datasets
SAS macro to delete one or more specified datasets from a SAS library. It can target specific datasets or all dataset...
AHGlibname Macro - Libref Extraction
Utility macro to extract the library name (libref) from a SAS table name.
Font size configuration macro
Defines a macro to adjust font size and other display options.
AHGforceFormat Macro - Forced variable formatting
Utility macro to modify the length and format of specific variables in a SAS table based on definitions stored in ext...
Macro to get the number of observations in a table
This macro retrieves the number of observations (nobs) of a SAS table specified by its library and table name paramet...
Definition of macro AHGgetTempVname
Definition of an empty SAS macro named AHGgetTempVname. It currently performs no operations.
Macro AHGfilesindir - Listing files in a directory
Utility macro to list files in a specific directory and store the result in a macro variable.
AHGeqV Macro (text comparison)
This macro is a wrapper that calls the `%AHGequaltext` macro to compare two text strings provided as parameters.
Macro AHGeqm
Wrapper macro to call the AHGequalmactext macro.
Case-insensitive text comparison macro
Utility macro comparing two character strings without considering case.
Case-insensitive text comparison
Macro comparing two character strings without considering case.
AHGdefault Utility Macro
Defines a utility macro to assign a default value to a specified macro variable if it is currently empty, with an opt...
Macro AHGdim - Dimension Calculation
Utility macro calculating a dimension rounded up to the nearest integer, based on a count of elements divided by a fa...
Comparison of Versioned Files AHGcmpWithSys
This SAS macro allows the comparison of two versions of a specified file, potentially managed by a version control sy...
ahgD Delimiter Utility Macro
Macro conditionally inserting a delimiter.
Getting the current date and time
Utility macro to get the current system date and time and store them in a specified SAS macro variable.
Indirect macro variable resolution
Utility macro allowing indirect resolution of a macro variable.
ahgarr List Element Extraction Macro
Utility macro to extract a specific element from a list stored in a macro variable.
AHGbareName Macro
Utility macro to extract the 'bare name' of a dataset or file.
Extracting the Base Name of a Dataset
Utility macro to extract the base name of a dataset, whether or not it is prefixed by a library.
AHGblank Macro
Macro to check if a character string is empty or contains only spaces.
Conditional addition of trailing slash
Utility macro to add a directory delimiter to the end of a path if necessary.
Macro to add entry to CDARS system metadata
SAS macro to add a unique entry (identified by 'tot') to a metadata file (`reports.meta`), integrating version contro...
AHGaddvars Macro: Adding and Formatting Variables
Utility macro to apply formats to a list of variables in a SAS table, creating these variables if they do not exist.
Macro to add words after deletion
This utility macro combines deleting words from a phrase with adding new words to the end, using an internal macro %A...
Age calculation from dates
This SAS macro calculates a person's age in full years based on their date of birth and a reference date. It takes in...
Date Management with FCMP Functions
This SAS script defines and uses FCMP functions to manipulate dates by adding or subtracting months and years.
Add a path to SASAUTOS
Concatenates a macro library to the sasautos path.
Conditional Utility Macro ahg0
Macro that returns a specific character string if an input parameter is empty.
Conditional Execution Utility Macro
Macro executing a SAS statement if a specified parameter is not empty.
Forced termination of SAS program (_ABEND)
This SAS script defines an _ABEND macro that allows a SAS program to be stopped depending on the execution environmen...
Documentation Generation and HTML Conversion
Script configuring and executing the code_diary macro to generate project documentation, followed by conversion to HTML.
Test program for _getpgmdesc
Test program for the _getpgmdesc functionality using 'brief' documentation tags.
Utility macro library for table management and interface
Script defining utility macros to delete, copy, and inspect SAS tables, as well as an interface command for the old d...