Problem with INSERT and INCLUDE

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem with INSERT and INCLUDE

Vlad Lopez
Hi,
I got the errors below when runnig INSERT FILE='C:\directory\labels.sps'. Got same error running INCLUDE. Does anyone have an idea what is going on?

>Error # 1 on line 1244.  Command name: ï
>The first word in the line is not recognized as an SPSS command.
>This command not executed.


>Note # 214 on line 1244.  Command name: ï
>Due to an error, INSERT and INCLUDE file processing has been terminated and
>the working file has been lost.  You may either redefine your data or leave
>SPSS.


>Note # 236
>All outstanding macros have been terminated, all INSERT and INCLUDE
>processing has been terminated, and all outstanding PRESERVE commands have
>been undone.

Thank you, 

vlad
Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

David Marso
Administrator
Maybe you should inspect the file 'C:\directory\labels.sps'.
Really a PItA flying blind Vlad!
---
Vladimir Lopez-Prado wrote
Hi,
I got the errors below when runnig INSERT FILE='C:\directory\labels.sps'.
Got same error running INCLUDE. Does anyone have an idea what is going on?

>Error # 1 on line 1244.  Command name: ï
>The first word in the line is not recognized as an SPSS command.
>This command not executed.


>Note # 214 on line 1244.  Command name: ï
>Due to an error, INSERT and INCLUDE file processing has been terminated and
>the working file has been lost.  You may either redefine your data or leave
>SPSS.


>Note # 236
>All outstanding macros have been terminated, all INSERT and INCLUDE
>processing has been terminated, and all outstanding PRESERVE commands have
>been undone.

Thank you,

vlad
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Vlad Lopez
Thank you for your quick response, David. The file 'C:\directory\labels.sps' has only labels, same as many other files I INSERT w/o errors.

var lab
  field_id '(field id) Field ID'
  chi_id '(chi_id) Child ID '
  pagelink '(pagelink) Pagelink '
....
.
val lab
  /ema_1 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_2 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_3 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
...
.

Thanks again!

vlad



On Wed, Mar 6, 2013 at 7:16 AM, David Marso <[hidden email]> wrote:
Maybe you should inspect the file 'C:\directory\labels.sps'.
Really a PItA flying blind Vlad!
---

Vladimir Lopez-Prado wrote
> Hi,
> I got the errors below when runnig INSERT FILE='C:\directory\labels.sps'.
> Got same error running INCLUDE. Does anyone have an idea what is going on?
>
>>Error # 1 on line 1244.  Command name: ï
>>The first word in the line is not recognized as an SPSS command.
>>This command not executed.
>
>
>>Note # 214 on line 1244.  Command name: ï
>>Due to an error, INSERT and INCLUDE file processing has been terminated
and
>>the working file has been lost.  You may either redefine your data or
leave
>>SPSS.
>
>
>>Note # 236
>>All outstanding macros have been terminated, all INSERT and INCLUDE
>>processing has been terminated, and all outstanding PRESERVE commands have
>>been undone.
>
> Thank you,
>
> vlad





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718405.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Rick Oliver-3
This may be caused by attempting to run a Unicode INSERT or INCLUDE file while running Statistics in code page mode.

When you create and save a syntax file in Unicode mode, Statistics inserts a byte order mark (BOM) at the beginning of the file. The BOM is not displayed  in Unicode mode, but in code page mode, Statistics may be trying to read the BOM as part of the first command.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]




From:        Vladimir Lopez-Prado <[hidden email]>
To:        [hidden email],
Date:        03/06/2013 09:50 AM
Subject:        Re: Problem with INSERT and INCLUDE
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Thank you for your quick response, David. The file 'C:\directory\labels.sps' has only labels, same as many other files I INSERT w/o errors.

var lab
  field_id '(field id) Field ID'
  chi_id '(chi_id) Child ID '
  pagelink '(pagelink) Pagelink '
....
.
val lab
  /ema_1 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_2 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_3 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
...
.

Thanks again!

vlad



On Wed, Mar 6, 2013 at 7:16 AM, David Marso <david.marso@...> wrote:
Maybe you should inspect the file 'C:\directory\labels.sps'.
Really a PItA flying blind Vlad!
---

Vladimir Lopez-Prado wrote

> Hi,
> I got the errors below when runnig INSERT FILE='C:\directory\labels.sps'.
> Got same error running INCLUDE. Does anyone have an idea what is going on?
>
>>Error # 1 on line 1244.  Command name: ï
>>The first word in the line is not recognized as an SPSS command.
>>This command not executed.
>
>
>>Note # 214 on line 1244.  Command name: ï
>>Due to an error, INSERT and INCLUDE file processing has been terminated
and
>>the working file has been lost.  You may either redefine your data or
leave
>>SPSS.
>
>
>>Note # 236
>>All outstanding macros have been terminated, all INSERT and INCLUDE
>>processing has been terminated, and all outstanding PRESERVE commands have
>>been undone.
>
> Thank you,
>
> vlad





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718405.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to

LISTSERV@... (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


Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Bruce Weaver
Administrator
In reply to this post by Vlad Lopez
Have you searched that file for the presence of "ï" (umlaut i)?


Vladimir Lopez-Prado wrote
Thank you for your quick response, David. The
file 'C:\directory\labels.sps' has only labels, same as many other files I
INSERT w/o errors.

var lab
  field_id '(field id) Field ID'
  chi_id '(chi_id) Child ID '
  pagelink '(pagelink) Pagelink '
....
.
val lab
  /ema_1 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_2 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_3 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
...
.

Thanks again!

vlad



On Wed, Mar 6, 2013 at 7:16 AM, David Marso <[hidden email]> wrote:

> Maybe you should inspect the file 'C:\directory\labels.sps'.
> Really a PItA flying blind Vlad!
> ---
>
> Vladimir Lopez-Prado wrote
> > Hi,
> > I got the errors below when runnig INSERT FILE='C:\directory\labels.sps'.
> > Got same error running INCLUDE. Does anyone have an idea what is going
> on?
> >
> >>Error # 1 on line 1244.  Command name: ï
> >>The first word in the line is not recognized as an SPSS command.
> >>This command not executed.
> >
> >
> >>Note # 214 on line 1244.  Command name: ï
> >>Due to an error, INSERT and INCLUDE file processing has been terminated
> and
> >>the working file has been lost.  You may either redefine your data or
> leave
> >>SPSS.
> >
> >
> >>Note # 236
> >>All outstanding macros have been terminated, all INSERT and INCLUDE
> >>processing has been terminated, and all outstanding PRESERVE commands
> have
> >>been undone.
> >
> > Thank you,
> >
> > vlad
>
>
>
>
>
> -----
> Please reply to the list and not to my personal email.
> Those desiring my consulting or training services please feel free to
> email me.
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718405.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> 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
>
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING: 
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).
Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Vlad Lopez
I did search "ï" in both the code and the file to be INSERTed, Bruce, but couldn't find it.
Thanks,

vlad

On Wed, Mar 6, 2013 at 8:19 AM, Bruce Weaver <[hidden email]> wrote:
Have you searched that file for the presence of "ï" (umlaut i)?



Vladimir Lopez-Prado wrote
> Thank you for your quick response, David. The
> file 'C:\directory\labels.sps' has only labels, same as many other files I
> INSERT w/o errors.
>
> var lab
>   field_id '(field id) Field ID'
>   chi_id '(chi_id) Child ID '
>   pagelink '(pagelink) Pagelink '
> ....
> .
> val lab
>   /ema_1 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
>   /ema_2 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
>   /ema_3 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
> ...
> .
>
> Thanks again!
>
> vlad
>
>
>
> On Wed, Mar 6, 2013 at 7:16 AM, David Marso <

> david.marso@

> > wrote:
>
>> Maybe you should inspect the file 'C:\directory\labels.sps'.
>> Really a PItA flying blind Vlad!
>> ---
>>
>> Vladimir Lopez-Prado wrote
>> > Hi,
>> > I got the errors below when runnig INSERT
>> FILE='C:\directory\labels.sps'.
>> > Got same error running INCLUDE. Does anyone have an idea what is going
>> on?
>> >
>> >>Error # 1 on line 1244.  Command name: ï
>> >>The first word in the line is not recognized as an SPSS command.
>> >>This command not executed.
>> >
>> >
>> >>Note # 214 on line 1244.  Command name: ï
>> >>Due to an error, INSERT and INCLUDE file processing has been terminated
>> and
>> >>the working file has been lost.  You may either redefine your data or
>> leave
>> >>SPSS.
>> >
>> >
>> >>Note # 236
>> >>All outstanding macros have been terminated, all INSERT and INCLUDE
>> >>processing has been terminated, and all outstanding PRESERVE commands
>> have
>> >>been undone.
>> >
>> > Thank you,
>> >
>> > vlad
>>
>>
>>
>>
>>
>> -----
>> Please reply to the list and not to my personal email.
>> Those desiring my consulting or training services please feel free to
>> email me.
>> --
>> View this message in context:
>> http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718405.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>>

> LISTSERV@.UGA

>  (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
>>





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718408.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Vlad Lopez
In reply to this post by Rick Oliver-3
Yep, you got the answer Rick! I (wrongly) saved the file as UTF-8 and after re-saving not as unicode, it runs as smooth as always.
Thank you all!

vlad

On Wed, Mar 6, 2013 at 8:16 AM, Rick Oliver <[hidden email]> wrote:
This may be caused by attempting to run a Unicode INSERT or INCLUDE file while running Statistics in code page mode.

When you create and save a syntax file in Unicode mode, Statistics inserts a byte order mark (BOM) at the beginning of the file. The BOM is not displayed  in Unicode mode, but in code page mode, Statistics may be trying to read the BOM as part of the first command.

Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]




From:        Vladimir Lopez-Prado <[hidden email]>
To:        [hidden email],
Date:        03/06/2013 09:50 AM
Subject:        Re: Problem with INSERT and INCLUDE
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Thank you for your quick response, David. The file 'C:\directory\labels.sps' has only labels, same as many other files I INSERT w/o errors.

var lab
  field_id '(field id) Field ID'
  chi_id '(chi_id) Child ID '
  pagelink '(pagelink) Pagelink '
....
.
val lab
  /ema_1 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_2 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
  /ema_3 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
...
.

Thanks again!

vlad



On Wed, Mar 6, 2013 at 7:16 AM, David Marso <[hidden email]> wrote:
Maybe you should inspect the file 'C:\directory\labels.sps'.
Really a PItA flying blind Vlad!
---

Vladimir Lopez-Prado wrote

> Hi,
> I got the errors below when runnig INSERT FILE='C:\directory\labels.sps'.
> Got same error running INCLUDE. Does anyone have an idea what is going on?
>
>>Error # 1 on line 1244.  Command name: ï
>>The first word in the line is not recognized as an SPSS command.
>>This command not executed.
>
>
>>Note # 214 on line 1244.  Command name: ï
>>Due to an error, INSERT and INCLUDE file processing has been terminated
and
>>the working file has been lost.  You may either redefine your data or
leave
>>SPSS.
>
>
>>Note # 236
>>All outstanding macros have been terminated, all INSERT and INCLUDE
>>processing has been terminated, and all outstanding PRESERVE commands have
>>been undone.
>
> Thank you,
>
> vlad





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718405.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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



Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Jon K Peck
In reply to this post by Bruce Weaver
I suspect a character encoding mismatch.  Does your file contain any extended characters (accented, Cyrillic, or such)?  Are you in Unicode or code page mode, and is your SPSS locale consistent with the file?

If you want to send me the file, I can figure this out.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        Bruce Weaver <[hidden email]>
To:        [hidden email],
Date:        03/06/2013 09:26 AM
Subject:        Re: [SPSSX-L] Problem with INSERT and INCLUDE
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




Have you searched that file for the presence of "ï" (umlaut i)?



Vladimir Lopez-Prado wrote
> Thank you for your quick response, David. The
> file 'C:\directory\labels.sps' has only labels, same as many other files I
> INSERT w/o errors.
>
> var lab
>   field_id '(field id) Field ID'
>   chi_id '(chi_id) Child ID '
>   pagelink '(pagelink) Pagelink '
> ....
> .
> val lab
>   /ema_1 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
>   /ema_2 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
>   /ema_3 0 '(0) incorrect' 1 '(1) correct' 9 '(9) no response'
> ...
> .
>
> Thanks again!
>
> vlad
>
>
>
> On Wed, Mar 6, 2013 at 7:16 AM, David Marso &lt;

> david.marso@

> &gt; wrote:
>
>> Maybe you should inspect the file 'C:\directory\labels.sps'.
>> Really a PItA flying blind Vlad!
>> ---
>>
>> Vladimir Lopez-Prado wrote
>> > Hi,
>> > I got the errors below when runnig INSERT
>> FILE='C:\directory\labels.sps'.
>> > Got same error running INCLUDE. Does anyone have an idea what is going
>> on?
>> >
>> >>Error # 1 on line 1244.  Command name: ï
>> >>The first word in the line is not recognized as an SPSS command.
>> >>This command not executed.
>> >
>> >
>> >>Note # 214 on line 1244.  Command name: ï
>> >>Due to an error, INSERT and INCLUDE file processing has been terminated
>> and
>> >>the working file has been lost.  You may either redefine your data or
>> leave
>> >>SPSS.
>> >
>> >
>> >>Note # 236
>> >>All outstanding macros have been terminated, all INSERT and INCLUDE
>> >>processing has been terminated, and all outstanding PRESERVE commands
>> have
>> >>been undone.
>> >
>> > Thank you,
>> >
>> > vlad
>>
>>
>>
>>
>>
>> -----
>> Please reply to the list and not to my personal email.
>> Those desiring my consulting or training services please feel free to
>> email me.
>> --
>> View this message in context:
>>
http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718405.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>>

> LISTSERV@.UGA

>  (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
>>





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Problem-with-INSERT-and-INCLUDE-tp5718404p5718408.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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


Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Albert-Jan Roskam
In reply to this post by Rick Oliver-3
>This may be caused by attempting to run

a Unicode INSERT or INCLUDE file while running Statistics in code page
mode.
>
>When you create and save a syntax file
in Unicode mode, Statistics inserts a byte order mark (BOM) at the beginning
of the file. The BOM is not displayed  in Unicode mode, but in code
page mode, Statistics may be trying to read the BOM as part of the first
command.

Interesting. Is the BOM to indicate that the file is in utf-8 (even if all the subsequent characters are plain ascii, 0-127), or is it used to indicate the endianness of the file? Or yet something else?

Regards,
Albert-Jan

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Problem with INSERT and INCLUDE

Jon K Peck
utf-8 does not care about endianness.  Statistics writes a BOM on a Unicode syntax file and uses that to determine that the file is in Unicode in the absence of other evidence.


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: 720-342-5621




From:        Albert-Jan Roskam <[hidden email]>
To:        [hidden email],
Date:        03/06/2013 12:42 PM
Subject:        Re: [SPSSX-L] Problem with INSERT and INCLUDE
Sent by:        "SPSSX(r) Discussion" <[hidden email]>




>This may be caused by attempting to run

a Unicode INSERT or INCLUDE file while running Statistics in code page
mode.
>
>When you create and save a syntax file
in Unicode mode, Statistics inserts a byte order mark (BOM) at the beginning
of the file. The BOM is not displayed  in Unicode mode, but in code
page mode, Statistics may be trying to read the BOM as part of the first
command.

Interesting. Is the BOM to indicate that the file is in utf-8 (even if all the subsequent characters are plain ascii, 0-127), or is it used to indicate the endianness of the file? Or yet something else?

Regards,
Albert-Jan

=====================
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