Hub
ComponentComponent

SAS Date to KNIME Conversion

Ivan Pažin profile image

Last edited: 

Drag & drop
Like
Use or download
Copy short link
This Component converts SAS dates to KNIME dates. SAS dates in KNIME are read as doubles and represent number of days since SAS start date which is 01.01.1960. Manipulation works in a way that those double columns are converted to duration and then SAS start date is shifted inside loop for each "date" column.

Component details

Input ports
  1. Type: Table
    Input data
    SAS sample data set with dates read as doubles
Output ports
  1. Type: Table
    Output data
    SAS sample data set with dates converted to KNIME dates

Used extensions & nodes

Created with KNIME Analytics Platform version 4.5.2
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.2

    knime
  • KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

    knime
  • KNIME Math Expression (JEP) Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.0

    knime
  • KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.5.2

    knime