[Skip Global Navigation]

Training

Table of Contents — Data Management & Manipulation with SPSS

Choices In Running SPSS

Different Modes Of Running SPSS
Menus And Dialogs
SPSS Syntax Editor And SPSS Commands
SPSS Production Mode Facility
When To Use The Different Modes
Summary Exercises

Further Data Transformation Features

Introduction
Automatic Recode
Counting Values Across Variables
If Conditions
Do Ifelse If Logic
Conditional Count Transformation
Summary Exercises

Computing Numeric Variables

Introduction
Using Functions In SPSS
The Any And Range Functions
Missing Functions
Useful System Variables
Summary Exercises

Computing Date, Time, And String Variables

Introduction
Working With Dates And Times
Converting String Variables To Date Variables
String Transformations
Summary Exercises

Helpful Data Management Features

Introduction
Identifying Duplicate Cases
Custom Variable Attributes
Variable Sets
Saving Selected Variables
Displaying SPSS Data File Properties
Directing Output To A Different Viewer Window
Summary Exercises

Aggregating Data

Introduction
Data Aggregation
Aggregate The Country Data To A Separate Region File
Aggregate Region Variables To The Country File
Summary Exercises

Merging Files – Adding Cases

Adding Cases In SPSS
Checking The SPSS Data File
Reading The Dbase File
Adding The Files
Exploring The Combined File
Testing Mean Differences – T Test
Appendix: Adding Cases From More Than Two Files
Summary Exercises

Merging Files – Adding Variables

Introduction
Considerations In File Merging
A One-To-One Match
Measuring Change
Reporting The Changes
A One-To-Many Match
A One-To-Many Match Example
Appendix: Adding Variables From More Than Two Files
Summary Exercises

Editing Charts And Pivot Tables

Introduction
Chart Templates
Setting A Default Chart Template
Editing Pivot Tables
Rules For Editing Pivot Tables
Table Properties
Editing Cell Properties
Showing And Hiding Cells
Creating Category Groups
Rotating Labels
Summary Exercises

Deployment Of SPSS Results

Introduction
Three Types Of SPSS Output
Activex And SPSS
Moving Pivot Table Output To Other Applications
Pasting Pivot Tables Into Spreadsheets
Pasting Standard Graphics From SPSS
Moving Text Output From SPSS To Word Processors
Exporting SPSS Output
SPSS Output Management System
Summary Exercises

Controlling The SPSS Environment

SPSS Options
General Tab
Viewer Tab
Draft Viewer Tab
Output Labels Tab
Charts Tab
Pivot Tables Tab
Data Tab
Scripts Tab
Using The Set Command

Appendix A: Optimal Binning With The SPSS Data Preparation Module

A1 Introduction A-1
A2 The Basics Of Optimal Binninga-1
A3 Binning Hours Workeda-2
A4 Example 2: Binning Predictors For Modeling A-9
Summary Exercisesa-17

Resources