Help using Base SAS procedures

SAS 9.4 64 bit libname problem

Reply
Regular Contributor
Posts: 208

SAS 9.4 64 bit libname problem

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!

 

Super User
Posts: 5,257

Re: SAS 9.4 64 bit libname problem

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.
Data never sleeps
Contributor
Posts: 39

Re: SAS 9.4 64 bit libname problem

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;

 

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