SPSS to Stata file conversion

[Dan Buchanan-2]

Hello,

 

I’ve tried to use the ‘save as’ function in SPSS 19 to convert my sav file to a Stata file without success, nothing is produced.  Has anyone else experienced this problem?

 

Regards,

 

Dan

 

 

Dan Buchanan

Director of Financial Policy

 

OANHSS

Suite 700 - 7050 Weston Road

Woodbridge, Ontario, L4L 8G7

Tel: [phone] ext. 229

Fax: [phone]

[hidden email]

www.oanhss.org

 

[Govind Acharya-2]

Others may have a reason why the export doesn't work from SPSS, but another way to get a .sav file into Stata would be to use the "usespss" command in Stata.  You can obtain it by typing in at the prompt "findit usespss". 

Once downloaded, you would type at the prompt: usespss using "filename.sav",saving("filename.dta")

You can always type "help usespss" in Stata and it will tell you ways to import SPSS .sav files in Stata.

best,
Govind

On 10/18/2010 5:06 PM, Dan Buchanan wrote:

Hello,

 

I’ve tried to use the ‘save as’ function in SPSS 19 to convert my sav file to a Stata file without success, nothing is produced.  Has anyone else experienced this problem?

 

Regards,

 

Dan

 

 

Dan Buchanan

Director of Financial Policy

 

OANHSS

Suite 700 - 7050 Weston Road

Woodbridge, Ontario, L4L 8G7

Tel: [phone] ext. 229

Fax: [phone]

[hidden email]

www.oanhss.org

 

[SPSS Support-2]

Hi Dan,

This is a known issue on the straight 19.0 version, fixed in a hotfix bundle available from our web site, as noted in the knowledgebase resolution below.

David Nichols
SPSS Support
IBM

Resolution #90994

Problem Summary:
SAS (*.sas7bdat) and STATA (*.dta) Files cannot be saved through Save As dialog or SAVE TRANSLATE Syntax

Problem Description:
I am working with IBM SPSS Statistics 19.0.0 on a Client or Server operating system and would like to save an SPSS data file as SAS or STATA file via the menu with File - Save As or with SAVE TRANSLATE syntax. However, when I click OK on the Save As dialog or try to run the syntax nothing happens. No file or output information is created, why is this?



Resolution Summary:
This problem has been reported to SPSS Development - Workaround Available. This issue is resolved with the IBM SPSS Statistics 19.0.0 Client Hotfix Bundle.

Resolution Description:
This problem has been reported to SPSS Development - Workaround Available. This issue is resolved with the IBM SPSS Statistics 19.0.0 Client Hotfix Bundle(19.0.0.1 Hotfix). The fix will be also included in the 19.0.1 Patch.

As a workaround please download the IBM SPSS Statistics 19.0.0 Client Hotfix Bundle and install it for your Client or Server operating system. The Hotfix Bundle is available on the Technical Support webpage at http://support.spss.com on the Statistics - Patches web page. Please read the installation instructions included in the bundle zip files.
We apologize for the inconvenience.

From:	Dan Buchanan <[hidden email]>
To:	[hidden email]
Date:	10/18/2010 04:08 PM
Subject:	SPSS to Stata file conversion
Sent by:	"SPSSX(r) Discussion" <[hidden email]>

---

Hello,
 
I’ve tried to use the ‘save as’ function in SPSS 19 to convert my sav file to a Stata file without success, nothing is produced.  Has anyone else experienced this problem?
 
Regards,
 
Dan
 
 
Dan Buchanan
Director of Financial Policy
 
OANHSS
Suite 700 - 7050 Weston Road
Woodbridge, Ontario, L4L 8G7
Tel: [phone] ext. 229
Fax: [phone]
dbuchanan@...
www.oanhss.org
 

[amralasra]

I have tried converting data from spss 18 to stata 12 but it worked only for very small data set but when i tried it to a very large one including 2134 variables and over 16122 cases it . the issue is that when i gave the save as order in spss, it started saving saying in the processor area (bar) ''running saving translate'' and it was like this for hours and at the end only copied the varaiables names and not the data itself..is there another way to transfer the data?

Amralasra

[Rick Oliver-3]

What you're seeing shouldn't happen, but you can't save SPSS Statistics files as Stata 12. You can save them as versions 5-8, and there are some limits:

"For versions 5–6 and Intercooled versions 7–8, only the first 2,047 variables are saved. For Stata SE 7–8, only the first 32,767 variables are saved. "

Here's a test job that creates 20,000 cases and 3,000 variables and saves that data in Stata 8 SE format:

***create the data***.
input program.
loop #i=1 to 20000.
do repeat x=var1 to var3000.
compute x=rv.normal(50,10).
end repeat.
end case.
end loop.
end file.
end input program.

***save as stata 8 se***.
SAVE TRANSLATE OUTFILE='C:\temp\statatest.dta'
  /TYPE=STATA
  /VERSION=8
  /EDITION=SE
  /REPLACE.

***read the save file back in just to verify that everything is there***.
GET
  STATA FILE='C:\temp\statatest.dta'.




Rick Oliver
Senior Information Developer
IBM Business Analytics (SPSS)
E-mail: [hidden email]
Phone: [phone] | T/L: 206-4922



From:        amralasra <[hidden email]>
To:        [hidden email],
Date:        08/01/2012 07:02 AM
Subject:        Re: SPSS to Stata file conversion
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I have tried converting data from spss 18 to stata 12 but it worked only for
very small data set but when i tried it to a very large one including 2134
variables and over 16122 cases it . the issue is that when i gave the save
as order in spss, it started saving saying in the processor area (bar)
''running saving translate'' and it was like this for hours and at the end
only copied the varaiables names and not the data itself..is there another
way to transfer the data?

Amralasra



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-to-Stata-file-conversion-tp3218160p5714547.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

[amralasra]

I have tried saving it as stata 8 se but it took too many hours saying in the processor area (bar)
 ''running saving translate'' and even when i tried opening the new stata file, it only saved the variables names not the data itself..i still can't get your solution for what to do exactly.

[San K]

I use SPSS 18 at work and 20 at home. None of them had any trouble
with exporting 4 Mil records but under 200 variables.

If exporting doesn't work then you can always import SPSS files from
Stata using the procedure 'usespss'.

Regards,
San


On Thu, Aug 2, 2012 at 4:30 AM, amralasra <[hidden email]> wrote:

> I have tried saving it as stata 8 se but it took too many hours saying in the
> processor area (bar)
>  ''running saving translate'' and even when i tried opening the new stata
> file, it only saved the variables names not the data itself..i still can't
> get your solution for what to do exactly.
>
>
>
>
> --
> View this message in context: http://spssx-discussion.1045642.n5.nabble.com/SPSS-to-Stata-file-conversion-tp3218160p5714555.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

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

[stace swayne]

Dear listserv,

I have a data-set with n=3500 persons. I have a scale with 15 items. There are people in the data set that have missing values on all 15 items and I want to remove them from my data set before proceeding with my analysis.

Can someone suggest some code for deleting just the people who are missing on all 15 items.

All suggestions are welcomed and appreciated.

Stace

[Melissa Ives]

Use the NVALID function (check the manual for details).

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of stace swayne
Sent: Thursday, August 02, 2012 3:38 PM
To: [hidden email]
Subject: [SPSSX-L] Question about deleting cases

 

 

Dear listserv,

I have a data-set with n=3500 persons. I have a scale with 15 items. There are people in the data set that have missing values on all 15 items and I want to remove them from my data set before proceeding with my analysis.

Can someone suggest some code for deleting just the people who are missing on all 15 items.

All suggestions are welcomed and appreciated.

Stace

---

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 [phone] for assistance.

[Marhefka, Stephanie]

Hello. I will be out of the office  until Monday, August 6, 2012. I will do my best to respond to you upon my return.

 

Thank you,

Stephanie L. Marhefka, Ph.D.

 

[John F Hall]

Stace

 

You can also use combinations of COUNT and SELECT IF. If you save the file make sure you use a different name, otherwise you’ll lose the non-valid cases.

 

Assuming varnames V1 to V15 and a valid value range of 1 thru 7:

 

count scalevalid = v1 to v15 (1 thru 7) .

*check.

freq scalevalid .

 

*Should range between 0 and 15.

 

temp.

*Temporary selection of cases: full data restored after next analysis procedure.

select if (scalevalid > 0).

 

[Run analyses]

 

You can amend the above syntax to vary the number of valid responses required.

 

 

John F Hall (Mr)

 

Email:     [hidden email]

Website: www.surveyresearch.weebly.com

 

 

 

 

 

 

 

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Melissa Ives
Sent: 02 August 2012 22:47
To: [hidden email]
Subject: Re: Question about deleting cases

 

Use the NVALID function (check the manual for details).

 

From: SPSSX(r) Discussion [[hidden email]] On Behalf Of stace swayne
Sent: Thursday, August 02, 2012 3:38 PM
To: [hidden email]
Subject: [SPSSX-L] Question about deleting cases

 

 

Dear listserv,

I have a data-set with n=3500 persons. I have a scale with 15 items. There are people in the data set that have missing values on all 15 items and I want to remove them from my data set before proceeding with my analysis.

Can someone suggest some code for deleting just the people who are missing on all 15 items.

All suggestions are welcomed and appreciated.

Stace

 

---

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 [phone] for assistance.

[Mario Giesel]

... e.g.

SELECT IF (NVALID(v1,v2,v3,...,v15) >0).
EXE.

Good luck,

 Mario

---

Von: Melissa Ives <[hidden email]>
An: [hidden email]
Gesendet: 22:46 Donnerstag, 2.August 2012
Betreff: Re: Question about deleting cases

Use the NVALID function (check the manual for details).

 

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of stace swayne
Sent: Thursday, August 02, 2012 3:38 PM
To: [hidden email]
Subject: [SPSSX-L] Question about deleting cases

 

 

Dear listserv,

I have a data-set with n=3500 persons. I have a scale with 15 items. There are people in the data set that have missing values on all 15 items and I want to remove them from my data set before proceeding with my analysis.

Can someone suggest some code for deleting just the people who are missing on all 15 items.

All suggestions are welcomed and appreciated.

Stace

---

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 [phone] for assistance.

[amralasra]

I have tried converting spss data to stata but via transfering spss to csv then from csv to stata but whatever information about the variable in spss (like if it is categorical what are the categories involved and what each number indicates as a category) does not appear in stata so i can't get what the different numbers mean in stata unless i go back to the spss file and check what the value labels mean. is there a way to transfer the data and keepong the necessary information?

[amralasra]

Hello Dan,

I have the same probelm. did you manage to find a solution?

[Anthony Babinec]

Have you looked at StatTransfer from Circle Systems? It looks like it can
convert to Stata files in the following forms:

Stata(Standard)
Stata(SE)
Stata Program + ASCII data



Tony Babinec
[hidden email]


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
amralasra
Sent: Wednesday, August 08, 2012 9:37 AM
To: [hidden email]
Subject: Re: SPSS to Stata file conversion

Hello Dan,

I have the same probelm. did you manage to find a solution?

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

[amralasra]

Hi Tony,

i am sorry but i am not getting what you are trying to ssay. i have tried converting spss 19 to stata 8SE but nothing happens!!