Flat file with multiple lines per record

When there are many observations for each subject, they are often arranged in multiple lines per subject. In this case, there are 10 observations per subject. 5 on the first line, and 5 on a subsequent line.

 

This is the data file, TWODAT.txt:

 

Elizabeth  11010

    01011  AXBC

Henry      01101

    11010  DSGH  < The final letter codes are ignored for this analysis

^    ^     ^

1    6     12  Column

 

The Facform keyword file is TWOkey.txt

 

; File: TWOkey.txt

; This converts a multiple line per record file

$Input = TWODAT.txt

$Output = TWOFAC.txt

 

$Facets=2

$Flabel=1,Examinee

$Flabel=2,Item

 

$Label=1,,$S1E10 ; the examinee name

 

; Get items from the first line

Itemnum = 1

Pointer = 12

$DO=5   ; go round the 5 items on the first line

 $Label = 2,Itemnum

 $Rating = $S(Pointer)W1

 Itemnum = Itemnum + 1

 Pointer = Pointer + 1

$AGAIN

 

; Get items from the second line

$Nextline ; advance to the next line

Itemnum = 6

Pointer = 6

$DO=5   ; go round the 5 items on the second line

 $Label = 2,Itemnum

 $Rating = $S(Pointer)W1

 Itemnum = Itemnum + 1

 Pointer = Pointer + 1

$AGAIN

 

The resulting Facets file is TWOFAC.txt:

 

; FACFORM Version No. 1.20,  May 4, 1992

; Run on 05-04-1992 20:21:11

; from Keyword file: TWOkey.txt

Facets = 2

Labels =

1,Examinee

1=Elizabeth

2=Henry

*

2,Item

1=

|

10=

*

Data =

1,1-10,1,1,0,1,0,0,1,0,1,1

2,1-10,0,1,1,0,1,1,1,0,1,0