DATA Step, Macro, Functions and more

copy the sas data set to excel

Reply
Contributor
Posts: 34

copy the sas data set to excel

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,
PROC Star
Posts: 7,487

Re: copy the sas data set to excel

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

HTH,
Art
Ask a Question
Discussion stats
  • 1 reply
  • 125 views
  • 0 likes
  • 2 in conversation