Date: Tue, 27 Nov 2007 12:59:46 -0500
Reply-To: Wensui Liu <liuwensui@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Wensui Liu <liuwensui@GMAIL.COM>
Subject: Re: Export to Specific cell in Excel
Content-Type: text/plain; charset=ISO-8859-1
go to sugi and search for dde. lots of good papers.
and you can also find 1 or 2 on my blog if you are patient enough.
On Nov 27, 2007 11:17 AM, Metricsdude <firstname.lastname@example.org> wrote:
> On 27 Nov, 15:51, liuwen...@GMAIL.COM (Wensui Liu) wrote:
> > what OS are you using?
> > If it is windows, it should be easy with DDE.
> > On Nov 27, 2007 10:33 AM, Metricsdude <bsj_ad...@hotmail.com> wrote:
> > > Hi There,
> > > I am using version 8.2 of SAS and am currently using the ODS output to
> > > export data to excel spreadsheets,, but I am stuck!! I need to to
> > > export several tables to one spreadsheet comprising of several
> > > worksheets and to specific cells i.e
> > > Export dataset A to Worksheet 1 cell C2
> > > Export dataset B to Worksheet 2 Cell B7
> > > etc
> > > any help would would be appreciated...
> > > ben
> > --
> > ===============================
> > WenSui Liu
> > Statistical Project Manager
> > ChoicePoint Precision Marketing
> > (http://spaces.msn.com/statcompute/blog)
> > ===============================- Hide quoted text -
> > - Show quoted text -
> I am using windows XP.. Do you have an example of any code using
Statistical Project Manager
ChoicePoint Precision Marketing