Skip to main content

SAS Data Sets

SAS Data Sets are the native data storage format used in SAS, designed to efficiently store and manage structured data. They support advanced analytics by providing fast access, compression, and integration with SAS procedures and tools. The SAS data sets connector provides access to SAS data files (.sas7bdat), enabling import and export of statistical datasets commonly used in analytics workflows within SAS environments.

important

Using this connector requires an add-on license, included in the custom connectors package.

Prerequisites​

Before connecting, ensure the following prerequisites are met:

  • Verify that the storage or folder location is accessible from the cluster.
  • Gather valid user credentials and ensure the user has appropriate permissions to read the files.
  • Ensure at least one file is present in the folder.

Connecting to FTP​

Anonymous Authentication​

Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *    Name that uniquely identifies the connection.Product_file_conn
Driver *Driver used to establish the connection. By default, one driver is available.SAS Data Sets JDBC
Host *IP address or hostname of the FTP server.ftp.acme.com or 193.164.68.41
Port *The port on which the server listens. Default: 21 for FTP.21
Folder Path *The directory path within the server leading to the folder containing SAS files./data/prod-files/
Type *For anonymous authentication, the connection type must be a System Connection. Refer Connections for more details.System

Username and Password Authentication​

Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *   Name that uniquely identifies the connection.Product_file_conn
Driver *Driver used to establish the connection. By default, one driver is available.SAS Data Sets JDBC
Host *IP address or hostname of the FTP server.ftp.acme.com or 193.164.68.41
Port *The port on which the server listens. Default: 21 for FTP.21
Folder Path *The directory path within the server leading to the folder containing SAS files./data/prod-files/
Type *The connection type – either System Connection or User Connection. Refer Connections for more details.System
Username *FTP login username with necessary privileges.ftp_user
Password *Password associated with the specified username.Str0ngSAS@2025

Connecting to Google Cloud Storage​

Service Account Authentication​

Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *   Name that uniquely identifies the connection.Product_file_conn
Driver *Driver used to establish the connection. By default, one driver is available.SAS Data Sets JDBC
Project ID *The unique identifier of the Google Cloud project where the storage bucket resides.acme-gcp-project-5726
Container *Name of the storage bucket where the SAS files are stored.prod-data-container
Folder Path *The directory path within the bucket leading to the folder containing SAS files./data/prod-files/
Type *For service account authentication, the connection type must be a System Connection. Refer Connections for more details.System

Connecting to Local Storage​

Users can read files from local storage, which may refer to a server directory for uploaded files or a network-mounted directory accessible to the cluster. Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *  Name that uniquely identifies the connection.Product_file_conn
Driver *Driver used to establish the connection. By default, one driver is available.SAS Data Sets JDBC
Folder Path *The directory path leading to the folder containing SAS files./data/prod-files/
warning

This connector does not support authentication for accessing files from local storage.

Connecting to SFTP​

Username and Password Authentication​

Use one or more properties from the table below to create a valid connection. Properties marked with an asterisk (*) are required.

NameDescriptionExample Values
Connection Name *   Name that uniquely identifies the connection.Product_file_conn
Driver *Driver used to establish the connection. By default, one driver is available.SAS Data Sets JDBC
Host *IP address or hostname of the SFTP server.sftp.acme.com or 193.164.68.41
Port *The port on which the server listens. Default: 22 for SFTP.22
Folder Path *The directory path within the server leading to the folder containing SAS files./data/prod-files/
Type *The connection type – either System Connection or User Connection. Refer Connections for more details.System
Username *SFTP login username with necessary privileges.reporting_user
Password *Password associated with the specified username.Rep0rtSAS@2025

Supported Datatypes​

The following data types are supported:

  • SMALLINT
  • INTEGER
  • DECIMAL
  • FLOAT
  • BIGINT
  • REAL
  • VARCHAR
  • CHAR
  • NCHAR
  • TEXT
  • BOOLEAN
  • BFILE
  • CLOB
  • BLOB
  • RAW
  • DATE
  • TIMESTAMP
  • TIMESTAMP_WITH_TIMEZONE

Unsupported Datatypes​

The following data types are not supported:

  • LISTS
  • DICTS
  • SETS
  • ARRAYS
  • STRUCTS
  • JSON / XML
  • COMPLEX TYPES (Map, Image, Binary Blobs beyond CHAR representation)
Last updated on