SAS Input
Description
This step reads files in sas7bdat format created by SAS software (SAS Institute, Inc.).
There are 2 known data types read from these files: Number and String.
This step is extensively using the Sassy Reader project library by eobjects, written by Kasper Sørensen and has a couple of limitations, see also PDI-8969.
Options
There are 2 main options:Â
- 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" step to drive the content of this field. Â IMPORTANT: only local files are supported at this time. You should refrain from using VFS like file specifications.
- 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 Number and String 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.
Limitations
- All the files read by a single copy of a step need to have the same format: they need to contain the same number of columns and the columns need to have identical names and data types.
- For numeric data that contains the value NaN (Not a Number) we convert the value to null (empty)Â