Reading BIGSTEPS Output into SPSS

**************************************************************************
This is for person output file; item output file info below.

***
* Part One: Read in a BIGSTEPS person output file. Part One may be the only part of this
* SPSS syntax that some users may be interested in. All of the variables entered after
* PTBISER are optional indicators that users can place within the person ID field to
* facilitate group comparisons. The remainder of the code 1) reads in
* another, similar, BIGSTEPS file, one that has measures on the same persons made with a
* different instrument; 2) merges the first and second files on the basis of a common
* record number for each case; and 3) selects cases for study based on BIGSTEPS' estimate
* status indicator.

DATA LIST FILE 'person.out' FIXED
 / RECNO 2-6 MEASURE 7-14 (1) MEASSTAT 15-17
   TEST 18-23 SCORE 24-30
   ERROR 31-37 (1) MSINF 38-44 (2) STDINF 45-51 (2)
   MSOUT 52-58 (2) STDOUT 59-65 (2) DISPLAC 66-72 (2)
   PTBISER 73-79 (2) SEX 85 (A) AGE 86 (A)
   EDLEVEL 87 (A) ETHGRP 88 (A) INCOME 89 (A) ALCOHAB 90 (A)
   ARTHRIT 91 (A) ASTHMA 92 (A) CANCER 93 (A) COLITIS 94 (A)
   DIABETES 95 (A) DRUGAB 96 (A) EPILEPSY 97 (A) HEARTDIS 98 (A)
   HYPERTEN 99 (A) LUNGDIS 100 (A) STDS 101 (A) STOMULCR 102 (A)
   STROKE 103 (A) THYROID 104 (A).

EXECUTE.

*Add labels.
VARIABLE LABELS RECNO 'RECORD NUMBER'
                MEASSTAT 'MEASURE TYPE'
                TEST '# ITEMS MEASURING'
                SCORE 'RAW RATINGS SUM'
                MEASURE 'KIND OF MEASURES'
                ERROR 'ERROR (RANGE OF MEASURE)'
                MSINF 'MNSQ INFIT'
                STDINF 'STNDRDZD INFIT'
                MSOUT 'MNSQ OUTFIT'
                STDOUT 'STNDRDZD OUTFIT'.

VALUE LABELS MEASSTAT 1 'Estimated value' 2 'Anchored value'
                      0 'Extreme minimum'
                      -1 'Extreme maximum' -2 'No available responses'
                      -3 'Deleted by user' -4 'Combined w/ another item'.

MISSING VALUES MEASURE ERROR STDINF STDOUT SCORE TEST (0).
SET BLANKS=SYSMIS BLANKS=SYSMIS UNDEFINED=WARN.
SAVE OUTFILE='persout.sav'
   /COMPRESSED.

***
* Part Two: Read in another BIGSTEPS person output file.
DATA LIST FILE 'person2.out' FIXED
                        / RECNO 2-6 MEASURE 7-14 (1) MEASSTAT 15-17
                          TEST 18-23 SCORE 24-30
                          ERROR 31-37 (1) MSINF 38-44 (2) STDINF 45-51 (2)
                          MSOUT 52-58 (2) STDOUT 59-65 (2) DISPLAC 66-72 (2)
                          PTBISER 73-79 (2) SEX 85 (A) AGE 86 (A)
                          EDLEVEL 87 (A) ETHGRP 88 (A) INCOME 89 (A) ALCOHAB 90 (A)
                          ARTHRIT 91 (A) ASTHMA 92 (A) CANCER 93 (A) COLITIS 94 (A)
                          DIABETES 95 (A) DRUGAB 96 (A) EPILEPSY 97 (A) HEARTDIS 98 (A)
                          HYPERTEN 99 (A) LUNGDIS 100 (A) STDS 101 (A) STOMULCR 102 (A)
                          STROKE 103 (A) THYROID 104 (A).
EXECUTE.

*Add labels.
VARIABLE LABELS RECNO 'RECORD NUMBER'
                MEASSTAT 'MEASURE TYPE'
                TEST '# ITEMS MEASURING' SCORE 'RAW RATINGS SUM'
                MEASURE 'KIND OF MEASURES'
                ERROR 'ERROR (RANGE OF MEASURE)'
                MSINF 'MNSQ INFIT'
                STDINF 'STNDRDZD INFIT'
                MSOUT 'MNSQ OUTFIT'
                STDOUT 'STNDRDZD OUTFIT'.
VALUE LABELS MEASSTAT 1 'Estimated value' 2 'Anchored value' 0 'Extreme minimum'
                      -1 'Extreme maximum' -2 'No available responses'
                      -3 'Deleted by user' -4 'Combined w/ another item'.
MISSING VALUES MEASURE ERROR STDINF STDOUT SCORE TEST (0).
SET BLANKS=SYSMIS BLANKS=SYSMIS UNDEFINED=WARN.
SAVE OUTFILE='pers2out.sav'
   /COMPRESSED.

***
* Part Three: Merge the saved BIGSTEPS person output files into a single file.
GET
  FILE='person.sav'.
EXECUTE.

MATCH FILES /TABLE=*
 /RENAME  measure=1meas measstat=1msta test=1test score=1scor
  error=1erro msinf=1msin stdinf=1stin msout=1mout
  stdout=1sout displac=1disp ptbiser=1ptbi
 /FILE='pers2out.sav'
 /RENAME (age alcohab arthrit asthma cancer colitis diabetes drugab edlevel
  epilepsy ethgrp heartdis hyperten income lungdis sex stds stomulcr stroke
  thyroid = d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 d10 d11 d12 d13 d14 d15 d16 d17 d18
  d19) measure=2meas measstat=2msta test=2test error=2erro
  msinf=2msin stdinf=2stin msout=2mout stdout=2sout
  displac=2disp ptbiser=2ptbi score=2scor
 /BY recno
 /DROP= d0 d1 d2 d3 d4 d5 d6 d7 d8 d9 d10 d11 d12 d13 d14 d15 d16 d17 d18
  d19.
EXECUTE.

SAVE OUTFILE='pers1_2.sav'
   /COMPRESSED.

***
* Part Four: Select cases for use based on the quality of the measurement estimate.
USE ALL.
COMPUTE filter_$=(2msta = 1 & 1msta = 1).
VARIABLE LABEL filter_$ '2msta = 1 & 1msta = 1 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

***************************************************************************

Here is the SPSS code for reading in BIGSTEPS item output files.

DATA LIST FILE 'item1.out' FIXED
                        / RECNO 2-6 CALIBRTN 7-14 (1) CALISTAT 15-17
                          COUNT 18-23 SCORE 24-30
                          ERROR 31-37 (1) MSINF 38-44 (2) STDINF 45-51 (2)
                          MSOUT 52-58 (2) STDOUT 59-65 (2) DISPLAC 66-72 (2)
                          PTBISER 73-79 (2) ITEMNAME 85-114 (A).
EXECUTE.

*Add labels.
VARIABLE LABELS RECNO 'RECORD NUMBER'
                CALISTAT 'CALIBRTN TYPE'
                COUNT '# PERSONS MEASURED' SCORE 'RAW RATINGS SUM'
                CALIBRTN 'KIND OF CALIBRTN'
                ERROR 'ERROR (RANGE OF CALIBRTN)'
                MSINF 'MNSQ INFIT'
                STDINF 'STNDRDZD INFIT'
                MSOUT 'MNSQ OUTFIT'
                STDOUT 'STNDRDZD OUTFIT'.
VALUE LABELS CALISTAT 1 'Estimated value' 2 'Anchored value' 0 'Extreme minimum'
                      -1 'Extreme maximum' -2 'No available responses'
                      -3 'Deleted by user' -4 'Combined w/ another item'.
MISSING VALUES CALIBRTN ERROR STDINF STDOUT SCORE COUNT (0).
SET BLANKS=SYSMIS BLANKS=SYSMIS UNDEFINED=WARN.
SORT CASES BY
  itemname (A) .
SAVE OUTFILE='item1.sav'
   /COMPRESSED.
DATA LIST FILE 'item2.out' FIXED
                        / RECNO 2-6 CALIBRTN 7-14 (1) CALISTAT 15-17
                          COUNT 18-23 SCORE 24-30
                          ERROR 31-37 (1) MSINF 38-44 (2) STDINF 45-51 (2)
                          MSOUT 52-58 (2) STDOUT 59-65 (2) DISPLAC 66-72 (2)
                          PTBISER 73-79 (2) ITEMNAME 85-114 (A).
EXECUTE.

*Add labels.
VARIABLE LABELS RECNO 'RECORD NUMBER'
                CALISTAT 'CALIBRTN TYPE'
                COUNT '# PERSONS MEASURED' SCORE 'RAW RATINGS SUM'
                CALIBRTN 'KIND OF CALIBRTN'
                ERROR 'ERROR (RANGE OF CALIBRTN)'
                MSINF 'MNSQ INFIT'
                STDINF 'STNDRDZD INFIT'
                MSOUT 'MNSQ OUTFIT'
                STDOUT 'STNDRDZD OUTFIT'.
VALUE LABELS CALISTAT 1 'Estimated value' 2 'Anchored value' 0 'Extreme minimum'
                      -1 'Extreme maximum' -2 'No available responses'
                      -3 'Deleted by user' -4 'Combined w/ another item'.
MISSING VALUES CALIBRTN ERROR STDINF STDOUT SCORE COUNT (0).
SET BLANKS=SYSMIS BLANKS=SYSMIS UNDEFINED=WARN.
SORT CASES BY
  itemname (A) .
SAVE OUTFILE='item2.sav'
   /COMPRESSED.
GET
  FILE='item1.sav'.
EXECUTE.

MATCH FILES /TABLE=*
 /RENAME  calibrtn=1cali CALISTAT=1msta COUNT=1COUNT score=1scor
  error=1erro msinf=1msin stdinf=1stin msout=1mout
  stdout=1sout displac=1disp ptbiser=1ptbi
 /FILE='item2.sav'
 /RENAME calibrtn=2cali CALISTAT=2msta COUNT=2COUNT error=2erro
  msinf=2msin stdinf=2stin msout=2mout stdout=2sout
  displac=2disp ptbiser=2ptbi score=2scor
 /BY itemname.
EXECUTE.

SAVE OUTFILE='item1_2.sav'
/COMPRESSED.
USE ALL.
COMPUTE filter_$=(2msta = 1 & 1msta = 1).
VARIABLE LABEL filter_$ '2msta = 1 & 1msta = 1 (FILTER)'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.