This SAS script demonstrates the use of the FACTOR procedure for factor analysis, focusing on methods for determining...
View code
Utility
Function F1
This script defines a simple SAS function named F1 that takes a number as input and returns this number incremented b...
View code
Macro/Function
User Function Definition F2
Simple function adding 2 to a given number.
View code
Graphic
Extreme MPG Graph Generation
This SAS script generates an ODS SGPLOT graph displaying vehicles with extreme highway fuel consumption (MPG) values,...
View code
Reporting
Simple Statistics with Scatter Plot and Reference Lines
Creates a scatter plot of `msrp` vs `mpg_highway` from `sashelp.cars`, including reference lines for the median of `m...
View code
Général
Sans titre
Script generating an HTML pie chart from included data.
View code
Administration
Extracting file information via OS command
This SAS macro executes an operating system command to get information about a file and stores the file's date, time,...
View code
Macro
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...
View code
Administration
Opening FSP help via Windows system command
Retrieves system environment variables to attempt opening a specific help file via an external command.
View code
Administration
Remote SAS Session Management and System Command
This SAS script manages the initiation and termination of a remote SAS session via SAS/CONNECT, while executing a Win...
View code
ETL
Data Generation and Export to XML
Script illustrating the creation of a SAS table and its direct writing to an XML file.
View code
ETL
Export SASHELP.CLASS to CSV
Exporting data from the SASHELP.CLASS table to a local CSV file.
View code
ETL
SASHELP data analysis and display
This simple SAS script reads the example dataset `sashelp.prdsale` and displays the content of specific variables in ...
View code
Reporting
ODS RTF Report Generation
This SAS script generates an RTF format report from the SASHELP.SHOES dataset.
View code
Reporting
List of available ODS styles
Displays a list of all available ODS (Output Delivery System) styles.
View code
Reporting
3D Bar Chart of Shoe Sales
This SAS script generates a 3D bar chart of shoe sales by product and exports the result to HTML.
View code
Reporting
ODS Footer Management
This script configures the ODS escape character and defines a footer for page numbering in ODS output.
View code
Général
Sans titre
Uses the chmod command to modify file permissions and authorizations on the operating system.
View code
Reporting
ExtJS HTML Page Generation via Stored Process
SAS Stored Process script generating an HTML page integrating an ExtJS layout.
View code
Général
Sans titre
This script creates individual pie charts by age, saves them as images, and uses them as fill patterns for a final ch...
View code
Macro
Conditional Code Deactivation via Macro Variables
Technique for dynamically activating or deactivating a SAS code block using macro variables to generate comment tags.
View code
Data Integration
Local SPARQL Integration Test with SAS-SPARQLwrapper
This SAS script demonstrates interaction with a local SPARQL endpoint (simulating a Virtuoso database) using the SAS-...
View code
Reporting
PDF Report Generation via ODS and Macros
This SAS script generates reports in PDF format from SASHELP data, using ODS PDF and a macro to automate the creation...
View code
Reporting
Illustration of the POSITION option in ANNOTATE with GPLOT
This SAS script generates a graph using PROC GPLOT to demonstrate the effect of the POSITION option within an ANNOTAT...
View code
Macro
Interaction Expansion Macro (Bar Operator)
Set of macros simulating the bar operator '|' used in statistical procedures to automatically generate main effects a...
View code
Macro
GLM Formula Expansion Macros
Set of SAS macros to expand linear model specifications (vertical bar notation) into a full list of terms and interac...
View code
Macro
Unit test of the _getAbsPathComponents macro
Unit test script for the _getAbsPathComponents macro, validating the extraction of the filename and parent path from ...
View code
Macro
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.
View code
Macro
Test of the _getAutocallNumber macro
Unit test script for the _getAutocallNumber macro verifying the resolution of macro search paths (autocall).
View code
ETL
SAS CI360 Data Extraction and Loading
Authentication and retrieval of data files from SAS Customer Intelligence 360.
View code
Macro
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...
View code
Test
Test of the _existVar.sas macro
This SAS script tests the functionality of the _existVar.sas macro, which is designed to check the existence and type...
View code
Macro
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...
View code
Macro
Macro _FINFO - Extended File Information
Utility macro to retrieve detailed file information (date, permissions, size) via a system command.
View code
Macro
Utility Macro _FIRST
Generates a SAS logical expression to identify the first observation of a BY group or the first general observation i...
View code
Macro
Test of the _executeCmdFile macro
Unit test script for the SASUnit _executeCmdFile macro.
View code
Macro
Macro _EXIST - File Existence Check
Simple SAS macro to check for the existence of a file or directory on the file system.
View code
Macro
Directory Existence Check
SAS macro to check if a given directory exists and is accessible.
View code
Test
Test of the _existDir.sas macro
This SAS script is a unit test for the `_existDir.sas` macro, verifying directory existence.
View code
Macro
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.
View code
Reporting
Creation and printing of simple data
Basic script creating a temporary dataset via datalines and displaying the result.
View code
Administration
Managing SAS Formats in CAS
This SAS script demonstrates comprehensive management of user-defined formats in the SAS Viya CAS environment, includ...
View code
Macro
Simple Inclusion Macro
This script defines a simple SAS macro that displays a message in the log when called.
View code
ETL
Managing Current Dates and Times
This SAS script creates a dataset containing the current date, time, and datetime, then displays them.
View code
Macro
OS Command File Execution
Executes an operating system command file via a SAS macro.
View code
Statistical
Non-parametric analysis of candidate incomes
This SAS script imports candidate income data from an external CSV file, performs exploratory analysis via graphs (bo...
View code
Administration
Displaying operating system information
Displays the current operating system identifiers in the SAS log.
View code
ETL
Filter records with a specific numeric sequence per line
This SAS program filters records from a dataset that contain a specific numeric sequence (8, 0, 1) across three conse...
View code
Reporting
SGPANEL Layout Comparison: Panel vs Lattice
Script generating two analytical graphs to compare the relationships between cholesterol and systolic pressure, segme...
View code
Reporting
Health Data Visualization with ODS Graphics
This SAS script generates two ODS graphics: a panel scatter plot and a panel histogram. These visualizations explore ...
View code
Derniers codes ajoutés
Boost Performance & Security: Creating Composite Indexes and Passwords with PROC DATASETS
This example illustrates the modification of two SAS data sets using the MODIFY statement and its sub-statements. It shows how to: modify SAS files, label a SAS data set, add a read password to a SAS data set, indicate the current sort order of a SAS data set, create an index for a SAS data set, assign informats and formats to variables, rename variables, and label variables in a SAS data set.
ETL
SAS Data Step Efficiency: When to Use Explicit OUTPUT vs. Implicit Rules
Writes the current observation to a SAS dataset.
Data ManipulationCAS
Stop Struggling with Data Ingestion: Efficiently Move CSVs to Memory with PROC CASUTIL
The CASUTIL procedure offers several table and caslib management functions, including displaying table metadata, deleting files, unloading and loading tables, promoting tables, and saving tables.
ETLCAS
Beyond the WORK Library: Mastering the 4 Default SAS Libraries You Must Know
This document describes the default SAS libraries: Work (temporary), User (user), Sashelp, and Sasuser. It explains their role and behavior within the SAS Viya 4 environment.
Data Access
Seamless Integration: How to Attach Data Step Outputs Directly to SAS Viya Jobs
The SAS Viya Platform File Service allows storing, retrieving, and deleting files kept in the SAS Infrastructure Data Server database repository. This repository is not considered a complete 'file system' but contains individual files directly accessible by their file identifier (UUID).
Administration
From SAS 9 to Viya: The Ultimate Guide to Migrating User-Defined Formats to CAS
In the SAS Viya platform, you can store user-defined formats in catalogs for use in a SAS session, or you can store them in a format library on the CAS server. Format libraries are associated with a CAS session, or they can be promoted to global scope to be available to all CAS sessions. User-defined formats in a format library are server-side formats that the server uses when an analysis is performed based on formatted values. You can migrate existing user-defined formats from SAS to the SAS Viya platform.
ToolsCAS
Instant Performance Boost: Creating Indexes on the Fly with the INDEX= Data Set Option
Defines one or more indexes for a new output SAS data set.
Général
Stop Bloating Your Datasets: The Definitive Guide to Variable Selection with KEEP
Specifies variables to include in output SAS data sets.
ETLCAS
Combine and Conquer: Mixing Physical Paths and Existing Librefs in One LIBNAME Statement
Explains the concept of SAS library concatenation, allowing several libraries to be logically grouped under a single reference (libref).
Data Access
Stop Importing, Start Connecting: A Master Class in SAS/ACCESS Engines and SQL Pass-Through
This document provides examples of using SAS engines to access and process various types of external data, including delimited files, Excel files, databases (DBMS), XML, and JSON.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.
This site uses technical and analytical cookies to improve your experience.
Read more.