Quantcast

SPSS to Stata file conversion

classic Classic list List threaded Threaded
16 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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: 905-851-8821 ext. 229

Fax: 905-851-0744

[hidden email]

www.oanhss.org

 

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

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: 905-851-8821 ext. 229

Fax: 905-851-0744

[hidden email]

www.oanhss.org

 


--
Govind Acharya
Research Analyst
Ithaca College
217 Peggy R. Williams Center
953 Danby Rd.
Ithaca, NY 14850-7002

phone: (607) 274-3876
fax: (607) 274-1861
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

SPSS Support-2
In reply to this post by Dan Buchanan-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: 905-851-8821 ext. 229
Fax: 905-851-0744
dbuchanan@...
www.oanhss.org
 
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

Rick Oliver
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: 312.893.4922 | 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


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

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.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Question about deleting cases

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Question about deleting cases

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 (309) 827-6026 for assistance.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Automatic reply: Question about deleting cases

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.

 

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Question about deleting cases

John F Hall
In reply to this post by Melissa Ives

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 (309) 827-6026 for assistance.

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Question about deleting cases

Mario Giesel
In reply to this post by Melissa Ives
... 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 (309) 827-6026 for assistance.


Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

amralasra
In reply to this post by Rick Oliver
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?
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: SPSS to Stata file conversion

amralasra
In reply to this post by Dan Buchanan-2
Hello Dan,

I have the same probelm. did you manage to find a solution?
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

FW: SPSS to Stata file conversion

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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: FW: SPSS to Stata file conversion

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!!
Loading...