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

Chapter 5. Data Preparation – Integrate and Format

In this chapter, we will cover:

  • Speeding up a merge with caching and optimization settings
  • Merging a lookup table
  • Shuffle-down (nonstandard aggregation)
  • Cartesian product merge using key-less merge by key
  • Multiplying out using Cartesian product merge, user source, and derive dummy
  • Changing large numbers of variable names without scripting
  • Parsing nonstandard dates
  • Parsing and performing a conversion on a complex stream
  • Sequence processing

Introduction

This set of recipes contains tricks and shortcuts for tasks that most analysts would anticipate as central to data preparation. Two subtasks are addressed, integrate and format. The first four recipes involve aspects of integration and the last two involve ...

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