SPSS revision

Question 1

Syntax for Opening SPSS file

Answer 1

GET FILE = “/some_directory/file.spss”.
SAVE OUTFILE = “/some_directory/file.spss”.

Question 2

Opening excel datafile

Answer 2

GET DATA / type = xls / file = “/some_directory/file.xls” / SHEET = name ‘Sheet name’ / readnames = on.

Pull out a specific sheet, only if Excel has \> 1 sheet
# Get the variable names from the top row

DATASET NAME = somename.
# Give this dataset a name
DATASET ACTIVATE somename.
# Make a specific dataset the active dataset

EXECUTE.

Question 3

Wide format vs long format

Answer 3

Wide format is where all data for a participant is contained in a single row (that is a participant and each variable is a different measure), Long format is where each participant is represented multiple times on different rows (that is data for each participant is spread across multiple rows).

Question 4

Combining two datasets

Answer 4

DATASET ACTIVE some_data_set. # Assuming you have more than one data set open.
MATCH FILES / tables = *
# Add to the original data set.
/ file = <some></some>

/ by some_index.
DATASET NAME our_combined_data_set.

EXECUTE.