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!
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.