Error (Floating Point Exception) when importing large dataset from Stata 13 with PROC IMPORT

[ioannis]

Hi all, 

I am trying to import into SAS a large file in Stata 13 format (12gb, 29 million observations) using proc import. You can see my code and version of SAS at the end. When I run the code I get the following error: 

ERROR: Invalid Operation.
ERROR: Termination due to Floating Point Exception

I would appreciate any help finding a way around the problem (or finding the cause of the problem). Thanks a bunch.

CODE:

proc import datafile= "path\filename.dta"
out= lib.filename_new
dbms=dta 
replace;
run;

SAS Version: SAS 9.4TS Level 1M3, on X64_PRO platform

[ballardw]

My documentation for SAS 9.4.4 is that STATA 12 is the latest version of DTA files supported. So that may be the issue.

If you have access to STATA then you may want to use that program to create a version 12 file if possible, or a text delimited file such as CSV and import, or better yet write a data step to read that file. That way you may get better info as to where specific issues arise and may get a data set though some values may be missing if there are problems reading them.

[ioannis]

Thank you for the response. Converting into Stata 12 worked for importing datasets of about 4-5gb that I previously couldn't impornt. But it gives the same error when I try to import a file that's about 12gb. This is strange. Also, Stata does not allow me to export the large file into CSV (gives an error), so maybe there's something going on with the dataset. I just can't imagine what the issue is because it works perfectly fine in Stata. Thanks again for your input.