SAS Input

Description

The SAS Input transform reads files in sas7bdat format created by SAS software (SAS Institute, Inc.).

The functionality is backed by the Parso java library.

Supported Engines

Hop Engine

Supported

Spark

Supported

Flink

Supported

Dataflow

Supported

Options

Option	Description
Transform name	Name of the transform this name has to be unique in a single pipeline.
Field in the input to use as filename	Select the input field that will contain the filename at runtime. For example, you can use a "Get file names" transform to drive the content of this field.
Limit	Stop reading after the specified number or rows. If nothing is specified or a number smaller than or equal to zero, all rows in the SAS files will be read. This can be used to read a single row from a large SAS file when all you want to do is add a Metadata Structure From Stream transform to determine the file layout.
The selected fields from the files	If you use the "Get Fields" button you can populate this data grid. Please note that even though the sas7bdat file format only contains certain formats, that you can specify any desired data type and that Apache Hop will convert for you. Also note that not all fields need to be specified and that you can re-order fields and give them new names. The selection of the fields will be based on the name column.

Option

Description

Transform name

Name of the transform this name has to be unique in a single pipeline.

Field in the input to use as filename

Select the input field that will contain the filename at runtime. For example, you can use a "Get file names" transform to drive the content of this field.

Limit

Stop reading after the specified number or rows. If nothing is specified or a number smaller than or equal to zero, all rows in the SAS files will be read. This can be used to read a single row from a large SAS file when all you want to do is add a Metadata Structure From Stream transform to determine the file layout.

The selected fields from the files

If you use the "Get Fields" button you can populate this data grid. Please note that even though the sas7bdat file format only contains certain formats, that you can specify any desired data type and that Apache Hop will convert for you. Also note that not all fields need to be specified and that you can re-order fields and give them new names. The selection of the fields will be based on the name column.