Converting SPSS file with 2540 variables and 222539 observations into STATA 15 MP

[Kamal Preet]

Hello All,

I am struggling with the conversion of SPSS 25 data file to STATA 15, MP version.
I have used
1: Direct SPSS export function to STATA 14 SE version, save as option to STATA 14 SE, USESPSS user-defined program.
I keep on getting error 6452 with the SPSS and with usespss (64-bit beta version) I get the following error message

"USESPSS
Attempting to convert: C:\Users\krakhra\Documents\OCAN outcome materials\Data resources\Supportive Housing Databse\SwH_FullOCAN_FirstObs_reduced.sav
Processing started: 2019-05-21 4:57:59 PM
Error! Could't open input file. File may be locked by another application.
file C:\Users\krakhra\AppData\Local\Temp\ST_307c_000001 .tmp not found
r(601);

My question is there another option to convert SPSS to STATA.
Secondly, will STAT/Tranfer able to handel more that 2500 variables. I know my STATA MP version can handle upto 5000 variables.

Thanks

[Bruce Weaver]

Hi Kamal. I assume you mean you are trying something like this in SPSS:

SAVE TRANSLATE OUTFILE='C:\MyFolder\MyFile.dta'
  /TYPE=STATA
  /VERSION=14
  /EDITION=SE
  /MAP
  /REPLACE.

The second last bullet point on this page in the SPSS Command Syntax Reference manual suggests you should be able to export up to 32,767 variables (i.e., the limit for SE).

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

You may need to post your question to an SPSS forum to get help with SAVE TRANSLATE. The most active forum these days is the old SPSSX-L mailing list, which can also be viewed via Nabble. Click the <more options> link at the top of the page for info on how to join (or leave) the group, etc.

HTH.