RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Other discussions about CSPro
Forum rules
New release: CSPro 8.0
Post Reply
SieAIP
Posts: 24
Joined: April 7th, 2020, 5:57 pm

RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post 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.
Last edited by SieAIP on April 23rd, 2020, 8:59 am, edited 1 time in total.
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post by josh »

Can you post or send us the dictionary and some sample data to reproduce the problem?
SieAIP
Posts: 24
Joined: April 7th, 2020, 5:57 pm

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post by SieAIP »

Okay Josh and everybody.

Here is the attachment -
StudyExerciseCAPI-SPSS.zip
(32.79 KiB) Downloaded 212 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!!!
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post 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.
SieAIP
Posts: 24
Joined: April 7th, 2020, 5:57 pm

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post by SieAIP »

The ".dat file" is coming as an MPEG MOVIE file. Find it included in here -
StudyExerciseCAPI-SPSS.zip
(33.62 KiB) Downloaded 211 times
What's happening there? How will I overcome it?

Thanks!
SieAIP
Posts: 24
Joined: April 7th, 2020, 5:57 pm

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post 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.
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post 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.
SieAIP
Posts: 24
Joined: April 7th, 2020, 5:57 pm

Re: RUNNING EXPORTED SYNTAX IN SPSS IS SHOWING ERROR!

Post 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...
Post Reply