Date:         Fri, 6 Sep 2002 16:28:19 -0400
Reply-To:     Art@DrKendall.org
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "Arthur J. Kendall" <Arthur.Kendall@VERIZON.NET>
Subject:      Re: Cases Not Importing
Comments: To: Wynde.Jones/Executive_Directors_Office/TDCJ@tdcj.state.tx.us
Content-Type: text/plain; charset=us-ascii

How many characters are there in each line?
If the ascii records are very wide you may need FILE HANDLE with LRECL specified.

Art
Wynde Jones wrote:

> Steven,
> Thanks for the reply.  My text file is 2 lines per case.  Is the syntax
> below what you mean when you say "add a second line /2 and definition of
> variables to indicate tow records of data"?  If yes, it didn't work for me.
> I still get only 275 out of 500 cases AND now I have missing data for
> variables 450 and 451.  Any ideas on what I am doing wrong?
>
> GET DATA  /TYPE = TXT
>  /FILE = 'C:\filename.txt'
>  /FIXCASE = 2
>  /ARRANGEMENT = FIXED
>  /FIRSTCASE = 1
>  /IMPORTCASE = ALL
>  /VARIABLES =
>  /1  var1 0-7 A8  var2 8-37 A30
>  /2  var450 3067-3068 A2  var451 3069-3078 A10
>  .
> CACHE.
> EXECUTE.
>
> Wynde L. Jones
> Research, Evaluation & Development Group
> Texas Department of Criminal Justice
>
>                     "Fink, Steven"
>                     <sfink@spss.co       To:
>                     m>                    Wynde.Jones/Executive_Directors_Office/TDCJ<Wynde.Jones/Executive_Directors_Office/TDCJ@tdcj.state
>                                           .tx.us>
>                     09/06/02 07:58       cc:
>                     AM                   Subject:     RE:      Cases Not Importing
>
>                     ID Number:
>
> Wynde,
>
> I think the reason you have half the number of cases is because you
> declared two records (or lines of data) per person. If you have two lines
> of data, you also need to add a second line /2 and definition of variables
> to indicate two records of data.
>
> If you have one record per case change the /FIXCASE = 2 to /FIXCASE = 1.
>
> Steven Fink
> Trainer, SPSS, Inc.
> SPSS Federal Systems
> 2000 North 14th Street
> Suite 320
> Arlington VA 22201
> Phone: 703.740.2427
> e-mail: Sfink@spss.com
>
> For course descriptions and schedules: www.spss.com/training
>
> SPSS Business Intelligence division helps people solve business problems
> using statisics and data mining.
>
> -----Original Message-----
> From: Wynde Jones
> [mailto:Wynde.Jones/Executive_Directors_Office/TDCJ@tdcj.state.tx.us]
> Sent: Thursday, September 05, 2002 4:52 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: Cases Not Importing
>
> I have a fixed width, text file of 500 cases.  Each case takes up two
> lines.  After running the syntax (below), I only end up with 275 cases.   I
> know that this is very little information, but does anybody have any
> suspicions as to what my problem(s) could be?
>
> GET DATA  /TYPE = TXT
>  /FILE = 'C:\filename.txt'
>  /FIXCASE = 2
>  /ARRANGEMENT = FIXED
>  /FIRSTCASE = 1
>  /IMPORTCASE = ALL
>  /VARIABLES =
>  /1  variable1 0-7 A8
>  variable2 8-37 A30
>  [etc...]
> .
> CACHE.
> EXECUTE.
>
> Wynde L. Jones
> Research, Evaluation & Development Group
> Texas Department of Criminal Justice