SAS 9.4 64 bit libname problem

[GeorgeSAS]

Hello,

I have SAS 9.4 64 bit installed.I want use an excel file in SAS with libname method, but this does not works:

LIBNAME mylib  "C:\Users\mike\abc.xlsx" ;

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

Please help.

Thanks!

[LinusH]

The key is the bitness of your office installation.
There have been a LOT of threads on the communities so I suggest you do a search and return if you still fail to do the connection.

[Pamela_JSRCC]

We just upgraded to 9.4 64-bits.  This is what I found that works:

/* Export */

%let xlsTempFile = &xlsPath.\temp.xlsx;

data _null_;

   fileref = 'tempfile';

   rc = filename(fileref, "&xlsTempFile");

   if rc = 0 and fExist(fileref) then

      rc = fDelete(fileref);

run;

*For SAS 64-bit ver 9.4;

*libname wkbk pcFiles path="&xlsTempFile"; * This looks good except that Excel cannot read the file;

libname wkbk xlsx "&xlsTempFile"; * This creates a file that Excel can read;

data wkbk.data;     * Create destination worksheet "data" within the Excel workbook;

  set sashelp.cars; * Write the dataset into the worksheet;

run;

libname wkbk clear; * Close the workbook;

/* Import */

libname wkbk pcFiles path="&xlsPath.\temp.xlsx"; * Open an existing Excel workbook

                                                   using 64-bit SAS ver 9.4;

data temp; * Create new dataset;

  set wkbk.'data$'n; * Read the "data" worksheet into the dataset;

run;

libname wkbk clear; * Close the Excel file;