When you use the following PROC EXPORT code to create an Excel or Access
file

   PROC EXPORT DATA= WORK.Test
                     OUTTABLE= "Prdsal2"
                     DBMS=ACCESS REPLACE;
                     DATABASE="C:\cv6l\Desktop\Sample.mde";
                     RUN;

the following error message appears

   ERROR: Invalid or missing file extension for this engine.
   ERROR: Error in the LIBNAME statement.
   ERROR: Libname _IMEX_ is not assigned

The error can appear with code that works in SAS 8.

The problem occurs because SAS 9 attempts to update the xls or mdb file
in place.  When it has an incorrect extension, the JET engine fails.

To resolve the problem, rename the file to the correct extension.

Operating System and Release Information