I have exported data from SAS to STATA hundreds of times with no problems. Recently, I keep getting the error: "Invalid Operation" "Termination due to Floating Point Exception". I have looked online on how to remedy this, but have not had success.
I would appreciate any advice to fix this.
I am copying in below the relevant part of my log file.
NOTE: Table MUNI.WSJ_EVERYTHINGBTRADEZTW created, with 95404 rows and 73 columns.
79 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.76 seconds
cpu time 0.09 seconds
80
81
82 Proc export DATA=muni.WSJ_everythingBtradeztw DBMS=STATA
83 OUTfile='H:\SASdata\Bank\muni\vol_1trades_all_issuers_30days_wsjBtw'
84 replace;
85 Run;
ERROR: Invalid Operation.
ERROR: Termination due to Floating Point Exception
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set MUNI.WSJ_EVERYTHINGBTRADEZTW.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.06 seconds
cpu time 0.01 seconds
Is it an intermittent problem or does it happen with all STATA exports? Does it only happen with certain datasets or any or all datasets? Does the same problem occur writing to a local drive like C:?
It is intermittent, it has only started today. I am able to export a simple dataset to STATA, but for whatever reason, not the one I would like to.
I use SAS/STATA through a remote connection, I do not have authorization to write a file to the C: drive.
Does it always fail for the same file? Or does it seem to fail randomly.
If you have a file that always caused the error the try to figure out what it is about that file. Try dropping some of the variables. Try subsetting the number of observations. Until you can figure if there is a specific data value that is causing the issue.
Make sure the H drive has the space needed to save the file. Try having SAS write the file to your SAS work directory instead to make sure it isn't an issue with that drive.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: