Here you will find advanced techniques to modernize your workflows, whether you are operating in SAS© 9 or SAS© Viya™ (CAS):
Data Ingestion & Export: Master the handling of flat files (CSV, XML, Excel) and Cloud interactions (PROC CASUTIL, ZIP loading, encoding management).
Performance & Optimization: Learn how to create composite indexes, compress in-memory data, partition for parallel computing, and utilize Bulk Loading for external databases (Snowflake, Redshift, Hadoop).
Advanced Manipulation (Data Step & SQL): Techniques for complex joins, transaction management (modify, update), deduplication, and data cleansing.
Interoperability: Connectors for external databases, REST API calls, and data type optimization (VARCHAR vs. CHAR).
These resources are designed to transform slow, fragile data pipelines into robust, high-speed data architectures.
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 ...
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, dele...
Stop Bloating Your Datasets: The Definitive Guide to Variable Selection with KEEP
Specifies variables to include in output SAS data sets.
Stop Copy-Pasting: Automate Your CSV Generation with the DBMS=CSV Option
This example explains how to export a SAS dataset to a CSV file using the EXPORT procedure.
Variable Mismatches? No Problem. How to Standardize Metadata with ATTRIB and PROC SQL
This document provides detailed examples on preparing and combining SAS datasets, addressing common issues such as in...
Stitching Data Without Keys: Mastering One-to-One Reading in the SAS Data Step
This example illustrates combining observations from two datasets using the SET statement. It highlights the behavior...
Insert or Update? Handling Transactional Logic with _IORC_ and %SYSRC
This example illustrates how to use the `MODIFY` statement in a DATA Step to update a master data set (`master`) from...
Stop Indexing Everything: Balancing Query Performance vs. Disk Space in SAS
An index is a file associated with a table that allows access to rows by index value. Indexes can speed up access to ...
Feature Engineering in CAS: How to Create Custom Categories from Continuous Data
This example uses the DATA step to create a data set named CreditQualify. The DATA step creates variables using the L...
No Data Step Required: Creating Computed Columns on the Fly with table.fetch
This feature allows viewing specific rows of an in-memory CAS table, with filtering, sorting, and limiting options.
From Raw CSV to Formatted Table: The Efficient Way to Load Local Data to CAS
This SAS script demonstrates how to upload a local CSV file to a CAS (Cloud Analytic Services) server and apply custo...
Forget PROC IMPORT: The Fast Way to Upload Local CSVs to SAS Cloud
This script illustrates how to download and load a CSV file located on an external HTTP server into SAS Cloud Analyti...
Stop Overwriting Your Data: How to Perform In-Place Updates with table.update
This functionality allows modifying existing row values in a CAS table using the `table.update` action. It supports u...
From Memory to Disk: The Complete Guide to Saving CAS Tables as SAS7BDAT
This example shows how to use the 'save' action and the 'exportOptions' parameter to save an in-memory table as a SAS...
From CSV to Memory: A Quick Start Guide to Loading Data with PROC CASUTIL
The CASUTIL procedure provides management functions for caslibs and tables in SAS Cloud Analytic Services (CAS). It a...
Secure, Sort, and Index: A Comprehensive Guide to Managing SAS Data Sets
This example demonstrates how to modify SAS data sets using the MODIFY statement and subordinate statements within PR...
One Step, Multiple Files: How to Ingest a ZIP of CSVs into a Single CAS Table
Demonstrates how to read a ZIP archive containing multiple CSV files in SAS Viya 4.
Clean Data on Ingest: How to Transform Dates and Percentages Directly into CAS
This SAS script demonstrates how to load a CSV file from a CAS caslib and apply SAS informats to correctly interpret ...
Mastering Data Imputation in SAS Viya: Using SINGLE=YES for Accurate Time-Series
This script illustrates the use of the LAG function in a DATA Step to impute missing values. The LAG function retriev...
Stop Wasting Compute: Validated vs. Unvalidated Sorting in SAS Data Sets
This article provides practical examples on how to sort SAS data sets and display their descriptive information. It e...
Modern SAS Data Architecture: Leveraging Cloud (CAS) and Distributed Engines
This document provides examples of using various SAS engines (V9, SPD, CVP, CAS) to manipulate and manage SAS data, i...
WHERE vs. IF: 5 Pro-Tips for Faster Data Filtering in SAS Viya
This document provides examples of using WHERE statements and options in SAS for conditional selection of data rows, ...
SAS Viya Data Loading: How to Read CSVs and Manage In-Memory CAS Tables
This document provides SAS code examples for interacting with CAS (Cloud Analytic Services) tables. It shows how to l...
One-to-One Reading in SAS: How to Combine Datasets Without a BY Statement
This example illustrates the use of two SET statements to combine observations from two datasets ('animal' and 'plant...
Stop Rebuilding Tables: Faster Ways to Append Data in SAS Using PROC APPEND and OPEN=DEFER
This document explains how to concatenate SAS datasets using various methods, including the SET statement, PROC SQL p...
The SAS Viya Data Type Matrix: Optimizing Storage with VARCHAR and VARBINARY
This document describes the data types supported by the SAS Viya CAS server, including traditional SAS types (CHARACT...
SAS Viya Memory Optimization: Saving Space with CAS Table Compression
This document describes data compression management for in-memory tables in SAS Cloud Analytic Services (CAS) of SAS ...
High-Performance Aggregation in SAS Viya: Mastering CAS GroupBy Actions
This example groups the CreditQualify table by State variables and State FIPS codes, then uses Credit_Score as a weig...
High-Speed Feature Engineering: Mastering the CAS DATA Step in SAS Viya
This example shows how to use the DATA step to create new variables and conditionally filter data. It uses LENGTH and...
SAS 9 vs. CAS: Why Your BY Statement Is Breaking Your Sort Order
This article explains how to combine SAS tables using the BY statement, presenting scenarios for concatenation (SET) ...
From Cloud to Disk: How to Efficiently Convert CAS Tables to SAS Datasets
This example shows how to use the DATA step to convert an in-memory CAS table into a local SAS dataset. It illustrate...
Beyond Mock Data: Building a Statistical Test Matrix for Complex SAS Simulations
This SAS script generates a synthetic dataset simulating electronic component tests for different vendors, then expor...
SAS Data Step Logic: A Guide to Calculated Columns, Range Comparisons, and Conditional Grading
This SAS script illustrates different ways to calculate averages, assign grades based on thresholds, and use logical ...
Data Processing and XML Export
This SAS script defines a default data source, retrieves metadata about this source, then exports its content in XML ...
Creating and Displaying School Grade Data
This SAS script illustrates basic operations of creating data tables via DATALINES, calculating new variables, modify...
Loading Data with CAS Connector (Example)
This SAS script demonstrates how to use the SAS data connector to load data from an external relational database mana...
Example of DATA STEP usage with PROC APPEND
This SAS script illustrates table creation and deletion, particularly managing dependencies when creating tables from...
SAS Table Manipulation (Filtering, Selection, and Formatting)
Fundamental DATA step examples for filtering observations, selecting variables, and applying formats.
MERGE Operations with IN= Option
This SAS script illustrates the use of the MERGE statement with the IN= option to perform different joins between two...
Executing an iterative DO loop
This script illustrates the use of an iterative DO loop in a DATA step to generate multiple output records from a sin...
Retirement Savings Plan Simulation
This script simulates the growth of a retirement savings account over 6 years, considering annual contributions and c...
Generic Variable Transformation
This SAS script demonstrates the use of `_numeric_` and `_character_` keywords to apply conditional transformations t...
PG2 Course Data Generation
Script for creating multiple data tables (CLASS_*, EU_SPORTS, etc.) for the SAS PG2 course.
Creation of the myLib.smallDataset table
Data generation script creating a table with numerical values and their formatted representation.
Korean Fiscal Data Extraction and Parsing via API
Script retrieving financial data from the Open Fiscal Data API (Korea) via HTTP requests, followed by manual parsing ...
Direct data reading with index (KEY=)
Demonstration of using the KEY= option in the SET statement for indexed reading.
Creation of Metadata for Laboratory Variables
This SAS script creates a metadata dataset named 'lb_meta' containing attributes (name, type, length, label) for labo...
Download and Import Titanic Data
Retrieving the Titanic passenger CSV file from a web server and importing it into a SAS table.
Exporting tables to Excel via LIBNAME
SAS data export script to an Excel file using the EXCEL library engine.
Data Transformation and Restructuring with PROC TRANSPOSE
Educational example illustrating data transposition and variable renaming.
Creation and Display of Internal Data
Basic script creating a dataset from manually entered lines and displaying the result.
Data Manipulation with LAG Functions
Script illustrating data creation, sorting, and the use of the LAG function to access previous observations.
Extracting ORSALES Sales Data
Selection and copying of specific columns from the SASHELP.ORSALES example table.
Data Simulation and Transformation via Array
Generation of simulated data and complex transformation using arrays and variable retention.
Sans titre
This SAS script demonstrates the use of the Teradata Parallel Transporter (TPT) option with SAS/ACCESS to bulk load d...
Visualize DATA Step Processing Information with Automatic Variables
This document explains how to use DATA Step automatic variables, especially '_THREADID_', to understand and control d...
Execute a DATA step in CAS on a CAS table
This document explains how to execute a DATA step in the CAS (Cloud Analytic Services) environment using a CAS table ...
Data Formatting and Payroll Calculation
Script illustrating multi-line data reading, derived variable calculation, and application of display formats.
Definition of Nested Formats and Validation
Creation of custom formats with logical nesting and display testing.
Load a CSV File from a GZ Archive
This document explains how to use the `table.loadTable` action to load CSV data compressed in GZ (gzip) format into a...
Joining Tables from Multiple Caslibs with fedSql.execDirect
This example shows how to join three external tables using the fedSql.execDirect action. It combines a Base SAS datas...
Creation of the Info Table
Basic script illustrating the creation of a SAS table with a single observation.
Examples of delimiter management with INPUT and INFILE
Series of examples demonstrating various techniques for reading delimited data in a DATA step: managing CSVs, format ...
Concatenation of SAS Tables
This script illustrates several techniques for concatenating (appending) data from one SAS table to another.
Understanding the SUM Statement and Accumulation
Example showing three different methods to perform a cumulative sum in a DATA step.
Creation of the PAY table with internal data
Creation of a SAS table named PAY from data entered directly into the code via DATALINES.
Detailed Journey of a DATA Step Program
This document describes in detail the steps to execute a DATA Step program in the Cloud Analytic Services (CAS) envir...
Amazon Redshift Data Connector
This connector enables the transfer of data between an Amazon Redshift database and SAS Cloud Analytic Services (CAS)...
Amazon Redshift Data Connector
This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Services (CAS). It sup...
Amazon Redshift Data Connector
This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Services (CAS). It sup...
Displaying SASHELP Data and Local Creation
Demonstration script displaying a system table and creating a custom table.
Example of table merging by identifier
Script illustrating the creation of manual data and their merging via a Data Step.
Dataset Creation with Datalines and Display
This script creates a SAS dataset from inline data and displays the result.
Creating and Displaying the prob12_8 Table
Script generating a SAS dataset from embedded data (datalines) and displaying the result.
Restructuring SAS Tables (Wide to Long and vice versa)
Demonstration of restructuring SAS datasets: converting a 'wide' format (multiple columns per subject) to a 'long' fo...
Fahrenheit to Celsius Temperature Conversion
Temperature conversion script using arrays and an iterative loop.
Time Unit Conversion using Arrays and Loops
Data transformation script converting numerical values through iterative processing on grouped variables.
Bonus Calculation and New Salary by Classification
Script for creating a salary table including a conditional bonus calculation based on the employee's class.
Bulk Loading Data to Snowflake via SAS/ACCESS
This SAS script demonstrates the use of SAS/ACCESS bulk loading functionality to transfer data from a temporary SAS d...
Bulk Data Loading
This SAS script illustrates bulk data loading to an external database via SAS/ACCESS, using the PROC SQL BULKLOAD met...
Bulk Load Example (BULKLOAD)
This SAS script demonstrates the use of the BULKLOAD option to load data into an external database table via SAS/ACCE...
Bulkload - SAS/ACCESS Greenplum Example
This SAS script demonstrates two methods for bulk loading data into a Greenplum database via SAS/ACCESS. It includes ...
Bulk Data Loading (Bulkload)
This SAS script demonstrates two methods for bulk loading data to an external database (potentially HAWQ as indicated...
PROC SQL vs. Data Step: Mastering High-Performance Bulk Loads in SAS
This SAS script demonstrates two methods for bulk loading data into an external relational database (potentially Impa...
Bulk Load via ODBC to SQL Server
Example of bulk loading data to a SQL Server database via ODBC.
Bulk Load Programs Example
This SAS script demonstrates bulk loading data from an internally created SAS dataset to an external database table v...
Bulkload Example
This SAS script illustrates a bulkload example of data to a DBMS table using SAS/ACCESS. It first creates an in-memor...
Amazon Redshift Data Connector
This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Services (CAS). It sup...
Creation of a large synthetic dataset
This SAS script generates a large dataset named `biggerDataset` in the `myLib` library, populating variables 'i', 'j'...
OpenFiscalData API Extraction and Parsing
Script automating the retrieval of public financial data via a Korean REST API (OpenFiscalData). The script downloads...
Extraction and consolidation of fiscal data via REST API
Script for extracting data from the Open Fiscal Data API (Korea) using iterative HTTP calls and SAS's JSON engine.
Reading and Correcting Delimited Data with Missing Delimiters
This SAS script illustrates how to handle and correct the reading of delimited data files when some delimiters are mi...
Difference Table Creation and Indexing Macro
This SAS macro creates or updates the structure of a SAS table (`DIFFTABLE` by default) intended to store information...
Analysis and merging of corporate and financial data
This SAS script creates and manipulates two internal datasets ('company' and 'finance') from in-line data, then merge...
Data Creation for Proportions Test
This SAS script prepares an internal dataset for subsequent statistical analysis of proportion differences.
Comparison of variable length definition methods
Demonstration of the impact of character variable initialization on their length and the risk of truncation.
Management of Location Data and SAS Utility Macros
This script combines the creation and updating of location data with SAS utility macro definitions for debugging and ...
Reading Dates with Error Suppression
Script illustrating date import with silent handling of invalid values.
Leap Year Detection
This SAS script identifies and lists all leap years between 2000 and 2200, creating a SAS dataset 'leap_years'.
Customer Table Creation
SAS script for creating a table named 'customer' from data included in the code.
JSON Generation of a SAS Table
This SAS script converts the SASHELP.ORSALES table into JSON format and writes it to the '_webout' fileref.
Processing and consolidation of department data
This SAS script creates two datasets (`research_development` and `Publication`) from internal data provided via `data...
CASL and FedSQL Join Examples
This SAS script demonstrates different methods for performing joins on baseball data within the SAS Viya 4 environmen...
Data Filtering with the IN operator
Creating a data subset by filtering on the age variable using the IN operator.
Format Management and Data Transformation
This SAS script defines and uses formats to standardize and transform date data as well as categorical text responses.
CSV Data Import and Verification
This SAS script imports an external CSV file (`np_traffic.csv`) into a SAS table named `traffic`, then displays the m...
Creating and Displaying Student Data
This SAS script demonstrates the creation and manipulation of simple datasets from in-line data (datalines) for manag...
Appending two CAS tables
This SAS script demonstrates how to append the content of one CAS table (CARS2) to another existing CAS table (CARS) ...
Character to VARCHAR type conversion when loading into CAS
This SAS script demonstrates how to convert character variables to VARCHAR type when loading a table into CAS, in ord...
Student Grades Analysis and Status Assignment
The SAS script creates two student datasets from raw data. It calculates the average scores and assigns a status base...
Export data to text file
Script exporting manually entered data to a text file.
FASTFORMAT Format Definition
This script defines a custom SAS format named FASTFORMAT that maps textual values to 'Diesel' or 'Gasoline' based on ...
Data Generation and Export to XML
Script illustrating the creation of a SAS table and its direct writing to an XML file.
Export SASHELP.CLASS to CSV
Exporting data from the SASHELP.CLASS table to a local CSV file.
SASHELP data analysis and display
This simple SAS script reads the example dataset `sashelp.prdsale` and displays the content of specific variables in ...
SAS CI360 Data Extraction and Loading
Authentication and retrieval of data files from SAS Customer Intelligence 360.
Managing Current Dates and Times
This SAS script creates a dataset containing the current date, time, and datetime, then displays them.
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...
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...
Using the TRANWRD() Function
Demonstration of using the TRANWRD() function to replace substrings in a character variable.
Cumulative Sum Calculation
This simple SAS script illustrates the use of a sum statement to calculate a cumulative sum within a DATA step, using...
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...
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.
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...
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...
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.
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...
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...
Downloading FRED Economic Data
SAS macro to download specific economic data from the FRED (Federal Reserve Economic Data) database via a URL.
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 ...
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...
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.
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...
DATA Step Partitioning and Sorting in CAS
Example of optimizing data loading into CAS with partitioning and sorting, followed by group processing.
CAS Table Partitioning and Sorting
Demonstration of CAS performance optimization through data partitioning and sorting during loading.
Using LAG and DIF Functions
This SAS script demonstrates the use of LAG and DIF functions within a DATA STEP to create new variables based on pre...
Creation and Addition of ContactType Data
This SAS script creates a temporary dataset `work.ContactType` from literal data (datalines) and then appends it to a...
Table creation and column filtering
Script creating a table with dynamic variable selection and displaying the result.
Case Management in SAS String Comparisons
This SAS script demonstrates different methods of managing case during string comparisons to assign a status based on...
Calculation of New Columns and Formatting
This program uses a DATA step to create a new table from SASHELP.CARS, by filtering data, calculating new columns, ap...
Data Creation with Variable Filter and Display
Generation of a temporary table filtering variables by prefix, followed by its printing.
Test of the LENGTH function
Simple demonstration of the LENGTH function's behavior on various character strings.
Simplified String Concatenation
Demonstration of CATX function's efficiency for string concatenation compared to traditional methods.
Merging datasets and creating reports
This SAS script creates two datasets, sorts them, then merges them in different ways (standard, inner, outer). The re...
SAS Data Concatenation and Appending Techniques
Comparative demonstration of three methods to concatenate datasets: Data Step, Append Procedure (encapsulated in a ma...
Data Creation and WORK Library Management
The script creates a temporary SAS dataset named THREEROWS and executes PROC DATASETS on the WORK library.
Applying COMMA Numeric Format
Creation of a dataset and application of a thousands separator format.
Creation and formatting of monetary data
Creation of a table with formatted monetary values and metadata analysis.
BMI Calculation via Data Step
Simple Body Mass Index (BMI) calculation with output to the log.
Creating and Displaying the CEREAL Dataset
This SAS script creates a `work.cereal` dataset using embedded data via `datalines`, then displays the content of thi...
Creation of the THREEROWS table
Creation of a simple SAS table with data included in the code.
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...
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)...
Reading and Manipulating Date Variables with Datalines
This SAS script illustrates the reading and manipulation of date variables from internal data (datalines) using vario...
Data Reading and Sorting Exercises (US Presidents & Pumpkin)
Exercise script illustrating different techniques for reading raw data (Column input, pointers) and sorting.
Simple Data Creation and Transformation
Basic example of data creation, variable calculation, and display.
Advanced Inventory and Purchase Data Manipulation
This SAS script demonstrates fundamental and advanced data manipulation techniques. It includes creating datasets, ap...
Copying data from an ODBC source to local files
This SAS script copies tables from an ODBC data source (`dwdata`) to SAS files located on a local path (`dwRaw`).
Sans titre
This SAS script creates a dataset of student scores, sorts it, and identifies duplicate scores, retaining the highest...
Creation of the MYLIB.CLASS1 table
This SAS script creates a table named CLASS1 in the MYLIB library using instream data (datalines).
Explanation of PROC IMPORT
This document explains in detail the use of the PROC IMPORT procedure to import data from various external sources in...
Converting character string to numeric value
Script demonstrating the conversion of a character variable containing separators to numeric format.
Student Data Management with Sorting and Deduplication
This SAS script creates a 'CLASSTEST' table from embedded data, then generates a new table 'CLASSTEST_SORT' containin...
Creating and Displaying an In-Stream Dataset
This SAS script creates a dataset named 'instream_mtcars' from in-line provided data and then displays its content.
Simple Data Creation and Filtering
Demonstration script creating an internal table and displaying a subset.
Currency management and display
This SAS script illustrates the use of different formats for entering and displaying monetary values (dollar and euro...
Date Processing and Display
This SAS script demonstrates the creation of two datasets ('userinfo' and 'julinedata') using `datalines` and `cards`...
Data Cleaning and Display (Duplicate Removal)
This SAS script creates a 'classtest' data table, cleans it by removing entirely duplicated rows using PROC SORT with...
Creating and Sorting Class Data
This SAS script creates a student data table, then sorts it by subject in ascending order and by score in descending ...
In-Stream Data Creation and Display
This SAS script creates a dataset named 'instream_mtcars' from data provided directly within the script via a CARDS s...
Date manipulation with INTNX and INTCK
Demonstration of SAS INTNX and INTCK functions for manipulating and calculating date differences.
Transposing the SASHELP.CLASS table
Simple example of transposing columns into rows using the CLASS table.
Creating and Displaying Instream Data
This SAS script creates a temporary dataset 'instream_mtcars' from instream data provided directly in the code, then ...
Quiz Score Creation and Analysis
This SAS script illustrates the creation of a quiz scores dataset using the in-line entry method (DATALINES) and perf...
Restructuring BMI data via Data Step and Arrays
Educational example demonstrating how to transform a 'wide' format dataset (multiple measurement columns per row) int...
String Manipulation
This SAS script demonstrates various string manipulation techniques, including substring extraction, reversal, compre...
Data Filtering and Display with DATA STEP and PROC PRINT
Creates a dataset from integrated raw data, filters records to include only women, and displays the results. This scr...
Processing and Displaying Individual Data
The SAS script creates a dataset named 'prob12_4' using embedded raw data (datalines). It reads the variables NAME, A...
Examples of using PROC TRANSPOSE
This SAS script illustrates various uses of the PROC TRANSPOSE procedure to transform data structure, pivoting rows i...
Many-to-One Merge of SAS Tables
Practical example of merging SAS datasets with a many-to-one cardinality relationship.
Sans titre
Demonstration of one-to-one merging of SAS datasets, including data creation, prior sorting of datasets, and display ...
Practice: Recoding Missing Data
Educational script creating a 'health_study' dataset via datalines. Recoding steps are mentioned in comments but not ...
Interleaving SAS Data Sets
This SAS script demonstrates two methods for combining and sorting (interleaving) data sets: concatenation followed b...
Interleaving SAS Data Sets
Creates and interleaves multiple SAS data sets.
Demonstration: Concatenation of SAS Datasets
This SAS script demonstrates various methods of concatenating SAS datasets, including cases with identical and differ...
First SAS Program: Creating Datasets
Introductory script demonstrating the creation of simple SAS tables using the DATA step and the DATALINES statement.
Cancer Data Analysis and Sorting
This SAS script creates an internal dataset 'work.cancer' from raw cancer data, calculates the total number of deaths...