The SAS Output Delivery System and reporting techniques

Exporting a dataset to excel

Reply
Contributor
Posts: 32

Exporting a dataset to excel

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

Respected Advisor
Posts: 3,156

Re: Exporting a dataset to excel

How about "DDE"?

Haikuo

PROC Star
Posts: 7,487

Re: Exporting a dataset to excel

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

Contributor
Posts: 22

Re: Exporting a dataset to excel

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;

Ask a Question
Discussion stats
  • 3 replies
  • 332 views
  • 0 likes
  • 4 in conversation