something like data random; file out notab ls=5000; do i=1 to 100; x=ranuni(i); y=10+x; z=x-10; if i = 1 then put (_all_)(= '09'x ) @1 ' ' ; /* on first time puts name = value */ else put (_all_)( '09'x ) @1 ' ' ; end; run;

In message <39AEB54F.6901EA0E@inep.gov.br>, José Ailton Alencar Andrade <andrade@inep.gov.br> writes > > Hi Peter, > > I tryed that and it worked well, now how can I include the variable >names? > > Thank you. > Ailton > > >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 >> >commads? >> > >> > 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 >

-- Peter Crawford