SAS Input

Description

This transform reads files in sas7bdat format created by SAS software (SAS Institute, Inc.). The functionality is backed by the Parso java library which you can find over here.

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

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