ETL - WeAreCAS

CODE SAS

Modifying SAS Data Sets

This example illustrates the modification of two SAS data sets using the MODIFY statement and its...

CODE SAS

PROC CASUTIL

The CASUTIL procedure offers several table and caslib management functions, including displaying ...

CODE SAS

KEEP Statement

Specifies variables to include in output SAS data sets.

CODE SAS

Export to CSV File

This example explains how to export a SAS dataset to a CSV file using the EXPORT procedure.

CODE SAS

Examples: Prepare Data

This document provides detailed examples on preparing and combining SAS datasets, addressing comm...

CODE SAS

Examples: Combining data one-to-one

This example illustrates combining observations from two datasets using the SET statement. It hig...

CODE SAS

Example: Modifying Data in a SAS Data Set

This example illustrates how to use the `MODIFY` statement in a DATA Step to update a master data...

CODE SAS

Creating an Index

An index is a file associated with a table that allows access to rows by index value. Indexes can...

CODE SAS

Creation of Variables and Data Filtering with DATA Step

This example uses the DATA step to create a data set named CreditQualify. The DATA step creates v...

CODE SAS

Displaying Table Rows

This feature allows viewing specific rows of an in-memory CAS table, with filtering, sorting, and...

CODE SAS

Upload a Local CSV File and Apply SAS Format

This SAS script demonstrates how to upload a local CSV file to a CAS (Cloud Analytic Services) se...

CODE SAS

Loading a CSV file from a server

This script illustrates how to download and load a CSV file located on an external HTTP server in...

CODE SAS

Updating Rows in a CAS Table

This functionality allows modifying existing row values in a CAS table using the `table.update` a...

CODE SAS

Save a SAS7BDAT file to a Caslib

This example shows how to use the 'save' action and the 'exportOptions' parameter to save an in-m...

CODE SAS

PROC CASUTIL: Managing Caslibs and CAS Tables

The CASUTIL procedure provides management functions for caslibs and tables in SAS Cloud Analytic ...

CODE SAS

Modifying SAS Data Sets

This example demonstrates how to modify SAS data sets using the MODIFY statement and subordinate ...

CODE SAS

Load Data from a Zip Archive of CSV Files

Demonstrates how to read a ZIP archive containing multiple CSV files in SAS Viya 4.

CODE SAS

CSV Caslib Loading with Informats

This SAS script demonstrates how to load a CSV file from a CAS caslib and apply SAS informats to ...

CODE SAS

Impute Missing Values with the LAG Function

This script illustrates the use of the LAG function in a DATA Step to impute missing values. The ...

CODE SAS

Examples: Sort and Display Descriptive Information for Data Sets

This article provides practical examples on how to sort SAS data sets and display their descripti...

CODE SAS

Examples: Using a SAS Engine to Process SAS Data

This document provides examples of using various SAS engines (V9, SPD, CVP, CAS) to manipulate an...

CODE SAS

Examples: WHERE Processing

This document provides examples of using WHERE statements and options in SAS for conditional sele...

CODE SAS

Examples: Read and Create CAS Tables

This document provides SAS code examples for interacting with CAS (Cloud Analytic Services) table...

CODE SAS

Examples: Combining data one-to-one

This example illustrates the use of two SET statements to combine observations from two datasets ...

CODE SAS

Examples: Concatenating Data

This document explains how to concatenate SAS datasets using various methods, including the SET s...

CODE SAS

Data Types

This document describes the data types supported by the SAS Viya CAS server, including traditiona...

CODE SAS

Data Compression in SAS Viya

This document describes data compression management for in-memory tables in SAS Cloud Analytic Se...

CODE SAS

Creating a Group-By Table

This example groups the CreditQualify table by State variables and State FIPS codes, then uses Cr...

CODE SAS

Creating Variables and Filtering Data with the DATA Step

This example shows how to use the DATA step to create new variables and conditionally filter data...

CODE SAS

Combining Tables Using the BY Statement

This article explains how to combine SAS tables using the BY statement, presenting scenarios for ...

CODE SAS

Convert a CAS Table to a SAS Dataset

This example shows how to use the DATA step to convert an in-memory CAS table into a local SAS da...

CODE SAS

Applying Labels and Formats

This example applies labels and formats to columns of a CAS table using the ALTERTABLE action, th...

CODE SAS

Sans titre

This action allows you to append the rows of a source table to the end of an existing target tabl...

CODE SAS

Add a CAS table with the WHERE parameter

This feature allows adding rows from a source table to an existing target table in CAS, using the...

CODE SAS

Generation of test data for process simulation

This SAS script generates a synthetic dataset simulating electronic component tests for different...

CODE SAS

Extracting Statistical Data from the KOSIS API

Macro script to extract statistical data from the Korean public API (KOSIS), transform it, and sa...

CODE SAS

Calculating Grades and Averages for Students

This SAS script illustrates different ways to calculate averages, assign grades based on threshol...

CODE SAS

Data Processing and XML Export

This SAS script defines a default data source, retrieves metadata about this source, then exports...

CODE SAS

Creating and Displaying School Grade Data

This SAS script illustrates basic operations of creating data tables via DATALINES, calculating n...

CODE SAS

Loading Data with CAS Connector (Example)

This SAS script demonstrates how to use the SAS data connector to load data from an external rela...

CODE SAS

Example of DATA STEP usage with PROC APPEND

This SAS script illustrates table creation and deletion, particularly managing dependencies when ...

CODE SAS

SAS Table Manipulation (Filtering, Selection, and Formatting)

Fundamental DATA step examples for filtering observations, selecting variables, and applying form...

CODE SAS

MERGE Operations with IN= Option

This SAS script illustrates the use of the MERGE statement with the IN= option to perform differe...

CODE SAS

Executing an iterative DO loop

This script illustrates the use of an iterative DO loop in a DATA step to generate multiple outpu...

CODE SAS

Retirement Savings Plan Simulation

This script simulates the growth of a retirement savings account over 6 years, considering annual...

CODE SAS

Generic Variable Transformation

This SAS script demonstrates the use of `_numeric_` and `_character_` keywords to apply condition...

CODE SAS

PG2 Course Data Generation

Script for creating multiple data tables (CLASS_*, EU_SPORTS, etc.) for the SAS PG2 course.

CODE SAS

Creation of the myLib.smallDataset table

Data generation script creating a table with numerical values and their formatted representation.

CODE SAS

Korean Fiscal Data Extraction and Parsing via API

Script retrieving financial data from the Open Fiscal Data API (Korea) via HTTP requests, followe...

CODE SAS

Direct data reading with index (KEY=)

Demonstration of using the KEY= option in the SET statement for indexed reading.

CODE SAS

Creation of Metadata for Laboratory Variables

This SAS script creates a metadata dataset named 'lb_meta' containing attributes (name, type, len...

CODE SAS

Download and Import Titanic Data

Retrieving the Titanic passenger CSV file from a web server and importing it into a SAS table.

CODE SAS

Exporting tables to Excel via LIBNAME

SAS data export script to an Excel file using the EXCEL library engine.

CODE SAS

Data Transformation and Restructuring with PROC TRANSPOSE

Educational example illustrating data transposition and variable renaming.

CODE SAS

Creation and Display of Internal Data

Basic script creating a dataset from manually entered lines and displaying the result.

CODE SAS

Data Manipulation with LAG Functions

Script illustrating data creation, sorting, and the use of the LAG function to access previous ob...

CODE SAS

Table Creation Via SELECT with SAS/ACCESS

This SAS script illustrates the creation of tables in a relational database via SAS/ACCESS, compa...

CODE SAS

Extracting ORSALES Sales Data

Selection and copying of specific columns from the SASHELP.ORSALES example table.

CODE SAS

Data Simulation and Transformation via Array

Generation of simulated data and complex transformation using arrays and variable retention.

CODE SAS

Sans titre

This SAS script demonstrates the use of the Teradata Parallel Transporter (TPT) option with SAS/A...

CODE SAS

Visualize DATA Step Processing Information with Automatic Variables

This document explains how to use DATA Step automatic variables, especially '_THREADID_', to unde...

CODE SAS

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) environmen...

CODE SAS

Data Formatting and Payroll Calculation

Script illustrating multi-line data reading, derived variable calculation, and application of dis...

CODE SAS

Definition of Nested Formats and Validation

Creation of custom formats with logical nesting and display testing.

CODE SAS

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 ...

CODE SAS

Joining Tables from Multiple Caslibs with fedSql.execDirect

This example shows how to join three external tables using the fedSql.execDirect action. It combi...

CODE SAS

Creation of the Info Table

Basic script illustrating the creation of a SAS table with a single observation.

CODE SAS

Examples of delimiter management with INPUT and INFILE

Series of examples demonstrating various techniques for reading delimited data in a DATA step: ma...

CODE SAS

Concatenation of SAS Tables

This script illustrates several techniques for concatenating (appending) data from one SAS table ...

CODE SAS

Understanding the SUM Statement and Accumulation

Example showing three different methods to perform a cumulative sum in a DATA step.

CODE SAS

Creation of the PAY table with internal data

Creation of a SAS table named PAY from data entered directly into the code via DATALINES.

CODE SAS

Create a View with Two Tables

This SAS script demonstrates how to create a CAS (Cloud Analytic Services) view by joining two ex...

CODE SAS

Detailed Journey of a DATA Step Program

This document describes in detail the steps to execute a DATA Step program in the Cloud Analytic ...

CODE SAS

Amazon Redshift Data Connector

This connector enables the transfer of data between an Amazon Redshift database and SAS Cloud Ana...

CODE SAS

Amazon Redshift Data Connector

This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Se...

CODE SAS

Amazon Redshift Data Connector

This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Se...

CODE SAS

Displaying SASHELP Data and Local Creation

Demonstration script displaying a system table and creating a custom table.

CODE SAS

Example of table merging by identifier

Script illustrating the creation of manual data and their merging via a Data Step.

CODE SAS

Dataset Creation with Datalines and Display

This script creates a SAS dataset from inline data and displays the result.

CODE SAS

Creating and Displaying the prob12_8 Table

Script generating a SAS dataset from embedded data (datalines) and displaying the result.

CODE SAS

Restructuring SAS Tables (Wide to Long and vice versa)

Demonstration of restructuring SAS datasets: converting a 'wide' format (multiple columns per sub...

CODE SAS

Fahrenheit to Celsius Temperature Conversion

Temperature conversion script using arrays and an iterative loop.

CODE SAS

Time Unit Conversion using Arrays and Loops

Data transformation script converting numerical values through iterative processing on grouped va...

CODE SAS

Bonus Calculation and New Salary by Classification

Script for creating a salary table including a conditional bonus calculation based on the employe...

CODE SAS

Table Creation via SELECT (CTAS)

This SAS script demonstrates table creation (CTAS - Create Table As Select) in an external Databa...

CODE SAS

Bulk Loading Data to Snowflake via SAS/ACCESS

This SAS script demonstrates the use of SAS/ACCESS bulk loading functionality to transfer data fr...

CODE SAS

Bulk Data Loading

This SAS script illustrates bulk data loading to an external database via SAS/ACCESS, using the P...

CODE SAS

Bulk Load Example (BULKLOAD)

This SAS script demonstrates the use of the BULKLOAD option to load data into an external databas...

CODE SAS

Bulkload - SAS/ACCESS Greenplum Example

This SAS script demonstrates two methods for bulk loading data into a Greenplum database via SAS/...

CODE SAS

Bulk Data Loading (Bulkload)

This SAS script demonstrates two methods for bulk loading data to an external database (potential...

CODE SAS

Bulk Loading Data

This SAS script demonstrates two methods for bulk loading data into an external relational databa...

CODE SAS

Bulk Load via ODBC to SQL Server

Example of bulk loading data to a SQL Server database via ODBC.

CODE SAS

Bulk Load Programs Example

This SAS script demonstrates bulk loading data from an internally created SAS dataset to an exter...

CODE SAS

Bulkload Example

This SAS script illustrates a bulkload example of data to a DBMS table using SAS/ACCESS. It first...

CODE SAS

Amazon Redshift Data Connector

This connector allows data transfer between an Amazon Redshift database and SAS Cloud Analytic Se...

CODE SAS

Creation of a large synthetic dataset

This SAS script generates a large dataset named `biggerDataset` in the `myLib` library, populatin...

CODE SAS

OpenFiscalData API Extraction and Parsing

Script automating the retrieval of public financial data via a Korean REST API (OpenFiscalData). ...

CODE SAS

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 S...

CODE SAS

Reading and Correcting Delimited Data with Missing Delimiters

This SAS script illustrates how to handle and correct the reading of delimited data files when so...

CODE SAS

Difference Table Creation and Indexing Macro

This SAS macro creates or updates the structure of a SAS table (`DIFFTABLE` by default) intended ...

CODE SAS

Analysis and merging of corporate and financial data

This SAS script creates and manipulates two internal datasets ('company' and 'finance') from in-l...

CODE SAS

Data Creation for Proportions Test

This SAS script prepares an internal dataset for subsequent statistical analysis of proportion di...

CODE SAS

Comparison of variable length definition methods

Demonstration of the impact of character variable initialization on their length and the risk of ...

CODE SAS

Management of Location Data and SAS Utility Macros

This script combines the creation and updating of location data with SAS utility macro definition...

CODE SAS

Reading Dates with Error Suppression

Script illustrating date import with silent handling of invalid values.

CODE SAS

Leap Year Detection

This SAS script identifies and lists all leap years between 2000 and 2200, creating a SAS dataset...

CODE SAS

Customer Table Creation

SAS script for creating a table named 'customer' from data included in the code.

CODE SAS

JSON Generation of a SAS Table

This SAS script converts the SASHELP.ORSALES table into JSON format and writes it to the '_webout...

CODE SAS

Processing and consolidation of department data

This SAS script creates two datasets (`research_development` and `Publication`) from internal dat...

CODE SAS

CASL and FedSQL Join Examples

This SAS script demonstrates different methods for performing joins on baseball data within the S...

CODE SAS

Data Filtering with the IN operator

Creating a data subset by filtering on the age variable using the IN operator.

CODE SAS

Format Management and Data Transformation

This SAS script defines and uses formats to standardize and transform date data as well as catego...

CODE SAS

CSV Data Import and Verification

This SAS script imports an external CSV file (`np_traffic.csv`) into a SAS table named `traffic`,...

CODE SAS

Creating and Displaying Student Data

This SAS script demonstrates the creation and manipulation of simple datasets from in-line data (...

CODE SAS

Appending two CAS tables

This SAS script demonstrates how to append the content of one CAS table (CARS2) to another existi...

CODE SAS

Character to VARCHAR type conversion when loading into CAS

This SAS script demonstrates how to convert character variables to VARCHAR type when loading a ta...

CODE SAS

Student Grades Analysis and Status Assignment

The SAS script creates two student datasets from raw data. It calculates the average scores and a...

CODE SAS

Export data to text file

Script exporting manually entered data to a text file.

CODE SAS

FASTFORMAT Format Definition

This script defines a custom SAS format named FASTFORMAT that maps textual values to 'Diesel' or ...

CODE SAS

Data Generation and Export to XML

Script illustrating the creation of a SAS table and its direct writing to an XML file.

CODE SAS

Export SASHELP.CLASS to CSV

Exporting data from the SASHELP.CLASS table to a local CSV file.

CODE SAS

SASHELP data analysis and display

This simple SAS script reads the example dataset `sashelp.prdsale` and displays the content of sp...

CODE SAS

SAS CI360 Data Extraction and Loading

Authentication and retrieval of data files from SAS Customer Intelligence 360.

CODE SAS

Managing Current Dates and Times

This SAS script creates a dataset containing the current date, time, and datetime, then displays ...

CODE SAS

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...

CODE SAS

Classification of smoker and non-smoker risk groups

Risk level classification script based on smoking status and blood pressure.

CODE SAS

Analysis and Processing of Conference Participant Data

This SAS script reads conference participant data from an external file, performs transformations...

CODE SAS

Weight Loss Survey Data Processing and Cleaning

This SAS script reads raw survey data from an external file, performs variable cleaning and recod...

CODE SAS

Using the TRANWRD() Function

Demonstration of using the TRANWRD() function to replace substrings in a character variable.

CODE SAS

Cumulative Sum Calculation

This simple SAS script illustrates the use of a sum statement to calculate a cumulative sum withi...

CODE SAS

Table Creation with PROC DS2

This script uses PROC DS2 to create a new table named 'tatat' from the SASHELP.CLASS dataset, whi...

CODE SAS

Excel Export and External Script Execution

This SAS script exports an internal dataset to an Excel file, then executes an external VBScript ...

CODE SAS

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...

CODE SAS

ETL Macro for Loading CAS Dimension

Macro to load and persist a dimension table in the CAS environment.

CODE SAS

ETL Job Status Configuration

Macro to configure the ETL job status file which will store the status of each job.

CODE SAS

Analysis and Transformation of Automotive Data with CAS

This SAS script configures the CAS environment, loads data from SASHELP to CAS, and then applies ...

CODE SAS

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 ...

CODE SAS

Using the ?? modifier in INPUT

Example of using the ?? modifier to suppress read error messages.

CODE SAS

Export SASHELP.CLASS data to CSV

This SAS script exports the content of the standard SASHELP.CLASS table to a CSV file named class...

CODE SAS

Exporting Data to CSV

Exports the sashelp.class table to a CSV file.

CODE SAS

Manipulating Date and Datetime Formats with ANYDATE

This SAS script demonstrates the use of ANYDATE informats to read and convert different date and ...

CODE SAS

Data Creation and Deduplication with PROC SORT

This SAS script creates an internal dataset, then demonstrates two deduplication methods using PR...

CODE SAS

Downloading FRED Economic Data

SAS macro to download specific economic data from the FRED (Federal Reserve Economic Data) databa...

CODE SAS

SDTM DM Dataset Creation

This SAS script configures the environment, generates a Demographics (DM) domain dataset for SDTM...

CODE SAS

Creation of Metadata for the DM Table

This SAS script creates a dataset containing metadata (column name, type, length, label) for a 'D...

CODE SAS

Investment Simulation over 5 Periods

Calculation of the future value of investments over 5 iterations via a loop.

CODE SAS

Demonstration of DO loops in SAS

This script illustrates the difference between repetitive manual calculation and the use of a DO ...

CODE SAS

Date and Time Manipulation and Formatting

This SAS script demonstrates the creation, manipulation, and formatting of date and time variable...

CODE SAS

Date component extraction and manipulation

Script illustrating the extraction of temporal elements (day, month, year, quarter, weekday) from...

CODE SAS

Dataset creation with heterogeneous dates

Example of reading dates in different formats (text, numeric) in a DATA step.

CODE SAS

Implementation and Comparison of the '_INFILE_' Technique for Data Delimitation

This SAS script demonstrates and compares two methods for delimiting complex character strings in...

CODE SAS

DATA Step Partitioning and Sorting in CAS

Example of optimizing data loading into CAS with partitioning and sorting, followed by group proc...

CODE SAS

CAS Table Partitioning and Sorting

Demonstration of CAS performance optimization through data partitioning and sorting during loading.

CODE SAS

Using LAG and DIF Functions

This SAS script demonstrates the use of LAG and DIF functions within a DATA STEP to create new va...

CODE SAS

Creating permanent and temporary SAS tables

SAS script demonstrating the creation of a permanent and a temporary data table from internal dat...

CODE SAS

Creation of sample addresses

This SAS script creates a dataset containing sample addresses from various locations using embedd...

CODE SAS

Creation of a 'ratings' dataset

This script creates a SAS dataset named 'ratings' containing numerical ratings and their associat...

CODE SAS

Creation of the PROPERTY_COSTREVENUE table via DATALINES

Creates the temporary table WORK.PROPERTY_COSTREVENUE from data integrated directly into the SAS ...

CODE SAS

Creation of historical sales data

This SAS script creates a dataset named WORK.SALES_HISTORIC containing historical sales data for ...

CODE SAS

Monthly Sales Table Creation

Generation of a dataset containing monthly sales per account manager.

CODE SAS

Creation and Addition of ContactType Data

This SAS script creates a temporary dataset `work.ContactType` from literal data (datalines) and ...

CODE SAS

Table creation and column filtering

Script creating a table with dynamic variable selection and displaying the result.

CODE SAS

Case Management in SAS String Comparisons

This SAS script demonstrates different methods of managing case during string comparisons to assi...

CODE SAS

Calculation of New Columns and Formatting

This program uses a DATA step to create a new table from SASHELP.CARS, by filtering data, calcula...

CODE SAS

Data Creation with Variable Filter and Display

Generation of a temporary table filtering variables by prefix, followed by its printing.

CODE SAS

Test of the LENGTH function

Simple demonstration of the LENGTH function's behavior on various character strings.

CODE SAS

Simplified String Concatenation

Demonstration of CATX function's efficiency for string concatenation compared to traditional meth...

CODE SAS

Merging datasets and creating reports

This SAS script creates two datasets, sorts them, then merges them in different ways (standard, i...

CODE SAS

SAS Data Concatenation and Appending Techniques

Comparative demonstration of three methods to concatenate datasets: Data Step, Append Procedure (...

CODE SAS

Data Creation and WORK Library Management

The script creates a temporary SAS dataset named THREEROWS and executes PROC DATASETS on the WORK...

CODE SAS

Applying COMMA Numeric Format

Creation of a dataset and application of a thousands separator format.

CODE SAS

Creation and formatting of monetary data

Creation of a table with formatted monetary values and metadata analysis.

CODE SAS

BMI Calculation via Data Step

Simple Body Mass Index (BMI) calculation with output to the log.

CODE SAS

Creating and Displaying the CEREAL Dataset

This SAS script creates a `work.cereal` dataset using embedded data via `datalines`, then display...

CODE SAS

Creation of the THREEROWS table

Creation of a simple SAS table with data included in the code.

CODE SAS

Managing VARCHAR data in CAS

This SAS script illustrates the creation of a SAS table with long character columns, its loading ...

CODE SAS

Loading and Manipulation of Baseball Data in CAS

This SAS script loads the 'baseball' dataset from the SASHELP library into a CAS library ('casuse...

CODE SAS

CAS Joins with Deep Learning and Search Analytics

This SAS script initializes a CAS session and performs data joins using the dlJoin actions from t...

CODE SAS

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 si...

CODE SAS

Reading and Manipulating Date Variables with Datalines

This SAS script illustrates the reading and manipulation of date variables from internal data (da...

CODE SAS

Data Reading and Sorting Exercises (US Presidents & Pumpkin)

Exercise script illustrating different techniques for reading raw data (Column input, pointers) a...

CODE SAS

Simple Data Creation and Transformation

Basic example of data creation, variable calculation, and display.

CODE SAS

Advanced Inventory and Purchase Data Manipulation

This SAS script demonstrates fundamental and advanced data manipulation techniques. It includes c...

CODE SAS

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...

CODE SAS

Sans titre

This SAS script creates a dataset of student scores, sorts it, and identifies duplicate scores, r...

CODE SAS

Creation of the MYLIB.CLASS1 table

This SAS script creates a table named CLASS1 in the MYLIB library using instream data (datalines).

CODE SAS

Explanation of PROC IMPORT

This document explains in detail the use of the PROC IMPORT procedure to import data from various...

CODE SAS

Converting character string to numeric value

Script demonstrating the conversion of a character variable containing separators to numeric format.

CODE SAS

Student Data Management with Sorting and Deduplication

This SAS script creates a 'CLASSTEST' table from embedded data, then generates a new table 'CLASS...

CODE SAS

Creating and Displaying an In-Stream Dataset

This SAS script creates a dataset named 'instream_mtcars' from in-line provided data and then dis...

CODE SAS

Simple Data Creation and Filtering

Demonstration script creating an internal table and displaying a subset.

CODE SAS

Currency management and display

This SAS script illustrates the use of different formats for entering and displaying monetary val...

CODE SAS

Date Processing and Display

This SAS script demonstrates the creation of two datasets ('userinfo' and 'julinedata') using `da...

CODE SAS

Data Cleaning and Display (Duplicate Removal)

This SAS script creates a 'classtest' data table, cleans it by removing entirely duplicated rows ...

CODE SAS

Creating and Sorting Class Data

This SAS script creates a student data table, then sorts it by subject in ascending order and by ...

CODE SAS

In-Stream Data Creation and Display

This SAS script creates a dataset named 'instream_mtcars' from data provided directly within the ...

CODE SAS

Date manipulation with INTNX and INTCK

Demonstration of SAS INTNX and INTCK functions for manipulating and calculating date differences.

CODE SAS

Transposing the SASHELP.CLASS table

Simple example of transposing columns into rows using the CLASS table.

CODE SAS

Creating and Displaying Instream Data

This SAS script creates a temporary dataset 'instream_mtcars' from instream data provided directl...

CODE SAS

Quiz Score Creation and Analysis

This SAS script illustrates the creation of a quiz scores dataset using the in-line entry method ...

CODE SAS

Restructuring BMI data via Data Step and Arrays

Educational example demonstrating how to transform a 'wide' format dataset (multiple measurement ...

CODE SAS

String Manipulation

This SAS script demonstrates various string manipulation techniques, including substring extracti...

CODE SAS

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 t...

CODE SAS

Processing and Displaying Individual Data

The SAS script creates a dataset named 'prob12_4' using embedded raw data (datalines). It reads t...

CODE SAS

Examples of using PROC TRANSPOSE

This SAS script illustrates various uses of the PROC TRANSPOSE procedure to transform data struct...

CODE SAS

Many-to-One Merge of SAS Tables

Practical example of merging SAS datasets with a many-to-one cardinality relationship.

CODE SAS

Sans titre

Demonstration of one-to-one merging of SAS datasets, including data creation, prior sorting of da...

CODE SAS

Practice: Recoding Missing Data

Educational script creating a 'health_study' dataset via datalines. Recoding steps are mentioned ...

CODE SAS

Interleaving SAS Data Sets

This SAS script demonstrates two methods for combining and sorting (interleaving) data sets: conc...

CODE SAS

Interleaving SAS Data Sets

Creates and interleaves multiple SAS data sets.

CODE SAS

Demonstration: Concatenation of SAS Datasets

This SAS script demonstrates various methods of concatenating SAS datasets, including cases with ...

CODE SAS

First SAS Program: Creating Datasets

Introductory script demonstrating the creation of simple SAS tables using the DATA step and the D...

CODE SAS

Cancer Data Analysis and Sorting

This SAS script creates an internal dataset 'work.cancer' from raw cancer data, calculates the to...