Spss to Stata

[yousufzai fahim]

Hey guys is there any command to transfer/read spss file with Stata?

Thanks a lot for help.

[Joseph Coveney]

At Stata's command line, type

search spss

You can scroll down through the user-written packages to see whether there is anything that matches your needs.

Also, consider Stat/Transfer.

[David Osey]

Yousufzai - the simplest way to do this, is to open the spss data sets and go to file and save as stata file. This will transfer the spss data to a stata data whiles still keeping a version of the spss one too.

Thanks.

[Marcos Almeida]

You may save .sav files as .csv or .xls files as well, before importing into Stata.

[daniel klein]

Although the initial poster gives way too few details, I would guess that access to SPSS is not an option. Otherwise the question would be better posted in an SPSS forum. So Joseph's advice is probably the best shot here.

Best
Daniel

[yousufzai fahim]

Thank you all for the help, problem solved now.

[Bruce Weaver]

Even though Yousufzai has solved the immediate problem, I'll add this link for future reference.

• https://www.r-bloggers.com/loading-spss-sav-into-stata/

[Marcos Almeida]

This is just to say that free download (and much more) of .sav files can be done under PSPP for Windows.

For those who do not have access to SPSS, they can easily open the .sav file in PSPP, then save it as .csv or .xls, as pointed in#4, then import to Stata or other statistical package.

[Bruce Weaver]

Re PSPP (#8), here is a web-page that uses PSPP to convert from .SAV (or .SYS or .POR) to .CSV.

• http://pspp.benpfaff.org/

I suspect it will not work for the newer .ZSAV file format.

• https://www.ibm.com/support/knowledg...edatatypes.htm

HTH.

[Doug Hemken]

If you have access to Stat/Transfer, that will do the easiest and cleanest job. By far.
If you have access to SPSS, you may want to **compress** your data once you open it in Stata. In SPSS, everything is a double.

Both of these options preserve things like variable and value labels

I find the R **foreign** functions occasionally get the hiccups where there is internal data documentation (labels, notes), so if one can't use either of the first two options above, I'd recommend going the CSV route.

[ben earnhart]

I like -usespss- from Sergiy Radyakin, http://www.radyakin.org/transfer/use...espss_faq.html . I'm not certain what versions of SPSS it supports, but I'm using it with version 23 without a problem. I *could* point-and-click "save as" from within SPSS, but I like having everything in a nice .do file.

[Bruce Weaver]

I just learned of another web-based file converter that may be useful. It converts file formats between .SAV (SPSS), .dta (Stata) and CSV.

• https://rkbarney.shinyapps.io/thisnotthatstat/

HTH.

[Victor Lopez]

Hi guys,

I have tried all of the options above but none of them work.

When I save an SPSS file to stata, only the first 1000 observations appear on stata. Does anyone know why? How can I solve the issue?

Thanks in advanced!!

[Richard Williams]

What version of Stata do you have? How many cases should you have?

[Nick Cox]

Question asked in two threads, one old, one new. That's not a good idea: too much risk of wasting people's time.

See Maarten Buis' reply at https://www.statalist.org/forums/for...s-observations

I will suggest there that people interested follow this one.