|Date: ||Thu, 31 Aug 2000 23:53:16 +0100|
|Reply-To: ||Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Peter Crawford <Peter@CRAWFORDSOFTWARE.DEMON.CO.UK>|
|Subject: ||Re: DDE questions|
file out notab ls=5000;
do i=1 to 100;
if i = 1 then put (_all_)(= '09'x ) @1 ' ' ;
/* on first time puts name = value */
else put (_all_)( '09'x ) @1 ' ' ;
In message <39AEB54F.6901EA0E@inep.gov.br>, Josť Ailton Alencar Andrade
> Hi Peter,
> I tryed that and it worked well, now how can I include the variable
> Thank you.
>Peter Crawford wrote:
>> Jos Ailton Alencar Andrade <andrade@INEP.GOV.BR> writes
>> > Hello all,
>> > I am using the DDE utility in order to export my sas datasets to a
>> >specific sheet in excel.
>> > I am exporting several big string variables, but when I export the
>> >data, it split the bigger string variables into two cells in excel.
>> >How can I control the width of variables in order to maintain the
>> >original string values?
>> > Another questions, to use the DDE utility, its necessary to create
>> >before my excel file and maintain the excel file opened during the
>> >exportation, so how can I create a excel file automatically by using sas
>> > The last question. I noticed that SAS only export when I state the
>> >command "put <variables>". This is a problem when I have a big sas
>> >dataset, beceuse I will have to write every variable name. How can I
>> >make to SAS export every variable without state that in "PUT" command?
>> >filename out dde 'excel|c:\temp\[book1.xls]Plan1!l1c1:l10c7';
>> >data random;
>> > file out;
>> > do i=1 to 100;
>> > x=ranuni(i);
>> > y=10+x;
>> > z=x-10;
>> > put x y z;
>> > end;
>> > run;
>> Change the file statement to:
>> file out notab ls=3000;
>> and the put statement to:
>> put (x y z)( '09'x ) @1 ' ' ;
>> First ensure it works, by trying it..
>> Then look up these statements in the on-line help
>> Then ask some more questions
>> Good luck
>> Peter Crawford