Classification of smoker and non-smoker risk groups
Risk level classification script based on smoking status and blood pressure.
Analysis and Processing of Conference Participant Data
This SAS script reads conference participant data from an external file, performs transformations to extract phone ar...
Weight Loss Survey Data Processing and Cleaning
This SAS script reads raw survey data from an external file, performs variable cleaning and recoding, calculates Body...
Conference Data Analysis
This SAS script analyzes conference data, producing various reports on attendees, vegetarian meals, and collected fee...
Measles Cases and MMR Vaccination Coverage by Year
This SAS script creates an internal dataset containing information on measles cases and MMR vaccination coverage by y...
Using the TRANWRD() Function
Demonstration of using the TRANWRD() function to replace substrings in a character variable.
Using the MEAN function
Simple example showing how to calculate the mean of variables in a DATA step.
Using Functions and Printing Data
This SAS script creates a simple dataset using several built-in functions (SUM, N, MIN) in a DATA step, then displays...
Example of the QTR function
Calculation of the quarter for a specific date.
Cumulative Sum Calculation
This simple SAS script illustrates the use of a sum statement to calculate a cumulative sum within a DATA step, using...
Creation of 'cities' dataset
Creation of a SAS dataset named 'cities' from raw data integrated directly into the script.
Creation of Salary Data Table
This SAS script creates a data table named 'salary' with information on brands, quantities, and amounts from data dir...
SPARQL update test on local server
Test script to send a SPARQL update query (INSERT) to a local endpoint via a SAS macro.
Map of the 16 German Länders
This script generates a choropleth map of the 16 German Länders (federal states) using SAS/GRAPH functionalities.
Electricity Consumption History with GCHART
Generation of a bar chart of monthly electricity consumption with custom annotations.
Using PROC SCAPROC for Flow Analysis
Script illustrating the use of PROC SCAPROC to record the inputs/outputs of a DATA step.
Table Creation with PROC DS2
This script uses PROC DS2 to create a new table named 'tatat' from the SASHELP.CLASS dataset, while initializing vari...
Excel Export and External Script Execution
This SAS script exports an internal dataset to an Excel file, then executes an external VBScript script to process th...
Exporting SAS Data to XML (MS Access)
This SAS script exports the 'retail' dataset from the SASHELP library to an XML file in MS Access format, by creating...
Air Quality Analysis and Reporting
This SAS script analyzes air quality from the SASHELP.AIR dataset, calculates a percentage index, and generates a col...
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).
Data Flow Analysis with SCAPROC
This SAS script illustrates a complete data manipulation process, from creating datasets based on SASHELP.CLASS, aggr...
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...
PROC RANK In-Database with SAS/ACCESS for Hadoop
This SAS script demonstrates the use of the RANK procedure for in-database processing with SAS/ACCESS to Hadoop, and ...
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.
ODS Event Map Generation
Generates an XML file tracing ODS events triggered by a procedure.
ETL Macro for Loading CAS Dimension
Macro to load and persist a dimension table in the CAS environment.
ETL Job Status Configuration
Macro to configure the ETL job status file which will store the status of each job.
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...
Initial Configuration Variables Definition
This script defines macro variables for the initial configuration of a SAS environment, including Viya compatibility ...
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, ...
Sans titre
This SAS script creates an `eg_meta` metadata dataset in the `meta` library from inline data. It defines variable att...
Creating and filtering a city table
Script creating a city dataset and filtering by a specific capital.
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...
Sans titre
This script initializes a temporary SAS library named `dsSQL`, intended to store temporary views generated during mac...
List of datasets in a library
SAS macro to list all datasets present in a specified library and store the result in a global macro variable.
Table label retrieval macro
Function-type macro to get the label of a specified SAS table.
