Restructuring Data in IBM SPSS Statistics.pptx

Version 1 Tech Tip

1. Version 1 SPSS Team Tech Tips - Restructuring Data in IBM SPSS Statistics

2. Tech Tips - Restructuring Data We want to merge these two files together Restructure data One row for each individual Each score becomes a new variable Merge with second file

3. Restructure Data Wizard: Makes it easy to restructure your data. Go to Data menu and select Restructure . Note that wizard replaces the current data set with the restructured data. Tech Tips - Restructuring Data

4. Restructure selected variables into cases Restructure selected cases into variables Transpose all data Tech Tips - Restructuring Data

5. We have a dataset where we have multiple records in rows. For the individual with id number 1 there are 5 records. We can see the 5 records for number 2. We want to restructure the data so that each id has one row with the scores. We want to create a variable with the max score. We want to obtain an average score. Need to merge new restructured data with attitudinal data Tech Tips - Restructuring Data

6. For more information please visit spssanalyticspartner.com Thank You