Date: Mon, 11 Oct 1999 00:07:10 -0700
Reply-To: cliff <cliffhavardNOclSPAM@HALIFAX.CO.UK.INVALID>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: cliff <cliffhavardNOclSPAM@HALIFAX.CO.UK.INVALID>
Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here
Subject: Re: SAS to excel ?
The following code will copy to Sheet1 B2:F250 the specified variables.
The only thing to note is that the spreadsheet must be open when you
run it.
filename R001EXP DDE "EXCEL|Sheet1!R2C2:R250C6" notab;
data _null_;
set analysis.summfile;
file R001EXP;
put a "09"x
b "09"x
_type_ "09"x
_freq_ "09"x
sumpaid "09"x;
run;
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!