IBM SPSS Modeler Cookbook

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 ...