SPSSX Discussion

Export SPSS to Stata file in SPSS 22.0.0.2

Classic

List

Threaded

12 messages Options

evenfy

Export SPSS to Stata file in SPSS 22.0.0.2

CONTENTS DELETED

The author has deleted this message.

Rick Oliver-3

Re: Export SPSS to Stata file in SPSS 22.0.0.2

Are you using the dialogs to export the file? If so, use the Paste button to paste the command syntax to a syntax window. If the generated syntax contains an ENCODING subcommand, remove it. Then run the command syntax.

STATA 8 does not support Unicode. Statistics should export the file in code page encoding. The Save Data As dialog should not include an ENCODING subcommand specification. (I cannot replicate this in version 23.)

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

From: evenfy <[hidden email]>
To: [hidden email]
Date: 04/08/2015 01:02 PM
Subject: Export SPSS to Stata file in SPSS 22.0.0.2
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Hi, I am trying to export a small SPSS file (20 cases, 14 variables) from SPSS 22.0.0.2 to Stata 8 SE format. Problem is, I'm just getting an error in the output stating ">Error # 7264 >ENCODING="UTF-8" is only valid with TYPE=SAS and VERSION=9. This command not >executed. >Execution of this command stops." Funny thing is, when exporting, I can't choose which encoding I want to use. Any ideas? -- View this message in context:http://spssx-discussion.1045642.n5.nabble.com/Export-SPSS-to-Stata-file-in-SPSS-22-0-0-2-tp5729173.htmlSent 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
===================== 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

evenfy

Re: Export SPSS to Stata file in SPSS 22.0.0.2

CONTENTS DELETED

The author has deleted this message.

Rick Oliver-3

Re: Export SPSS to Stata file in SPSS 22.0.0.2

I cannot replicate your error.

Are you running in Unicode mode or code page mode? (What is the value of SHOW UNICODE?)

What is your locale? (What is the value of SHOW LOCALE?)

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

From: evenfy <[hidden email]>
To: [hidden email]
Date: 04/08/2015 01:23 PM
Subject: Re: Export SPSS to Stata file in SPSS 22.0.0.2
Sent by: "SPSSX(r) Discussion" <[hidden email]>

No, I am using the following syntax:

SAVE TRANSLATE OUTFILE='/Users/xx/test.dta'
/TYPE=STATA
/VERSION=8
/EDITION=SE
/REPLACE.

As you can see, there is no ENCODING subcommand.

Med vennlig hilsen
Even Hovig Fyllingen
Lege i spesialisering
Nevrokirurgisk avdeling
St. Olavs Hospital, Trondheim

2015-04-08 20:16 GMT+02:00 Rick Oliver [via SPSSX Discussion] <[hidden email]>:
Are you using the dialogs to export the file? If so, use the Paste button to paste the command syntax to a syntax window. If the generated syntax contains an ENCODING subcommand, remove it. Then run the command syntax.

STATA 8 does not support Unicode. Statistics should export the file in code page encoding. The Save Data As dialog should not include an ENCODING subcommand specification. (I cannot replicate this in version 23.)

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

From: evenfy <[hidden email]>
To: [hidden email]
Date: 04/08/2015 01:02 PM
Subject: Export SPSS to Stata file in SPSS 22.0.0.2
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Hi, I am trying to export a small SPSS file (20 cases, 14 variables) from SPSS 22.0.0.2 to Stata 8 SE format. Problem is, I'm just getting an error in the output stating ">Error # 7264 >ENCODING="UTF-8" is only valid with TYPE=SAS and VERSION=9. This command not >executed. >Execution of this command stops." Funny thing is, when exporting, I can't choose which encoding I want to use. Any ideas? -- View this message in context:http://spssx-discussion.1045642.n5.nabble.com/Export-SPSS-to-Stata-file-in-SPSS-22-0-0-2-tp5729173.htmlSent 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

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

If you reply to this email, your message will be added to the discussion below:
http://spssx-discussion.1045642.n5.nabble.com/Export-SPSS-to-Stata-file-in-SPSS-22-0-0-2-tp5729173p5729174.html
To unsubscribe from Export SPSS to Stata file in SPSS 22.0.0.2, click here.
NAML

View this message in context: Re: Export SPSS to Stata file in SPSS 22.0.0.2
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
===================== 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

evenfy

Re: Export SPSS to Stata file in SPSS 22.0.0.2

CONTENTS DELETED

The author has deleted this message.

Rick Oliver-3

Re: Export SPSS to Stata file in SPSS 22.0.0.2

Okay, based on your Locale value, I'm guessing you are running on a Linux OS?

I cannot replicate on Windows.

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

From: evenfy <[hidden email]>
To: [hidden email]
Date: 04/08/2015 01:34 PM
Subject: Re: Export SPSS to Stata file in SPSS 22.0.0.2
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Unicode = yes.
Locale = nb_NO.UTF-8

2015-04-08 20:29 GMT+02:00 Rick Oliver [via SPSSX Discussion] <[hidden email]>:
I cannot replicate your error.

Are you running in Unicode mode or code page mode? (What is the value of SHOW UNICODE?)

What is your locale? (What is the value of SHOW LOCALE?)

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

From: evenfy <[hidden email]>
To: [hidden email]
Date: 04/08/2015 01:23 PM
Subject: Re: Export SPSS to Stata file in SPSS 22.0.0.2
Sent by: "SPSSX(r) Discussion" <[hidden email]>

Hi, I am trying to export a small SPSS file (20 cases, 14 variables) from SPSS 22.0.0.2 to Stata 8 SE format. Problem is, I'm just getting an error in the output stating ">Error # 7264 >ENCODING="UTF-8" is only valid with TYPE=SAS and VERSION=9. This command not >executed. >Execution of this command stops." Funny thing is, when exporting, I can't choose which encoding I want to use. Any ideas? -- View this message in context:http://spssx-discussion.1045642.n5.nabble.com/Export-SPSS-to-Stata-file-in-SPSS-22-0-0-2-tp5729173.htmlSent 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

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

View this message in context: Re: Export SPSS to Stata file in SPSS 22.0.0.2
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
===================== 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

If you reply to this email, your message will be added to the discussion below:
http://spssx-discussion.1045642.n5.nabble.com/Export-SPSS-to-Stata-file-in-SPSS-22-0-0-2-tp5729173p5729176.html
To unsubscribe from Export SPSS to Stata file in SPSS 22.0.0.2, click here.
NAML

evenfy

Re: Export SPSS to Stata file in SPSS 22.0.0.2

CONTENTS DELETED

The author has deleted this message.

David Marso

Re: Export SPSS to Stata file in SPSS 22.0.0.2

Administrator

Just a guess, but MAYBE use
SET UNICODE=OFF.
prior to reading in the data file you wish to export?
YMMV!
--

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?"

evenfy

Re: Export SPSS to Stata file in SPSS 22.0.0.2

CONTENTS DELETED

The author has deleted this message.

David Marso

Re: Export SPSS to Stata file in SPSS 22.0.0.2

Administrator

Albert-Jan Roskam-2

Re: Export SPSS to Stata file in SPSS 22.0.0.2

In Linux you can generate a locale with a windows codepage. Probably also possible in OSX. So perhaps the following would be a work-around:

* in a terminal screen
sudo localedef -f CP1252 -i no_NO /usr/lib/locale/no_NO.cp1252

* in spss
Set unicode off locale = "no_NO.cp1252".
.. Then do the export

The SET commands require that no nonempty datasets be open.

Albert-Jan

From: David Marso <[hidden email]>;
To: <[hidden email]>;
Subject: Re: [SPSSX-L] Export SPSS to Stata file in SPSS 22.0.0.2
Sent: Wed, Apr 8, 2015 8:36:28 PM

No problem here.
SPSS 22 Windows 8.0 (64 bit).

--
SET UNICODE OFF.
DATA LIST FREE / a b c.
begin data
2 3 4 4 1 4 5 2 5 4 4 5 1 4 4 2 5 5 4 1 4 4 5 2 4 4 3 1 5 4 2 5 4
3 1 3 4 4 2 4 3 1
end data.

SAVE TRANSLATE OUTFILE='C:\Users\David\Documents\Untitled8x.dta'
/TYPE=STATA
/VERSION=8
/EDITION=SE
/MAP
/REPLACE.

SHOW UNICODE LOCALE.

----
Data written to C:\Users\David\Documents\Untitled8x.dta.
3 variables and 14 cases written.
Variable: a Type: Number Width: 8 Dec: 2
Variable: b Type: Number Width: 8 Dec: 2
Variable: c Type: Number Width: 8 Dec: 2
---------------------------
System Settings
Keyword    Description    Setting
UNICODE    Whether the Processor is operating in Unicode mode    No
LOCALE    country and character set    en_US.windows-1252 (en_US)

-----
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?"
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Export-SPSS-to-Stata-file-in-SPSS-22-0-0-2-tp5729173p5729182.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
<a shape="rect" ymailto="mailto:LISTSERV@LISTSERV.UGA.EDU" href="javascript:return">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

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

Albert-Jan Roskam-2

Re: Export SPSS to Stata file in SPSS 22.0.0.2

In reply to this post by David Marso

From: David Marso <[hidden email]>;
To: <[hidden email]>;
Subject: Re: [SPSSX-L] Export SPSS to Stata file in SPSS 22.0.0.2
Sent: Wed, Apr 8, 2015 8:36:28 PM