|Date: ||Fri, 21 Nov 2003 09:03:09 -0800|
|Reply-To: ||"Terjeson, Mark" <TERJEM@DSHS.WA.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Terjeson, Mark" <TERJEM@DSHS.WA.GOV>|
|Subject: ||Re: excel|
|Content-Type: ||text/plain; charset=iso-8859-1|
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
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,
Reporting, Analysis, and Procurement Section
Information Services Division
Department of Social and Health Services
State of Washington
From: Katyal, Amit [mailto:amit.katyal@CITIGROUP.COM]
Sent: Thursday, November 20, 2003 10:59 PM
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
email : firstname.lastname@example.org