Macro deleteSasmacN - Cleaning numbered SASMAC catalogs
Macro deleting all numbered 'sasmacr#' catalogs in the WORK library, without deleting the main 'sasmacr' catalog.
SAS Tables Deletion Demonstration
This script illustrates the use of the `%delete_dataset` macro to delete SAS tables in various ways.
Delete entries from a graphics catalog
This macro deletes specific entries or all entries from a SAS graphics catalog.
Density Plot with PROC SGPLOT
This script generates density plots to visualize the distribution of numerical variables using the SGPLOT procedure.
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...
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.
Sans titre
Utility macro to define macro variables containing the character strings for NOTE, WARNING, and ERROR messages in the...
Test of the _detectSymbols macro
This SAS script is a unit test for the `_detectSymbols` macro, verifying its ability to correctly set global symbols ...
Macro _DIRCHAR for directory character
This macro returns the appropriate directory separator character for the operating system.
Listing System Drives via DRIVEMAP
This script attempts to list the drives accessible to the operating system using the specific DRIVEMAP facility.
DROPMISS Macro - Deleting Empty Variables
SAS macro to delete variables from a table that contain no data (only missing values).
External File Deletion Macro
SAS macro to delete an external file if it exists, using the system functions filename and fdelete.
Deletion of Temporary Datasets
Utility macro to delete specific temporary datasets (starting with 'DATA') from the WORK library.
Investment Simulation over 5 Periods
Calculation of the future value of investments over 5 iterations via a loop.
Demonstration of DO loops in SAS
This script illustrates the difference between repetitive manual calculation and the use of a DO loop for iteration i...
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...
Creating custom functions for weekdays
Script defining two custom functions via PROC FCMP to get the name or number of the weekday from a date.
Date and Time Manipulation and Formatting
This SAS script demonstrates the creation, manipulation, and formatting of date and time variables, as well as the us...
Date component extraction and manipulation
Script illustrating the extraction of temporal elements (day, month, year, quarter, weekday) from a date variable.
Dataset creation with heterogeneous dates
Example of reading dates in different formats (text, numeric) in a DATA step.
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.
Sans titre
This SAS script creates an initial dataset 'b' from in-line data, then transforms this dataset into 'newdata' by addi...
Implementation and Comparison of the '_INFILE_' Technique for Data Delimitation
This SAS script demonstrates and compares two methods for delimiting complex character strings into multiple variable...
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...
CSV File Import Macro
Generic SAS macro for importing CSV files into the SAS workspace.
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.
SAS Macro _DATA: Extracting Table Name
This SAS macro extracts the name of a table from a complete reference (library.table) or a simple one, ignoring the l...
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.
Analysis of PhDs Awarded
This SAS script performs a correspondence analysis on the data of the number of PhDs awarded in different scientific ...
Creation of EXA Test Data Table
Macro to create the EXA test database table for the SASUnit framework.
Sans titre
SASUnit macro to create the 'scn' table containing information about test scenarios.
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...
DATA Step Partitioning and Sorting in CAS
Example of optimizing data loading into CAS with partitioning and sorting, followed by group processing.
DataGridProvider
Stored Process generating a paginated JSON response from a SAS table to feed a web interface (grid type).
Sans titre
This SAS script creates a dataset containing various representations of dates and times, including a specific date an...
Test of the _createScnLogConfigTemplate macro
This script is a SASUnit test case for the utility macro `_createScnLogConfigTemplate.sas`. It verifies the correct c...
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.
Custom ODS Style Definition
This SAS script defines a new custom ODS (Output Delivery System) style named 'customSapphire'. It inherits from the ...
Creating a format for cylinders
Definition of a custom format for the textual display of the number of cylinders.
