O'Reilly logo

JMP 11 Scripting Guide by SAS Institute

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Convert Character Dates to Numeric Dates
Data might appear to be numeric in the data table. However, the column properties specify a character data type. To manipulate the data as date/time values, you must convert the column to a numeric column.
Convert Dates.jsl (Figure 16.1) creates a data table, converts the character column to numeric, and applies the y/m/d format by sending messages to the column (Figure 16.2).
Figure 16.1 Script for Converting Character Dates to Numeric Dates
Script for Converting Character Dates to Numeric Dates
Figure 16.2 Converting Character Dates (Before and After)
Converting Character Dates (Before and After)

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required