cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Convert CDISC ISO8601 Character Date to Numeric

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

Comments

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.