WORK Library Consultation
Execution of the DATASETS procedure to list the contents of the temporary WORK library.
Training a Gradient Boosting Model for Salary Prediction
This SAS Viya script uses the Cloud Analytic Services (CAS) to train a Gradient Boosting model on the sashelp.basebal...
Managing VARCHAR data in CAS
This SAS script illustrates the creation of a SAS table with long character columns, its loading into a CAS cluster w...
Code Diary Documentation Generation and HTML Conversion
Configuration and execution script for automatic documentation generation (Code Diary) and its conversion to HTML.
Advanced Descriptive Analysis with PROC MEANS
Comprehensive demonstration of PROC MEANS procedure capabilities for descriptive analysis, including default statisti...
PROC SUMMARY and PROC PRINT Analysis
This SAS script demonstrates the use of PROC SUMMARY and PROC PRINT for data analysis and display. It illustrates the...
Student's t-test on carat data
Creation of a dataset and performing a Student's t-test.
Reading source code from a SASHELP catalog
Script reading the content of a SAS catalog entry (source) to display it in the log.
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...
Graphs with broken axes
This SAS script generates various graphs (bar charts and scatter plots) with examples of broken axes to handle extrem...
Using SAS Numeric Functions
This SAS script demonstrates the use of several built-in numeric functions (CEIL, FLOOR, INT, ROUND) in a DATA step t...
Loading and Manipulation of Baseball Data in CAS
This SAS script loads the 'baseball' dataset from the SASHELP library into a CAS library ('casuser'), then creates a ...
CAS Joins with Deep Learning and Search Analytics
This SAS script initializes a CAS session and performs data joins using the dlJoin actions from the Deep Learning act...
Example of GROUPBY aggregation with CASL and FedSQL
This SAS script demonstrates the use of GROUPBY actions via PROC FEDSQL and PROC CAS (with the simple.groupBy action)...
Frequency Analysis with PROC FREQTAB and CAS
This SAS script uses the Cloud Analytic Services (CAS) engine to create a table from `sashelp.baseball` and perform a...
Parallel Execution of CAS Regressions with SAS/CONNECT
This script uses SAS/CONNECT to establish and manage two distinct remote SAS sessions. It then asynchronously submits...
Lilly Macro Library Refresh
This SAS macro, named AHGrefreshlilly, is designed to automate the refreshing and backup of a SAS macro library. It s...
Dynamic Column Display with PROC SQL and PROC PRINT
This SAS script dynamically retrieves column names from the SASUSER.HOUSES dataset and uses these names to selectivel...
Product Data Analysis and Transformation
This SAS script explores, analyzes, and transforms an external product catalog dataset. It examines its structure, ge...
get_append_base Macro for Structure Generation
Macro displaying in the log the SAS code to recreate the structure (formats) of a given table.
Descriptive Analysis of Internal Data
This SAS script creates a simple internal dataset and then performs basic descriptive analyses using PROC SQL and PRO...
Binomial Probability Analysis
This SAS script calculates and presents the probabilities of non-missing events based on a binomial distribution, var...
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...
CCLI Library Definition
This SAS script defines a macro that creates a SAS library ('libname') pointing to a specified path on the file system.
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...
AHGfreqCore Macro - Frequency Calculation and Transposition
Utility macro to calculate frequencies (PROC FREQ), format results, and optionally transpose the output.
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.
Sans titre
Utility macro to retrieve the RCS (head) version of a file.
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.
Frequency Analysis of School-Money Associations
Creation of a `school` dataset from raw multi-observation data per line, followed by a frequency analysis of `money` ...
