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 (July 2002, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 31 Jul 2002 08:56:17 -0400
Reply-To:     Kevin Viel <kviel@EMORY.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Kevin Viel <kviel@EMORY.EDU>
Organization: Emory University
Subject:      Re: DDE to excel and Zw. format
Content-Type: text/plain; charset=us-ascii

Richard.Simhon@cornhill.co.uk wrote: > > Kevin, > > If the cells in excel are formated as text then the following code will do > the job > > data test; > var="00123"; > var= '='||trim(var); > run; > > filename data dde "excel|sheet2!r5c3:r5c3"; > data _null_; > file data; > set test; > put var; > run; > > Hope this helps > > Richard Simhon > Business Analyst > Allianz Cornhill > Tel 01483 55 2628 >

Richard,

This did not work. However, you did shed some light on the subject. The following put the value ="00123" which appeared as 00123 in the cell:

filename data dde "excel|sheet2!r5c3:r5c3";

data _null_; var='="00123"'; file data; put var; run;

This will provide me a solution, but shouldn't SAS be able write a formatted value, such as z5. to Excel using DDE? It seems perhaps not, at least using v8.2 and Excel 95.

Thanks,

Kevin

--------------------------------

Kevin Viel Department of Epidemiology Rollins School of Public Health Emory University Atlanta, GA 30322


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