Data List error?
Locked
 
|
I am just not seeing this error.
My syntax program begins with a bunch of comment lines, each beginning /* This is a syntax file I've used before; the only thing I need to change, normally, is the first line of the DATA LIST statement in order to identify the new file and the correct path to it. I show only the last few comments below, then my syntax, and the first few lines of a long DATA LIST statement: /*After reading the data in, remember to save it in the path C:\Documents and S ettings\Owner\My Documents\1 BASIC VR File Folder\12 Working 08 projects\QuEx tFiles\ /*. DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My Documents\BobStuff\Dat aFile\attach\kvauhda1' /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I 45-46(A),TEL_NBR 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), The error message I get is this: > >Error # 31 in column 18. Text: C:\Documents and Settings\R. Schacht\My Do > >File not found. > >This command not executed. Why won't the SPSS processor read the whole DATA LIST statement? What is Error #31? Why column 18? Any assistance appreciated. Bob Robert M. Schacht, Ph.D. <[hidden email]> Pacific Basin Rehabilitation Research & Training Center 1268 Young Street, Suite #204 Research Center, University of Hawaii Honolulu, HI 96814 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
It's really hard to tell with all the wrapping going on here but error 31
means that it can't find the file specified on the DATA LIST command. -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob Schacht Sent: Friday, April 18, 2008 3:07 PM To: [hidden email] Subject: Data List error? I am just not seeing this error. My syntax program begins with a bunch of comment lines, each beginning /* This is a syntax file I've used before; the only thing I need to change, normally, is the first line of the DATA LIST statement in order to identify the new file and the correct path to it. I show only the last few comments below, then my syntax, and the first few lines of a long DATA LIST statement: /*After reading the data in, remember to save it in the path C:\Documents and S ettings\Owner\My Documents\1 BASIC VR File Folder\12 Working 08 projects\QuEx tFiles\ /*. DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My Documents\BobStuff\Dat aFile\attach\kvauhda1' /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I 45-46(A),TEL_NBR 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), The error message I get is this: > >Error # 31 in column 18. Text: C:\Documents and Settings\R. Schacht\My Do > >File not found. > >This command not executed. Why won't the SPSS processor read the whole DATA LIST statement? What is Error #31? Why column 18? Any assistance appreciated. Bob Robert M. Schacht, Ph.D. <[hidden email]> Pacific Basin Rehabilitation Research & Training Center 1268 Young Street, Suite #204 Research Center, University of Hawaii Honolulu, HI 96814 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
At 11:57 AM 4/18/2008, ViAnn Beadle wrote:
>It's really hard to tell with all the wrapping going on here but error 31 >means that it can't find the file specified on the DATA LIST command. Well, obviously, yes. But why can't it find it? The original file was on a CD; my first try was a datalist statement referencing the CD, and that was my first Error 31. I tried moving it to a directory on the hard drive, renaming the path, and got the same error message. Finally, I decided to send the copy on the CD to myself as an email attachment using Eudora. I carefully highlighting and copying the full path name of the file that appeared on the attachment line, and stuck that into the Data List statement, i.e., DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My Documents\BobStuff\DataFile\attach\kvauhda117.txt' and that worked. What appears in the SPSS Viewer is >DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >Documents\BobStuff\Dat > aFile\attach\kvauhda117.txt' But when I tried to cut and paste for the purpose of reporting here, what I was able to copy from the SPSS Viewer was >DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >Documents\BobStuff\Dat > aFile\attach\kvauhda1' Curiously, I could not highlight or copy the "...17.txt" that I see in the Viewer-- SPSS won't let me. I do this every 3 months, so I'd like to understand what it is about the Data List statement that is tripping me up, so I won't waste time 3 months from now, figuring it out again. Some others suggested the problem was that the .txt extension was missing. But when I tried to add (rename) it, I still got the same Error 31 message as before. So I'm still baffled at what is happening. Bob >-----Original Message----- >From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob >Schacht >Sent: Friday, April 18, 2008 3:07 PM >To: [hidden email] >Subject: Data List error? > >I am just not seeing this error. > >My syntax program begins with a bunch of comment lines, each beginning /* >This is a syntax file I've used before; the only thing I need to change, >normally, is the first line of the DATA LIST statement in order to identify >the new file and the correct path to it. I show only the last few comments >below, then my syntax, and the first few lines of a long DATA LIST >statement: > >/*After reading the data in, remember to save it in the path C:\Documents >and S > ettings\Owner\My Documents\1 BASIC VR File Folder\12 Working 08 >projects\QuEx > tFiles\ >/*. >DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >Documents\BobStuff\Dat > aFile\attach\kvauhda1' >/1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I >45-46(A),TEL_NBR > 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), > > >The error message I get is this: > > >Error # 31 in column 18. Text: C:\Documents and Settings\R. Schacht\My >Do > > >File not found. > > >This command not executed. > > >Why won't the SPSS processor read the whole DATA LIST statement? >What is Error #31? >Why column 18? > >Any assistance appreciated. > >Bob > >Robert M. Schacht, Ph.D. <[hidden email]> >Pacific Basin Rehabilitation Research & Training Center >1268 Young Street, Suite #204 >Research Center, University of Hawaii >Honolulu, HI 96814 > >===================== >To manage your subscription to SPSSX-L, send a message to >[hidden email] (not to SPSSX-L), with no body text except the >command. To leave the list, send the command >SIGNOFF SPSSX-L >For a list of commands to manage subscriptions, send the command >INFO REFCARD > >===================== >To manage your subscription to SPSSX-L, send a message to >[hidden email] (not to SPSSX-L), with no body text except the >command. To leave the list, send the command >SIGNOFF SPSSX-L >For a list of commands to manage subscriptions, send the command >INFO REFCARD ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
These should not make a difference but two things that might help.
1) start the filespec on a new line (indented a few spaces for readability. 2) since it was on a CD make sure it is not read only. Art Kendall Social Research Consultants Bob Schacht wrote: > At 11:57 AM 4/18/2008, ViAnn Beadle wrote: >> It's really hard to tell with all the wrapping going on here but >> error 31 >> means that it can't find the file specified on the DATA LIST command. > > Well, obviously, yes. But why can't it find it? The original file was > on a > CD; my first try was a datalist statement referencing the CD, and that > was > my first Error 31. I tried moving it to a directory on the hard drive, > renaming the path, and got the same error message. > > Finally, I decided to send the copy on the CD to myself as an email > attachment using Eudora. I carefully highlighting and copying the full > path > name of the file that appeared on the attachment line, and stuck that > into > the Data List statement, i.e., > DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My > Documents\BobStuff\DataFile\attach\kvauhda117.txt' > > and that worked. What appears in the SPSS Viewer is >> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >> Documents\BobStuff\Dat >> aFile\attach\kvauhda117.txt' > > But when I tried to cut and paste for the purpose of reporting here, > what I > was able to copy from the SPSS Viewer was >> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >> Documents\BobStuff\Dat >> aFile\attach\kvauhda1' > > Curiously, I could not highlight or copy the "...17.txt" that I see in > the > Viewer-- SPSS won't let me. > > I do this every 3 months, so I'd like to understand what it is about the > Data List statement that is tripping me up, so I won't waste time 3 > months > from now, figuring it out again. > > Some others suggested the problem was that the .txt extension was > missing. > But when I tried to add (rename) it, I still got the same Error 31 > message > as before. So I'm still baffled at what is happening. > > Bob > > >> -----Original Message----- >> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf >> Of Bob >> Schacht >> Sent: Friday, April 18, 2008 3:07 PM >> To: [hidden email] >> Subject: Data List error? >> >> I am just not seeing this error. >> >> My syntax program begins with a bunch of comment lines, each >> beginning /* >> This is a syntax file I've used before; the only thing I need to change, >> normally, is the first line of the DATA LIST statement in order to >> identify >> the new file and the correct path to it. I show only the last few >> comments >> below, then my syntax, and the first few lines of a long DATA LIST >> statement: >> >> /*After reading the data in, remember to save it in the path >> C:\Documents >> and S >> ettings\Owner\My Documents\1 BASIC VR File Folder\12 Working 08 >> projects\QuEx >> tFiles\ >> /*. >> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >> Documents\BobStuff\Dat >> aFile\attach\kvauhda1' >> /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I >> 45-46(A),TEL_NBR >> 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), >> >> >> The error message I get is this: >> > >Error # 31 in column 18. Text: C:\Documents and Settings\R. >> Schacht\My >> Do >> > >File not found. >> > >This command not executed. >> >> >> Why won't the SPSS processor read the whole DATA LIST statement? >> What is Error #31? >> Why column 18? >> >> Any assistance appreciated. >> >> Bob >> >> Robert M. Schacht, Ph.D. <[hidden email]> >> Pacific Basin Rehabilitation Research & Training Center >> 1268 Young Street, Suite #204 >> Research Center, University of Hawaii >> Honolulu, HI 96814 >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> [hidden email] (not to SPSSX-L), with no body text except the >> command. To leave the list, send the command >> SIGNOFF SPSSX-L >> For a list of commands to manage subscriptions, send the command >> INFO REFCARD >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> [hidden email] (not to SPSSX-L), with no body text except the >> command. To leave the list, send the command >> SIGNOFF SPSSX-L >> For a list of commands to manage subscriptions, send the command >> INFO REFCARD > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > > ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD
Art Kendall
Social Research Consultants |
|
|
Can it be that the line in your syntax file is to long? In that case
break it in two or more parts (all in their own quotes and with a trailing + at the end of the lines that are continued on the following line). In the past I encountered such problems myself. Often this helped (but alas, not always). [snip] DATA LIST FILE = 'C:\Documents and Settings\R. ' + 'Schacht\My Documents\BobStuff\DataFile\attach\kvauhda1' [snip] Hope this helps. Kind regards, Ruben Art Kendall schreef: > These should not make a difference but two things that might help. > 1) start the filespec on a new line (indented a few spaces for readability. > > 2) since it was on a CD make sure it is not read only. > > > Art Kendall > Social Research Consultants > > Bob Schacht wrote: >> At 11:57 AM 4/18/2008, ViAnn Beadle wrote: >>> It's really hard to tell with all the wrapping going on here but >>> error 31 >>> means that it can't find the file specified on the DATA LIST command. >> >> Well, obviously, yes. But why can't it find it? The original file was >> on a >> CD; my first try was a datalist statement referencing the CD, and that >> was >> my first Error 31. I tried moving it to a directory on the hard drive, >> renaming the path, and got the same error message. >> >> Finally, I decided to send the copy on the CD to myself as an email >> attachment using Eudora. I carefully highlighting and copying the full >> path >> name of the file that appeared on the attachment line, and stuck that >> into >> the Data List statement, i.e., >> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >> Documents\BobStuff\DataFile\attach\kvauhda117.txt' >> >> and that worked. What appears in the SPSS Viewer is >>> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >>> Documents\BobStuff\Dat >>> aFile\attach\kvauhda117.txt' >> >> But when I tried to cut and paste for the purpose of reporting here, >> what I >> was able to copy from the SPSS Viewer was >>> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >>> Documents\BobStuff\Dat >>> aFile\attach\kvauhda1' >> >> Curiously, I could not highlight or copy the "...17.txt" that I see in >> the >> Viewer-- SPSS won't let me. >> >> I do this every 3 months, so I'd like to understand what it is about the >> Data List statement that is tripping me up, so I won't waste time 3 >> months >> from now, figuring it out again. >> >> Some others suggested the problem was that the .txt extension was >> missing. >> But when I tried to add (rename) it, I still got the same Error 31 >> message >> as before. So I'm still baffled at what is happening. >> >> Bob >> >> >>> -----Original Message----- >>> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf >>> Of Bob >>> Schacht >>> Sent: Friday, April 18, 2008 3:07 PM >>> To: [hidden email] >>> Subject: Data List error? >>> >>> I am just not seeing this error. >>> >>> My syntax program begins with a bunch of comment lines, each >>> beginning /* >>> This is a syntax file I've used before; the only thing I need to change, >>> normally, is the first line of the DATA LIST statement in order to >>> identify >>> the new file and the correct path to it. I show only the last few >>> comments >>> below, then my syntax, and the first few lines of a long DATA LIST >>> statement: >>> >>> /*After reading the data in, remember to save it in the path >>> C:\Documents >>> and S >>> ettings\Owner\My Documents\1 BASIC VR File Folder\12 Working 08 >>> projects\QuEx >>> tFiles\ >>> /*. >>> DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My >>> Documents\BobStuff\Dat >>> aFile\attach\kvauhda1' >>> /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I >>> 45-46(A),TEL_NBR >>> 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), >>> >>> >>> The error message I get is this: >>> > >Error # 31 in column 18. Text: C:\Documents and Settings\R. >>> Schacht\My >>> Do >>> > >File not found. >>> > >This command not executed. >>> >>> >>> Why won't the SPSS processor read the whole DATA LIST statement? >>> What is Error #31? >>> Why column 18? >>> >>> Any assistance appreciated. >>> >>> Bob >>> >>> Robert M. Schacht, Ph.D. <[hidden email]> >>> Pacific Basin Rehabilitation Research & Training Center >>> 1268 Young Street, Suite #204 >>> Research Center, University of Hawaii >>> Honolulu, HI 96814 >>> >>> ===================== >>> To manage your subscription to SPSSX-L, send a message to >>> [hidden email] (not to SPSSX-L), with no body text except the >>> command. To leave the list, send the command >>> SIGNOFF SPSSX-L >>> For a list of commands to manage subscriptions, send the command >>> INFO REFCARD >>> >>> ===================== >>> To manage your subscription to SPSSX-L, send a message to >>> [hidden email] (not to SPSSX-L), with no body text except the >>> command. To leave the list, send the command >>> SIGNOFF SPSSX-L >>> For a list of commands to manage subscriptions, send the command >>> INFO REFCARD >> >> ===================== >> To manage your subscription to SPSSX-L, send a message to >> [hidden email] (not to SPSSX-L), with no body text except the >> command. To leave the list, send the command >> SIGNOFF SPSSX-L >> For a list of commands to manage subscriptions, send the command >> INFO REFCARD >> >> > > ===================== > To manage your subscription to SPSSX-L, send a message to > [hidden email] (not to SPSSX-L), with no body text except the > command. To leave the list, send the command > SIGNOFF SPSSX-L > For a list of commands to manage subscriptions, send the command > INFO REFCARD > -- Dr. Ruben P. Konig Department of Communication telephone +31 24 3615789/3612372 Radboud University Nijmegen telefax +31 24 3613073 P. O. Box 9104 6500 HE Nijmegen [hidden email] The Netherlands http://oase.uci.kun.nl/~rkonig ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
|
|
In reply to this post by Bob Schacht-3
Instead of:
DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My Documents\BobStuff\Dat aFile\attach\kvauhda1' /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I 45-46(A),TEL_NBR 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), Delete the space/retur at the end of the first line--they are not part of the file specification so SPSS doesn't understand them. DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My Documents\BobStuff\DataFile\attach\kvauhda1' /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I 45-46(A),TEL_NBR 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), Melissa -----Original Message----- From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Bob Schacht Sent: Friday, April 18, 2008 4:07 PM To: [hidden email] Subject: [SPSSX-L] Data List error? I am just not seeing this error. My syntax program begins with a bunch of comment lines, each beginning /* This is a syntax file I've used before; the only thing I need to change, normally, is the first line of the DATA LIST statement in order to identify the new file and the correct path to it. I show only the last few comments below, then my syntax, and the first few lines of a long DATA LIST statement: /*After reading the data in, remember to save it in the path C:\Documents and S ettings\Owner\My Documents\1 BASIC VR File Folder\12 Working 08 projects\QuEx tFiles\ /*. DATA LIST FILE = 'C:\Documents and Settings\R. Schacht\My Documents\BobStuff\Dat aFile\attach\kvauhda1' /1 STAT 1-2(A),STAT_DT 3-12(ADATE),NME_L NME_F 13-44(A),NME_I 45-46(A),TEL_NBR 47-53,COUN 54-56,SECT 57-59(A),SEVERE_D VR 60-61(A), The error message I get is this: > >Error # 31 in column 18. Text: C:\Documents and Settings\R. > >Schacht\My Do File not found. > >This command not executed. Why won't the SPSS processor read the whole DATA LIST statement? What is Error #31? Why column 18? Any assistance appreciated. Bob Robert M. Schacht, Ph.D. <[hidden email]> Pacific Basin Rehabilitation Research & Training Center 1268 Young Street, Suite #204 Research Center, University of Hawaii Honolulu, HI 96814 ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD PRIVILEGED AND CONFIDENTIAL INFORMATION This transmittal and any attachments may contain PRIVILEGED AND CONFIDENTIAL information and is intended only for the use of the addressee. If you are not the designated recipient, or an employee or agent authorized to deliver such transmittals to the designated recipient, you are hereby notified that any dissemination, copying or publication of this transmittal is strictly prohibited. If you have received this transmittal in error, please notify us immediately by replying to the sender and delete this copy from your system. You may also call us at (309) 827-6026 for assistance. ===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |