Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
IBM SPSS Modeler Essentials

You're reading from   IBM SPSS Modeler Essentials Effective techniques for building powerful data mining and predictive analytics solutions

Arrow left icon
Product type Paperback
Published in Dec 2017
Publisher Packt
ISBN-13 9781788291118
Length 238 pages
Edition 1st Edition
Concepts
Arrow right icon
Authors (2):
Arrow left icon
Keith McCormick Keith McCormick
Author Profile Icon Keith McCormick
Keith McCormick
Jesus Salcedo Jesus Salcedo
Author Profile Icon Jesus Salcedo
Jesus Salcedo
Arrow right icon
View More author details
Toc

Sorting cases


At times it is useful to see if any values look unusual. The Sort node arranges cases into ascending or descending order based on the values of one or more fields. It also helps in the optimization of other nodes so that they perform more efficiently:

  1. Place a Sort node from the Record Ops palette onto the canvas.
  2. Connect the Select node to the Sort node.
  3. Edit the Sort node.

You can sort data on more than one field. In addition, each field can be sorted in ascending or descending order:

  1. Click on the Field Chooser button.
  2. Select Age in the Sort by: fieldbox.
  3. Click OK:

We will now rank the age cases in ascending order (the youngest people will be at the top of the file and the oldest people will be at the bottom of the file):

  1. Click OK.

Now let's take a look at the results from the Sort node:

  1. Connect the Sort node to a Table node.
  2. Run the Table node:

Notice that there are no longer any children in this file, as the youngest people in the dataset are 18 years old.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image