Page 1 of 1

RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 22nd, 2020, 7:57 pm
by SieAIP
Hello CSPro users, I'm trying to export data into spss and bellow is the error message I get while running the syntax in spss. It reads exactly as pasted in red bellow;


DATA LIST FILE='C:\Users\SirAIP Guru d'Genius\Desktop\I&T Consulting\CSPro for CAPI\Study Exercise\New folder\CAPI - SPSS issues\Exported.dat' RECORDS=1

>Warning # 206 in column 46. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 54. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 69. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 84. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 99. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 110. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 129. Text: \
>An invalid character has been found on a command.

>Warning # 208 in column 142. Text: RECORDS=1
>A text string is not correctly enclosed in quotation marks on the command
>line. Literals may not be continued across command lines without the use of
>the continuation symbol '+'.
/
RESP_ID 1-2
Q1 3-62 (A)
Q2 63-72 (A)
Q3 73-73
Q4 74-88 (A)
.

>Error # 4100 in column 40. Text: Genius
>Unrecognized text appears on the DATA LIST command in the file specification
>section. This text will be ignored.
>Execution of this command stops.




Please can somebody tell me why this error is displaying and how I can run the syntax???
Thanks in waiting

More details:
I'm using CSPro 7.3(1), spss version 20, my pc is running on windows 8.

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 22nd, 2020, 8:03 pm
by josh
Can you post or send us the dictionary and some sample data to reproduce the problem?

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 23rd, 2020, 7:07 am
by SieAIP
Okay Josh and everybody.

Here is the attachment -
StudyExerciseCAPI-SPSS.zip
(32.79 KiB) Downloaded 215 times
The zip file contains the entire study application and the spss syntax file I'm trying to run that is giving me error as reported above.

Please what's the way forward here?

Thanks in Waiting!!!

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 23rd, 2020, 8:19 am
by josh
The files you sent are not the ones causing the errors. The error message mentions these variables:

RESEARCHER_ID 1-2
STATE_ID 3-4
RESPONDENT_NUMBER 5-7

The dictionary and data you sent does not have those variables.

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 23rd, 2020, 8:47 am
by SieAIP
The ".dat file" is coming as an MPEG MOVIE file. Find it included in here -
StudyExerciseCAPI-SPSS.zip
(33.62 KiB) Downloaded 214 times
What's happening there? How will I overcome it?

Thanks!

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 23rd, 2020, 9:02 am
by SieAIP
Sorry Josh!

I have edited to the correct error message now. You can also find it here bellow;


DATA LIST FILE='C:\Users\SirAIP Guru d'Genius\Desktop\I&T Consulting\CSPro for CAPI\Study Exercise\New folder\CAPI - SPSS issues\Exported.dat' RECORDS=1

>Warning # 206 in column 46. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 54. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 69. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 84. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 99. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 110. Text: \
>An invalid character has been found on a command.

>Warning # 206 in column 129. Text: \
>An invalid character has been found on a command.

>Warning # 208 in column 142. Text: RECORDS=1
>A text string is not correctly enclosed in quotation marks on the command
>line. Literals may not be continued across command lines without the use of
>the continuation symbol '+'.
/
RESP_ID 1-2
Q1 3-62 (A)
Q2 63-72 (A)
Q3 73-73
Q4 74-88 (A)
.

>Error # 4100 in column 40. Text: Genius
>Unrecognized text appears on the DATA LIST command in the file specification
>section. This text will be ignored.
>Execution of this command stops.

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 23rd, 2020, 12:18 pm
by josh
I think the problem is that you have ' in your directory name - SirAIP Guru d'Genius. SPSS can't handle paths with ' in them. Try it in a directory that doesn't have a ' in it.

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Posted: April 23rd, 2020, 2:41 pm
by SieAIP
Wow! Thanks Josh...

I just changed it to a directory that has no ( ' ) in it's pathway and it worked this time around...

CSPro users community is wonderful...

Thanks many many more times guys...