Hi Amit,

You may wish to start with PROC EXPORT.

When you have a SAS dataset and use the "File"/"Export" from the pulldown menus you have the opportunity to save the automatically generated sas code to an external text file, then you can copy that code into your sas program editor and use it again or see how to implement the syntax and modify it. Such as:

PROC EXPORT DATA= Sashelp.Citiwk OUTFILE= "c:\temp\abc.xls" DBMS=EXCEL2000 REPLACE; RUN;

If you wish to control the excel spreadsheet directly we can get you examples of that too, but it is much more involved. Let us know....

Hope this is helpful, Mark Terjeson Reporting, Analysis, and Procurement Section Information Services Division Department of Social and Health Services State of Washington mailto:terjem@dshs.wa.gov

-----Original Message----- From: Katyal, Amit [mailto:amit.katyal@CITIGROUP.COM] Sent: Thursday, November 20, 2003 10:59 PM To: SAS-L@LISTSERV.UGA.EDU Subject: excel

Hi Everybody,

I would like to create excel reports from sas datasets. Please let me know where can i read more examples related to this.

Thanks & Regards

Amit Katyal email : amit.katyal@citigroup.com