LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (October 1999, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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!


Back to: Top of message | Previous page | Main SAS-L page