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

Reformatting data for reporting with a Transpose node

The Transpose node is very useful for restructuring data. One way it can be particularly helpful is with reporting of results, especially when the data has many more columns than rows.

Getting ready

This recipe uses the datafile cup98lrn_reduced_vars3.sav and the stream Recipe – report with transpose.str.

How to do it...

To reformat data with a Transpose node:

  1. Open the stream Recipe – report with transpose.str by navigating to File | Open Stream.
  2. Make sure the datafile points to the correct path to cup98lrn_reduced_vars3.sav.
  3. Insert an Aggregate node and connect it to the Type node.
  4. Open the Aggregate node and in the Key fields: area, select TARGET_B as the field to aggregate. In the Default Mode: ...

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