Date:         Mon, 28 Jun 2004 17:22:01 -0500
Reply-To:     "Hall, Richard H." <rhall@umr.edu>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Hall, Richard H." <rhall@umr.edu>
Subject:      basic data definition with excel files and multiple lines
Content-Type: text/plain; charset="us-ascii"

I have an excel spread sheet where each case has multiple rows. Also
most variables are of the sort a1 TO a10 ...

I was hoping I could treat this as a fixed format file and specify each
column in excel as a single column (even though the data in the cell may
be several numbers).

I have tried doing with arrangement = fixed, but I keep getting the
error that arrangement is unexpected syntax.

I tried something like ...

GET DATA /TYPE=TXT
   /FILE='C:\test_data.xls'
        /SHEET=name 'pilot_data'
        /CELLRANGE=full
        /READNAMES=off
        /ARRANGEMENT=fixed
        /FIXCASE = 2
        /VARIABLES=
                /1 V1.1 TO V1.10 0-9
                /2 N1.1 TO N1.10 0.9.

... any help would be much appreciated ... Richard


**************************************
Richard H. Hall, rhall@umr.edu
http://www.umr.edu/~rhall
**************************************