Exporting a dataset to excel

[shru]

Hi,

Just curious,Is there any method to export a sas dataset to excel format except proc export or ODS ?

Anyone suggest on this please?

Thanks

Shru

[Haikuo]

How about "DDE"?

Haikuo

[art297]

and, in addition to dde, using the excel engine in a libname statement.

[lacrefa]

If I remember On Windows Server 32 bits or on a local desktop installation you can import with something as :

LIBNAME ExcelLib ODBC Required="DBQ=&Directory.\&ExcelFile.;DriverId=790;Driver={Microsoft Excel Driver (*.xls)};DefaultDir=&Directory;FIL=excel 8.0;";

DATA _NULL_;

                       ExcelSheet = "ExcelLib.'&SheetName$'n&SASDataSetOptions";

                       CALL SYMPUT ("ExcelSheet", ExcelSheet);

RUN;

DATA &SASDataSet;

           SET &ExcelSheet;

RUN;

LIBNAME ExcelLib;