SPSS_Advanced.pdf - SPSS Data Manipulation and Advanced...

This preview shows page 1 - 5 out of 26 pages.

SPSS: Data Manipulation and Advanced Topics For Windows Updated: August 2012
Image of page 1

Subscribe to view the full document.

SPSS: Data Manipulations and Advanced Topics 2 The Department of Statistics and Data Sciences, The University of Texas at Austin Table of Contents Section 1: Introduction .................................................................................................................... 3 Section 2: Data Manipulation ......................................................................................................... 4 2.1 Splitting Files ........................................................................................................................ 4 2.2 Merging Files ........................................................................................................................ 5 2.3 Aggregating Files .................................................................................................................. 9 2.4 Database Capture ................................................................................................................. 13 Section 3: Advanced Topics ......................................................................................................... 19 3.1 Syntax .................................................................................................................................. 19 3.2 The Production Facility ....................................................................................................... 20 3.3 Scripts using Visual Basic ................................................................................................... 21 3.4 Macros ................................................................................................................................. 24
Image of page 2
SPSS: Data Manipulations and Advanced Topics 3 The Department of Statistics and Data Sciences, The University of Texas at Austin Section 1: Introduction This document is the fourth module of a four module tutorial series. This module describes the use of SPSS to do advanced data manipulation such as splitting files for analyses, merging two files, aggregating datasets, and combining multiple tables in a database into an SPSS dataset in the first section. Several advanced topics are included in the second section, including the use of SPSS syntax, the SPSS Visual Basic editor, and SPSS Macros. If you are not familiar with SPSS or need more information about how to get SPSS to read your data, consult the first module, SPSS for Windows: Getting Started , of this four part tutorial. This set of documents uses a sample dataset, Employee data.sav , that SPSS provides. It can be found in the root SPSS directory. If you installed SPSS in the default location, then this file will be located in the following location: C:\Program Files\SPSS\Employee Data.sav.
Image of page 3

Subscribe to view the full document.

SPSS: Data Manipulations and Advanced Topics 4 The Department of Statistics and Data Sciences, The University of Texas at Austin Section 2: Data Manipulation 2.1 Splitting Files In some situations, you may want to perform the same analysis on different groups within the same dataset. For example, if you are comparing gender differences in salaries for men and women, you may want to first obtain separate sets of descriptive statistics such as the mean, standard deviation, etc. for men and women. Analyses such as these can be conducted by first selecting the Split File function from the Data menu in the Data Editor: Data Split File... This will produce the following dialog box: You have three possible choices for the organization of your analyses. The default choice is the Analyze all cases, do not create separate groups . With this option, all analyses are conducted on the entire dataset. Because the split file command remains in effect indefinitely, you should reset this option when you no longer want a split file analysis. The next two choices, Compare groups and Organize output by groups result in the same values in the output, regardless of the analysis being performed, but they differ in the way in which the output is presented. These two options require you to select one or more variables from the variable list on the left side of the dialog box by first clicking on variables by which the file is to be split, then clicking on the arrow to the right of the variable list. This will display the variables
Image of page 4
Image of page 5

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern