Book Image

IBM SPSS Modeler Cookbook

Book Image

IBM SPSS Modeler Cookbook

Overview of this book

IBM SPSS Modeler is a data mining workbench that enables you to explore data, identify important relationships that you can leverage, and build predictive models quickly allowing your organization to base its decisions on hard data not hunches or guesswork. IBM SPSS Modeler Cookbook takes you beyond the basics and shares the tips, the timesavers, and the workarounds that experts use to increase productivity and extract maximum value from data. The authors of this book are among the very best of these exponents, gurus who, in their brilliant and imaginative use of the tool, have pushed back the boundaries of applied analytics. By reading this book, you are learning from practitioners who have helped define the state of the art. Follow the industry standard data mining process, gaining new skills at each stage, from loading data to integrating results into everyday business practices. Get a handle on the most efficient ways of extracting data from your own sources, preparing it for exploration and modeling. Master the best methods for building models that will perform well in the workplace. Go beyond the basics and get the full power of your data mining workbench with this practical guide.
Table of Contents (11 chapters)
10
Index

Building transformations with multiple Derive nodes


In this recipe we will create several new variables with a single Derive node by invoking the multiple radio button.

Getting ready

This recipe uses the datafile cup98lrn_reduced_vars3.sav and the stream Recipe - variable construct multiple derive.str.

How to do it...

  1. Open the stream Recipe - variable construct multiple derive.str by clicking on File | Open Stream.

  2. Make sure the datafile points to the correct path to the datafile cup98lrn_reduced_vars3.sav.

  3. Add a Derive node to the stream and connect it to the Type node called First Type.

  4. Open the Derive node, click on the Multiple radio button. In the Derive from region, select all of the RFA variables, from RFA_2 to RFA_24. You can select multiple variables by clicking on RFA_2, scrolling down to RFA_24 and Shift-clicking on RFA_24. Then click on OK.

  5. In the Field name extension box, change the text _Derive to R.

  6. In the Field Type drop-down list, select Nominal. This is shown in the following screenshot...