copy the sas data set to excel

[DPraba79]

Hi,

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.

ERROR: Connect: Unable to IDBInitialize
ERROR: Error in the LIBNAME statement.
ERROR: Libname MYEXCEL is not assigned.


libname myExcel "C:\folder1\t1.xls";

proc copy in=work out=myExcel;
select data1 data2;
run;

libname myExcel clear;

can anyone help on this? The code is working in olderversion but not in 9.2.

Thanks,

[art297]

Take a look at the following SAS note:
http://support.sas.com/kb/40/613.html

HTH,
Art