CASL and FedSQL Join Examples

This SAS script demonstrates different methods for performing joins on baseball data within the SAS Viya 4 environment, using both FedSQL and CASL actions specific to the deepLearn and searchAnalytics action sets.

View this code now

Codes in same category

Modifying SAS Data Sets

This example illustrates the modification of two SAS data sets using the MODI...

PROC CASUTIL

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

KEEP Statement

Specifies variables to include in output SAS data sets.

Export to CSV File

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

Examples: Prepare Data

This document provides detailed examples on preparing and combining SAS datas...

Examples: Combining data one-to-one

This example illustrates combining observations from two datasets using the S...

Example: Modifying Data in a SAS Data Set

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

Creating an Index

An index is a file associated with a table that allows access to rows by inde...

Creation of Variables and Data Filtering with DATA Step

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

Displaying Table Rows

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

Upload a Local CSV File and Apply SAS Format

This SAS script demonstrates how to upload a local CSV file to a CAS (Cloud A...

Loading a CSV file from a server

This script illustrates how to download and load a CSV file located on an ext...

ETL