O'Reilly logo

IBM SPSS Modeler Cookbook by Scott Mutchler, Tom Khabaza, Meta S. Brown, Dean Abbott, Keith McCormick

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

Parsing nonstandard dates

The KDD98 data set uses a YYMM date format, which is not one of the supported date formats in Modeler. In this recipe we will use Derive nodes to parse the existing date information and reassemble it into a supported format. In this recipe we will extract the month portion of information contained in a variable that combines the month and year in a string. The starting stream has already addressed the year information. We will modify the stream so that it also addresses the month information.

Getting ready

We will start with the Parsing Nonstandard Dates.str stream, which uses the cup98lrn reduced vars2.txt data set.

How to do it...

  1. Open the Parsing Nonstandard Dates.str stream.
  2. Run a preview of the Derive node. Scroll to ...

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