https://communities.sas.com/t5/SAS-Programming/copy-the-sas-data-set-to-excel/m-p/57009#M12235 Take a look at the following SAS note:<BR /> <A href="http://support.sas.com/kb/40/613.html" target="_blank">http://support.sas.com/kb/40/613.html</A><BR /> <BR /> HTH,<BR /> Art Tue, 26 Apr 2011 16:53:43 GMT art297 2011-04-26T16:53:43Z https://communities.sas.com/t5/SAS-Programming/copy-the-sas-data-set-to-excel/m-p/57008#M12234 Hi,<BR /> <BR /> The below code was working in SAS9.1 version. Today morning,i got SAS9.2, when i ran the same code, it give the below error.<BR /> <BR /> ERROR: Connect: Unable to IDBInitialize<BR /> ERROR: Error in the LIBNAME statement.<BR /> ERROR: Libname MYEXCEL is not assigned.<BR /> <BR /> <BR /> libname myExcel "C:\folder1\t1.xls";<BR /> <BR /> proc copy in=work out=myExcel;<BR /> select data1 data2;<BR /> run;<BR /> <BR /> libname myExcel clear;<BR /> <BR /> can anyone help on this? The code is working in olderversion but not in 9.2.<BR /> <BR /> Thanks, Tue, 26 Apr 2011 16:18:50 GMT https://communities.sas.com/t5/SAS-Programming/copy-the-sas-data-set-to-excel/m-p/57008#M12234 DPraba79 2011-04-26T16:18:50Z https://communities.sas.com/t5/SAS-Programming/copy-the-sas-data-set-to-excel/m-p/57009#M12235 Take a look at the following SAS note:<BR /> <A href="http://support.sas.com/kb/40/613.html" target="_blank">http://support.sas.com/kb/40/613.html</A><BR /> <BR /> HTH,<BR /> Art Tue, 26 Apr 2011 16:53:43 GMT https://communities.sas.com/t5/SAS-Programming/copy-the-sas-data-set-to-excel/m-p/57009#M12235 art297 2011-04-26T16:53:43Z