There is this stata command savespss . You need to install this command before you can use it.
Type the following in your stata command window, ensure that you are connected to the internet.
ssc instal savespss
once installed , load your stata file and use the comand to save the file as spss.
use "filename.dta"
savespss "filename.sav"
1. Reading a Stata file up to version 9 with SPSS
SPSS 15 and above currently supports Stata up to version 9. A Stata data file can be read in SPSS either via pull-down menu or via syntax using the get stata file command.
Using the pull-down menus select File -> Open -> Data... and then for Files of Type select the appropriate data file type; then select the file from the list and click Open. That is all to it.
With SPSS syntax we can use the get stata file command to read in a Stata data file.
get stata file='C:\data\states.dta'.
2. Saving a Stata data file as a version 9 file
If you have a newer version of Stata such as Stata 10, you can save a data file as a version 9 file with the saveold command. Here is an example.
use http://www.ats.ucla.edu/stat/stata/notes/hsb2, clear
(highschool and beyond (200 cases))
saveold "c:\data\hsb2old.dta"
file c:\data\hsb2old.dta saved
3. Using Stat/Transfer
the source is
http://www.ats.ucla.edu/stat/mult_pkg/faq/fromStata_toSPSS.htm
The most useful way to do this is to get a copy of StatTransfer. Transferring from one package to another requires good software that will handle things like missing values, labels, variable formats etc correctly. For example, Stata can store variables like business calendar data that SPSS cannot handle.
For the record, SPSS's ability to output Stata files is dismal. It does things like identifying a variable as numeric even though it contains string data.
As a partial workaround, you might try R, but it's not really a bullet-proof solution.
There are a couple of ways. If you are using Stata 9 or older and SPSS 15 or higher, SPSS will recognize the Stata file format. In SPSS there is a command to get stata file format, as well as a gui interface option. I'm not sure where, as I'm a Stata user, but its there if you search SPSS's help files.
The other way is to use Stat/transfer, which is a standalone package that will convert any of your stata files into other package formats. Check out stat/transfer here http://www.stattransfer.com/index.html.
Or you could always export from stata into an excel file and then import it into SPSS. You'll lose your variable labels, but as a last resort its an option.
Hello there,
Please follow the link below
Best wishes
http://www.ats.ucla.edu/stat/mult_pkg/faq/fromStata_toSPSS.htm
You could just export as excel from Stata and then import into SPSS
There is this stata command savespss . You need to install this command before you can use it.
Type the following in your stata command window, ensure that you are connected to the internet.
ssc instal savespss
once installed , load your stata file and use the comand to save the file as spss.
use "filename.dta"
savespss "filename.sav"
In my case savespss did not work at all. So I turned to R as some others suggested. It's pretty straightforward in R. Here is my code:
#setup your working folder path #
setwd("/users/.../projectX")
#install and load two packages, "rio" and "haven" #
install.packages("rio","haven")
library(rio)
library(haven)
#use function in the package "rio" for Stata formats after 12 to load imported data in a new object (let us call it x) #
x
For thos who have MLwiN - you can convert between SPSS, MINITAB, Stata and (of course MLwiN)
see http://www.bristol.ac.uk/cmm/software/support/support-faqs/data-in/
here is another website: https://stats.idre.ucla.edu/other/mult-pkg/faq/how-do-i-use-a-stata-data-file-in-spss/
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS