topic Re: Exporting a dataset to excel in ODS and Base Reporting

Exporting a dataset to excel

shru — Wed, 15 Aug 2012 03:20:55 GMT

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

Re: Exporting a dataset to excel

Haikuo — Wed, 15 Aug 2012 03:33:54 GMT

How about "DDE"?

Haikuo

Re: Exporting a dataset to excel

art297 — Wed, 15 Aug 2012 04:05:25 GMT

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

Re: Exporting a dataset to excel

lacrefa — Mon, 27 Aug 2012 11:36:28 GMT

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;