Export to Excel error message means what?

Reply
Regular Contributor
Posts: 223

Export to Excel error message means what?

Can someone please explain what the issue here might be?

(What in the world is _IMEX_?)

proc export data=nicholas._21603_

outfile= "c:\downloads\21603.xls"

dbms=excel

label

replace;

run;

NOTE: File "c:\downloads\21603.xls" will be created if the export process succeeds.

ERROR: Execute: Unable to insert row

WARNING: File deletion failed for _IMEX_._21603_.DATA.

ERROR: Export unsuccessful.

NOTE: The SAS System stopped processing this step because of errors.

Regular Contributor
Posts: 223

Re: Export to Excel error message means what?

Posted in reply to NicholasKormanik

Hint...  Just realized that there are more than 65,000 rows of data, which is the limit for .xls.

Will try to change the export to .xlsx.

Super Contributor
Posts: 644

Re: Export to Excel error message means what?

Posted in reply to NicholasKormanik

I think _IMEX_ is an intermediate file/stage/process in the IMport/EXport routine.  You can get a similar error if the file is currently (or sometimes has been recently) open in Excel.

Richard

Regular Contributor
Posts: 223

Re: Export to Excel error message means what?

Posted in reply to NicholasKormanik

Here's the code that worked, for both exporting and then importing back.

This is using Windows XP SR3, SAS 9.3 M1, Excel 2010.

proc export data=nicholas._21603_

outfile= 'c:\downloads\21603.xlsx'

dbms=xlsx    /*  or can use dbms=excel2007, but it's a bit slower  */

label

replace;

run;

proc import

datafile='c:\downloads\21603.xlsx'

out=nicholas._21603_swapped

dbms=excel2007       /*  dbms= xlsx  fails with just error messages in import  */

replace;

getnames=yes;

mixed=no;

scantext=yes;

usedate=yes;

scantime=yes;

run;

Ask a Question
Discussion stats
  • 3 replies
  • 2240 views
  • 3 likes
  • 2 in conversation