Macro _escapeblanks (Escaping blanks)
Documented macro to escape blanks with backslashes under Linux/AIX, although the current implementation does not modi...
Analysis and Transformation of Automotive Data with CAS
This SAS script configures the CAS environment, loads data from SASHELP to CAS, and then applies various transformati...
SAS Email Notification
This SAS script defines and uses macros to send email notifications, including the start and end execution times of a...
Multiple Data Analysis and Statistics
This SAS script is a collection of examples demonstrating dataset creation via `datalines`, data manipulation (filter...
Data preparation for earthquakes
This SAS script creates a new data table 'work.earthquakes' from the 'sashelp.quakes' table. It adds calculated varia...
System Environment Management via Macro
Use of the %sysexec command to modify the working directory and environment variables of the underlying system.
Automated Generation of Linked HTML Reports with Navigation
This program generates a system of interconnected HTML reports analyzing profits by year and product line.
Annual Profit Report by Product Line
This SAS script generates a detailed report of total profit by year, broken down by product line, using the PROC REPO...
ODS Report of Profits by Year and Product
Generation of an HTML report analyzing total profits by year and product line with conditional formatting.
Profit Report by Product Line and Year
This SAS script generates a detailed annual profit report aggregated by product line, including a percentage of profi...
Sales Report and Negative Binomial Simulation
Script combining a sales report (SASHELP.ORSALES) and a statistical data simulation (Negative Binomial Distribution).
Automated Data Comparison Macro
Defines and uses an '%autocompare' macro to compare two datasets, identify differences, and present them in a readabl...
DATA Step execution example with end-of-file variable
Script illustrating the use of the END= option in a DATA step to detect the last observation and perform cumulative c...
Calculate the difference in years with INTCK
This SAS script calculates and displays the difference in years between two dates using the INTCK function.
Interval Alignment and Date Functions
Demonstration of alignment options for INTNX and INTCK date/time functions in SAS, illustrating interval calculation ...
Using the ?? modifier in INPUT
Example of using the ?? modifier to suppress read error messages.
Export SASHELP.CLASS data to CSV
This SAS script exports the content of the standard SASHELP.CLASS table to a CSV file named class.csv, including colu...
Exporting Data to CSV
Exports the sashelp.class table to a CSV file.
Viewing FCMP Function Libraries
This SAS script is used to list and view the contents of an FCMP function library, specifically 'advrpt.functions'.
Deletion of WORK data
This script deletes all temporary data tables (memtype=data) from the WORK library.
Checking system options and macro variables
This SAS script checks a system option (`SASAUTOS`) and displays the values of environment or macro variables (`advte...
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...
Manipulating Date and Datetime Formats with ANYDATE
This SAS script demonstrates the use of ANYDATE informats to read and convert different date and datetime formats int...
ODS Configuration for Excel XP with Documentation
This SAS script configures the ODS 'tagsets.excelxp' destination to generate Excel files with documentation options.
Managing Decimals with PROC FORMAT PICTURE
Demonstration of using PROC FORMAT with the PICTURE statement to format numerical values, specifically managing decim...
Data Creation and Deduplication with PROC SORT
This SAS script creates an internal dataset, then demonstrates two deduplication methods using PROC SORT: NODUP for c...
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.
Sans titre
SAS macro to download Fama-French 3 factors (daily) from an online source and load them into a SAS dataset.
Downloading FRED Economic Data
SAS macro to download specific economic data from the FRED (Federal Reserve Economic Data) database via a URL.
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.
Discriminant Analysis of Fisher's (1936) Iris Data
This script performs a quadratic discriminant analysis on Fisher's Iris data, then displays the resulting statistics.
Getting Started Example for PROC DISCRIM
Basic demonstration of discriminant analysis using the fish measurement table.
SDTM DM Dataset Creation
This SAS script configures the environment, generates a Demographics (DM) domain dataset for SDTM using the %dm_creat...
Creation of Metadata for the DM Table
This SAS script creates a dataset containing metadata (column name, type, length, label) for a 'DM' table, typically ...
Utility macro to delete a file
This macro allows you to delete a file from the file system if it exists.
Count the number of observations in a dataset
SAS macro-function to determine the number of observations in a specified dataset.
Diet Data Frequency Analysis
This SAS script creates an internal dataset named 'diet' and then performs a cross-frequency analysis between the 'vi...
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.
Sans titre
This SAS script offers two main functionalities via macros: analyzing dependencies between SAS macros and verifying t...
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.
