Accessing Data

See also Data Sources Listed Alphabetically for SAS Cloud Analytic Services (CAS) and the SAS Compute Server.

I have a file on my PC

Transfer data from a SAS library to the CAS server using PROC CASUTIL

Upload a CSV file and apply an informat to ensure proper interpretation of values

Import XLSX data to a CAS table

I have a file in a shared file system that CAS can access

Load a previously saved SASHDAT file with CASL

Load a CSV file from a caslib and apply an informat

Upload a CSV file from a server

I have a table in a database server

Use SAS/ACCESS engines to access data in a database. After CAS reads the data and creates an in-memory table, the table can be operated on by actions.

Establish a connection between your Google BigQuery source data and a caslib

Load data from an OBDC database into CAS

Load Oracle data into CAS

Load a database table

I have an object in cloud storage

SAS can access data from an object store and then transfer the data to CAS.

Load data frorm Azure Data Lake Storage (ADLS) to a caslib

Load data from an S3 data source to a caslib

Other Frequently Used Tasks

Add, save, and drop in-memory tables

Use SAS procedures to transfer data from the CAS server

Load data in a CSV file to an in-memory table in CAS

Import a delimited external file and create a temporary SAS data set

Associate a SAS library with a libref, or shortcut name, using the Global LIBNAME statement

Specialty LIBNAME Engines

Import an XML document using the XML LIBNAME Engine

Use JSON from a URL Access Method fileref

Use the DATA step to create a new SPD Engine data set

Last updated: December 20, 2022