Date: Thu, 22 Feb 2001 13:41:28 -0500
Reply-To: "Cohen,Diane" <dc42@EXCHANGE1.DREXEL.EDU>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: "Cohen,Diane" <dc42@EXCHANGE1.DREXEL.EDU>
Subject: Re: Reading Data Problem
Content-Type: text/plain; charset="iso-8859-1"
Yes, give yourself a gold star for a valiant effort!!!! Diane
-----Original Message-----
From: Flechet, Jef [mailto:Jef.Flechet@BASES.COM]
Sent: Thursday, February 22, 2001 1:36 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
I tried all of your suggestions, about indenting the data and so on. I
deleted the "fixed" term in the syntax, ,... It still does not work!! There
seem to be something strange going on with the Include statement. I tried to
delete the execute statement in the data list file, still does not work.
I tried indenting everything by one space in the data list file, does not
work. The I tried indenting everything but the first line, then everything
but the execute, everything but the first and last line. I tried a lot of
different ways but it still does not work!! SPSS does not read in the
data!!!
Any other ideas????
Jef.
-----Original Message-----
From: Savoie, Anthony - RIUSA [mailto:A.Savoie@RESEARCH-INT.COM]
Sent: Thursday, February 22, 2001 1:19 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
I just noticed that "data list" statement may not be in column 1 since it
looks like the "execute" command begins 1 column before "data list". Is
this the problem? SPSS skips over the data list staement since it isn't in
the first column and goes right to the execute command?
Tony
-----Original Message-----
From: Goodwin, Jay [ mailto:JGoodwin@AIR.ORG <mailto:JGoodwin@AIR.ORG> ]
Sent: Thursday, February 22, 2001 1:07 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
Following up to Tony:
I forced an error if the execute command isn't in the first column with the
include that it wouldn't cause by running directly from syntax. The error
that I got resembles the error that Jef reported earlier.
Jef: Is the syntax file being generated by another program/script (e.g., a
macro or script creates it on the fly) or are you coding it by hand? If so,
you might check the macro/script syntax as a root of the error.
More generally speaking, I haven't ever encountered this type of error
unless I miscoded a data list statement (which can be quite easy to do).
Jay
-----Original Message-----
From: Savoie, Anthony - RIUSA
To: SPSSX-L@LISTSERV.UGA.EDU
Sent: 02/22/2001 12:56 PM
Subject: Re: Reading Data Problem
Jef,
In your email with the syntax it looks like all of your command lines
start at column 1.
If I run your syntax directly from a syntax window (on some dummy data I
have) it works.
(I am using SPSS 9.0 on a Windows 95 machine).
BUT, if I use an include statement I get this:
include 'C:\11646\diagcon\test1.sps'.
640 data list file='C:\11646\diagcon\a11646.txt' fixed RECORDS=1
Data List will read 1 records from C:\11646\diagcon\a11646.txt
Variable Rec Start End Format
641 /1
>Error # 1 on line 641. Command name: /1
>The first word in the line is not recognized as a SPSS command.
>This command not executed.
>Note # 214 on line 641. Command name: /1
>Due to an error, INCLUDE file processing has been terminated and the
>working file has been lost. You may either redefine your data or leave
>SPSS.
It's not the same message you get but is there a clue here? Maybe
making sure your only your first line starts at column 1?
Tony
-----Original Message-----
From: Flechet, Jef [ mailto:Jef.Flechet@BASES.COM
<mailto:Jef.Flechet@BASES.COM>
< mailto:Jef.Flechet@BASES.COM <mailto:Jef.Flechet@BASES.COM> > ]
Sent: Thursday, February 22, 2001 12:45 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
Jay,
After the include statement, I have a select if, then I am calling a
MATRIX
procedure to do a whole bunch of computations but the problem does not
come
from there. If I only select the include statement and run the syntax on
the
selection SPSS does not read the data, so the problem is independent on
what
is coming after the include statement! It's pretty weird!
Jef.
-----Original Message-----
From: Goodwin, Jay [ mailto:JGoodwin@AIR.ORG
<mailto:JGoodwin@AIR.ORG>
< mailto:JGoodwin@AIR.ORG <mailto:JGoodwin@AIR.ORG> > ]
Sent: Thursday, February 22, 2001 12:39 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
Jef,
What else is the file after the include? I have just
put a
correlation
statement in after it in my tests, but it may be the
interaction of the
other syntax may be causing the problems.
Jay
-----Original Message-----
From: Flechet, Jef
To: SPSSX-L@LISTSERV.UGA.EDU
Sent: 02/22/2001 12:21 PM
Subject: Re: Reading Data Problem
George,
The problem is that SPSS does NOT read the data!! So of
course, EXECUTE
causes a syntax error. However, if I start my SPSS
session
with the
included
file alone (which contains the execute statement), I do
not
have any
error
message!! So I guess that the syntax is correct. That's
why
I am
wondering
if there is any known bugs with the include statement.
Carol suggested that this might be an indentation
problem
but I don't
think
there is such a thing in the include statement (vs.
production
facility).
I have no idea of where the problem comes from
Thanks for all your suggestions.
JF
-----Original Message-----
From: Evonich, George
[ mailto:evonich@EXCHANGE.CIS.PITT.EDU
<mailto:evonich@EXCHANGE.CIS.PITT.EDU>
< mailto:evonich@EXCHANGE.CIS.PITT.EDU
<mailto:evonich@EXCHANGE.CIS.PITT.EDU> > ]
Sent: Thursday, February 22, 2001
12:21 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
Perhaps I'm beating a dead horse, and if
I
am please
accept
my apologies,
but I'm kind of inclined to think there
is a
syntax
error.
The message
about" >Error # 105 on line 42.
Command
name: EXECUTE
This command is not valid before a
working
file has been
defined" kind of
looks like a problem with syntax. I
usually
get it when
I
screw up a file
handle or data list, but if all of those
are
fine then
I'm
out of guesses...
Thanks,
George
-----Original Message-----
From: Flechet, Jef
[ mailto:Jef.Flechet@BASES.COM <mailto:Jef.Flechet@BASES.COM> <
mailto:Jef.Flechet@BASES.COM <mailto:Jef.Flechet@BASES.COM> > ]
Sent: Thursday, February 22, 2001 11:42
AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading Data Problem
George,
The file = is optional in the include
statement. I tried
to
run it with the
file= to make sure but I encounter the
same
problem. It
works fine if I
first run the file that I want to
include,
then run that
program because the
data file is already in memory! I am
developing program
for
other users and
I need to automate the procedure so
that's
really
annoying.
Sharon mentioned that the transformation
might be
pending
but that's not the
case, the SPSS processor is Ready!!
Still
there is no
data
in there. There
does not seem to be any syntax error! Is
that a bug?
Thanks for your replies,
JF
-----Original
Message-----
From: Evonich, George
[ mailto:evonich@EXCHANGE.CIS.PITT.EDU
<mailto:evonich@EXCHANGE.CIS.PITT.EDU>
< mailto:evonich@EXCHANGE.CIS.PITT.EDU
<mailto:evonich@EXCHANGE.CIS.PITT.EDU> > ]
Sent: Thursday,
February
22, 2001
11:26 AM
To:
SPSSX-L@LISTSERV.UGA.EDU
Subject: Re:
Reading
Data Problem
I thought you might need
the
include to
have
a '=',
something like INCLUDE
FILE=
-----Original
Message-----
From: Flechet, Jef
[ mailto:Jef.Flechet@BASES.COM
<mailto:Jef.Flechet@BASES.COM>
< mailto:Jef.Flechet@BASES.COM <mailto:Jef.Flechet@BASES.COM> > ]
Sent: Thursday, February
22,
2001 11:12
AM
To:
SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Reading
Data
Problem
Hi Jay, Georges, and
Anthony,
Here is the syntax for
the
file I am
running. I copied it
from the output
window, like that you
can
see the type
of
error message that
I receive. The
input statement is
correctly
specified
as I
can run it on
its own without
any problem (however
after
this error I
have
to start a new
SPSS session).
As some other people
mentioned I am
aware of
the "execute
problem", and yes,
there is an execute
statement at the end
of
my data list
file command.
I did not copy the whole
output because
everything after
comes up with an
error as there is no
current
dataset.
Let me know if you need
extra
information.
include
'C:\11646\diagcon\a11646.sps'.
16 data list
file='C:\11646\diagcon\a11646.sdi' fixed
RECORDS=1
17 /1
18 resp
1 -
5
19 alkhd1
to
alkhd6
6 -
11
20 api
12
21 aq10_1
to aq10_6
13 -
18
22 aq13_1
to aq13_6
19 -
24
23 aq14_1
to aq14_6
25 -
30
24 aq15a1
to
aq15a6
31 -
36
25 aq15b1
to
aq15b6
37 -
42
26 aq15c1
to
aq15c6
43 -
48
27 aq16a1
to
aq16a6
49 -
54
28 aq16b1
to
aq16b6
55 -
60
29 atry1
to
atry6
61 -
66
30 aatt1
to
aatt23
67 -
89
31 cicell
90
32 cpi
91
33 catt1
to
catt23
92 -
114
34 cwt1
115 -
120
35 cwt2
121 -
126
36 cwt3
127 -
132
37 cwt4
133 -
138
38 cwt5
139 -
144
39 cwt6
145 -
150
40 cwt7
151 -
156
41 .
42 execute.
>Error # 105 on line 42.
Command name:
EXECUTE
>This command is not
valid
before a
working
file has been
defined.
>This command not
executed.
43
44 * End of INCLUDE
nesting level 01.
select if cicell=1.
>Error # 105. Command
name:
SELECT IF
>This command is not
valid
before a
working
file has been
defined.
>This command not
executed.
/* WEIGHT cwt1. */
/* Top-Box or Top 2 Box
Selection */
/* crec: concept
recode*/
/* arec: afu recode*/
recode catt1 to catt23
(1=1)
(2=1)
(else=0)
into crec1 to
crec23.
-----Original
Message-----
From:
Goodwin, Jay
[ mailto:JGoodwin@AIR.ORG
<mailto:JGoodwin@AIR.ORG>
< mailto:JGoodwin@AIR.ORG <mailto:JGoodwin@AIR.ORG> > ]
Sent:
Thursday,
February
22, 2001 10:47 AM
To:
SPSSX-L@LISTSERV.UGA.EDU
Subject:
Re:
Reading
Data Problem
Hi Jef,
I have
tried
to
reproduce
your problem in
several different
ways, but been
unable
to do
so. Every
time, SPSS has read
in the data file
just fine and
execute
other analyses.
Can
you provide
more specific
information on ...
1. The
data
list
statement
syntax
2.
Other
analyses in
the
syntax file you
are executing
3.
Other
included files
in
your syntax
4.
basic
information on
your data files
(this may help in
terms of
reconstructing a data
set
that is
comparable)
Jay
Goodwin
jgoodwin@air.org
-----Original
Message-----
From:
Flechet, Jef
To:
SPSSX-L@LISTSERV.UGA.EDU
Sent:
02/22/2001 9:50 AM
Subject:
Reading Data
Problem
Hello
Everybody,
I have
encountered the
same
type of problems
many times with
SPSS and I
was
wondering if
anybody
might
know the cause of
the problem.
I am
reading
a data set
(TXT
file) using the
data list
command. This is
saved in
a
separate sps
file. I call that
file using the
INCLUDE
statement:
include
'C:\11646\diagcon\a11646.sps'.
The
problem
is that SPSS
sometimes reads the
data in and
sometimes just
displays
the
variable
name
but no data at
all!!!
When the
problem occurs,
any
other data list
file that I try
to run will
cause
the
same problem.
SPSS
does NOT even
report any type
of error but
the
data are
not
in!! So of
course when later on
I try to
perform some
operation
on the
data,
SPSS
crashes.
The only
thing I can do
is
to quit SPSS and
start a new
session. SPSS
seems
to be
really
unstable. I
have the same
problem with SPSS
10.0.5 (on NT
station)
and
10.1. (on
Win2K).
Does
anybody
know how to
correct the
problem?? Is there
anyway that SPSS
technical
service could
have
a look at this
to make SPSS a
more stable
working
environment?
Thanks.
Jean-Francois
