SAS Date Node

SAS stores Date, Time, and Datetime values as numeric columns using values that are not typical (based on 1/1/1960). A simple formula in a Transform node can be used to convert the numbers into the appropriate date/time values, but for users that have many columns to convert, this can quickly become tedious.

The SAS Date node creates new columns converting the SAS numeric representations in bulk. This can be done either by selecting the columns to convert, or using column name pattern matching. 

To use the node:

1. Connect the SAS Date node anywhere in a job where data is coming from a SAS data source
2. In the Convert To field, enter one of: "Datetime", "Date", or "Time" to convert columns to that data type.
3. Use the Columns to Convert field to specifically select columns to convert, click the X button to clear the parameter, click ellipsis [...] button to open a dialog to pick columns.
4. Use the Column Name Pattern field to match column names by entering Regular Expression (RegEx) code. Example: "*Date*" matches all fields with "Date" anywhere in the name.

Note: The 2nd and 3rd parameters can both be used, or one or the other.