Nested, delimited file syntax

[Ben Hansen-2]

I'm attempting to import a nested, delimited file. I borrowed the
sample from the documentation and converted it to comma-dellimited.
Can someone point out what I need to do?
Thanks in advance.

FILE TYPE NESTED RECORD=2 CASE=1 .
RECORD TYPE 1.

DATA LIST FREE (",") /REC_ID (A) ACCID (A) ACC_ID (A) WEATHER (A)
STATE (A) DATE (EDATE).

RECORD TYPE 2.

DATA LIST FREE (",") /REC_ID (A) ACCID (A) STYLE (A) MAKE (A)OLD (A)
LICENCE (A) INSURNCE (A).

RECORD TYPE 3.

DATA LIST FREE (",") /REC_ID (A) ACCID (A) PSNGR_NO (A) AGE (A) SEX
(A) INJURY (A) SEAT (A) COST (A).

END FILE TYPE.

BEGIN DATA.

0001,1,322,1,IL,13/03/88

0001,2,1,44,MI,13,4M

0001,3,1,34,M,1,FR,3

0001,2,1,16,IL,32,2,F

0001,3,1,22,F,1,FR,11

0001,3,2,35,M,1,FR,5

0001,3,3,59,M,1,BK,7

0001,2,3,21,IN,14,6,M

0001,3,1,46,M,0,FR,0

0002,1,322,1,IL,13/03/88

0002,2,1,44,MI,13,4M

0002,3,1,34,M,1,FR,3

0002,2,1,16,IL,32,2,F

0002,3,1,22,F,1,FR,11

0002,3,2,35,M,1,FR,5

0002,3,3,59,M,1,BK,7

0002,2,3,21,IN,14,6,M

0002,3,1,46,M,0,FR,0

END DATA.

[Richard Ristow]

At 05:07 PM 9/18/2007, Ben Hansen wrote:

>I'm attempting to import a nested, delimited file. Can someone point
>out what I need to do?

1.) The RECORD and CASE variables must be in fixed columns.
Fortunately, yours are.  Instead of

FILE TYPE NESTED RECORD=2 CASE=1 .

use

FILE TYPE NESTED
      RECORD=06-06
      CASE  =01-04 .


2.) Declaring a variable with '(A)' format in a FREE data list defaults
it to length 1. Chance '(A)' to '(A4)' throughout. (By the way, a lot
of your variables look like they could be numeric. If they can be, they
probably should be.)


3.) For reasons I don't completely understand (and haven't
investigated), if you read with the FREE keyword, there are many
warning messages that seem to indicate the last element on each record
was much too long. (Despite this, the data appears to be read as
desired.) Replacing 'FREE' by 'LIST' on the DATA LIST commands seems to
fix this.

SPSS 15 draft output (WRR:not saved separately):

FILE TYPE NESTED
      RECORD=06-06
      CASE  =01-04 .

RECORD TYPE 1.
DATA LIST LIST (",")
    /REC_ID   (A4) ACCID     (A4)
     ACC_ID   (A4) WEATHER   (A4)  STATE    (A4)
     DATE     (EDATE).

RECORD TYPE 2.
DATA LIST LIST (",")
   /REC_ID    (A4)  ACCID    (A4)
    STYLE     (A4)  MAKE     (A4)  OLD      (A4)
    LICENCE   (A4)  INSURNCE (A4).

RECORD TYPE 3.
DATA LIST LIST (",")
   /REC_ID    (A4)  ACCID    (A4)
    PSNGR_NO  (A4)  AGE      (A4)  SEX      (A4)  INJURY   (A4)
    SEAT      (A4)  COST     (A4).

END FILE TYPE.

BEGIN DATA.
0001,1,322,1,IL,13/03/88
0001,2,1,44,MI,13,4M
0001,3,1,34,M,1,FR,3
0001,2,1,16,IL,32,2,F
0001,3,1,22,F,1,FR,11
0001,3,2,35,M,1,FR,5
0001,3,3,59,M,1,BK,7
0001,2,3,21,IN,14,6,M
0001,3,1,46,M,0,FR,0
0002,1,322,1,IL,13/03/88
0002,2,1,44,MI,13,4M
0002,3,1,34,M,1,FR,3
0002,2,1,16,IL,32,2,F
0002,3,1,22,F,1,FR,11
0002,3,2,35,M,1,FR,5
0002,3,3,59,M,1,BK,7
0002,2,3,21,IN,14,6,M
0002,3,1,46,M,0,FR,0
END DATA.

LIST.

List
|-----------------------------|---------------------------|
|Output Created               |18-SEP-2007 18:47:19       |
|-----------------------------|---------------------------|
The variables are listed in the following order:

LINE   1: REC_ID ACCID ACC_ID WEATHER STATE DATE STYLE MAKE OLD LICENCE
INSURNCE
           PSNGR_NO
LINE   2: AGE SEX INJURY SEAT COST

       REC_ID: 0001 3    322  1    IL   13.03.1988
1    44   MI   13   4M   1
          AGE: 34   M    1    FR   3

       REC_ID: 0001 3    322  1    IL   13.03.1988
1    16   IL   32   2    1
          AGE: 22   F    1    FR   11

       REC_ID: 0001 3    322  1    IL   13.03.1988
1    16   IL   32   2    2
          AGE: 35   M    1    FR   5

       REC_ID: 0001 3    322  1    IL   13.03.1988
1    16   IL   32   2    3
          AGE: 59   M    1    BK   7

       REC_ID: 0001 3    322  1    IL   13.03.1988
3    21   IN   14   6    1
          AGE: 46   M    0    FR   0

       REC_ID: 0002 3    322  1    IL   13.03.1988
1    44   MI   13   4M   1
          AGE: 34   M    1    FR   3

       REC_ID: 0002 3    322  1    IL   13.03.1988
1    16   IL   32   2    1
          AGE: 22   F    1    FR   11

       REC_ID: 0002 3    322  1    IL   13.03.1988
1    16   IL   32   2    2
          AGE: 35   M    1    FR   5

       REC_ID: 0002 3    322  1    IL   13.03.1988
1    16   IL   32   2    3
          AGE: 59   M    1    BK   7

       REC_ID: 0002 3    322  1    IL   13.03.1988
3    21   IN   14   6    1
          AGE: 46   M    0    FR   0

Number of cases read:  10    Number of cases listed:  10

>Thanks in advance.
>
>FILE TYPE NESTED RECORD=2 CASE=1 .
>RECORD TYPE 1.
>
>DATA LIST FREE (",") /REC_ID (A) ACCID (A) ACC_ID (A) WEATHER (A)
>STATE (A) DATE (EDATE).
>
>RECORD TYPE 2.
>
>DATA LIST FREE (",") /REC_ID (A) ACCID (A) STYLE (A) MAKE (A)OLD (A)
>LICENCE (A) INSURNCE (A).
>
>RECORD TYPE 3.
>
>DATA LIST FREE (",") /REC_ID (A) ACCID (A) PSNGR_NO (A) AGE (A) SEX
>(A) INJURY (A) SEAT (A) COST (A).
>
>END FILE TYPE.
>
>BEGIN DATA.
>
>0001,1,322,1,IL,13/03/88
>
>0001,2,1,44,MI,13,4M
>
>0001,3,1,34,M,1,FR,3
>
>0001,2,1,16,IL,32,2,F
>
>0001,3,1,22,F,1,FR,11
>
>0001,3,2,35,M,1,FR,5
>
>0001,3,3,59,M,1,BK,7
>
>0001,2,3,21,IN,14,6,M
>
>0001,3,1,46,M,0,FR,0
>
>0002,1,322,1,IL,13/03/88
>
>0002,2,1,44,MI,13,4M
>
>0002,3,1,34,M,1,FR,3
>
>0002,2,1,16,IL,32,2,F
>
>0002,3,1,22,F,1,FR,11
>
>0002,3,2,35,M,1,FR,5
>
>0002,3,3,59,M,1,BK,7
>
>0002,2,3,21,IN,14,6,M
>
>0002,3,1,46,M,0,FR,0
>
>END DATA.
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date:
>9/18/2007 11:53 AM