Convert CDISC ISO8601 Character Date to Numeric

3 Kudos

This add-in converts a CDISC ISO8601 character variable into a separate numeric date or date-time variable that can make filtering easier. For the current data table, the add-in only lists the available character variables that end in DTC, which would include all date-time fields in CDISC domains. The sample data set is not CDISC, but it allows you to get a sense of how the add-in works.

Window Capture.png

Running the above on the following table

Window Capture2.png

will create a numeric version of the column

Window Capture3.png

Creating a data filer on the numeric date allows you to select a range of dates.

Window Capture4.png

Compare this to a filter on the character version of the date that only allows for selecting specific dates.

Window Capture5.png

jenkins_macedo · ‎06-27-2017

Why the current formula option in JMP Pro has the ability to do this that usually requires creating new columns and using the appropriate formulas to generate the date or datetime value desire. The Add-in gives us an added edge to making this process simple and quick.