IBM: Data Management and Manipulation with IBM SPSS Statistics SPVC

Useful data management functions

• Read data using options available in the Database Wizard.
• Compare datasets.
• Sort variables by any attribute and customise the display of variable attributes.
• Generate variable attribute information for variables in a data file.
• Create and use variable sets.

Transformations: computing with date and time variables

• Learn how dates and times are represented in IBM SPSS Statistics.
• Create a date or time variable.
• Distinguish date and time functions in the variable dialog box.
• Explain default options for date variables with a 2-digit year.
• Use and understand the Date and Time Wizard.

Transformations: computing with numeric data

• Use the variable dialog box to create new variables and transform data.
• Use functions to perform transformations.
• Create and add additional variable attributes.

Additional data transformations

• Use Automatic Recode to easily recode string variables into numeric variables.
• Use the Count Values transformation to count values across variables.

Restructuring data and identifying duplicate cases

• Use IBM SPSS Statistics dialog box features.
• Recognise when data restructuring is necessary.
• Identify duplicate cases.
• Use the Data Restructure Wizard features.

Merging files: adding variables

• Describe the difference between one-to-one and one-to-many matching.
• Describe and use Add Variables dialog box features.
• Check whether files have been successfully matched.
• Merge data files without sorting them beforehand.

Merging files: adding cases

• Describe and use Add Cases dialog box features.
• Explain variable formats so files can be appended.
• Handle variables with different names in files to be appended.
• Check whether files have been successfully appended.

Analysing multiple-response questions

• Explain how multiple-response questions are coded in a data file.
• Explain multiple-response sets in IBM SPSS Statistics.
• Use multiple-response Crosstabs and Frequencies procedures.

Using charts

• Use Chart Editor features.
• Create and apply custom chart templates by modifying graphical aspects using Chart Editor options.

Aggregating data

• Describe the features of the Aggregate Data procedure.
• Create several summaries from a variable.
• Create a new data file with aggregated results.
• Add aggregated results to the original data file.

Controlling the IBM SPSS Statistics environment

• Reset the variable display.
• Describe Options dialog box features.
• Explain default working data folders.
• Change transformation options for variables.

Introduction to the output management system

• Describe Output Management System capabilities.
• Describe and use OMS Control Panel features.
• Use the Output Management System to exclude items from the IBM SPSS Statistics Viewer.
• Use the Output Management System to export pivot tables to other applications.

Automating IBM SPSS Statistics

• Describe and use Syntax Editor features.
• Make simple syntax changes.
• Describe and use Production Facility dialog box features.
• Run a simple production job.
• Describe the use of external programming languages with IBM SPSS Statistics.