In article <39AEA22C.A2DFE873@inep.gov.br>, =?iso-8859-1?Q?Jos=E9?= Ailton Alencar Andrade <andrade@INEP.GOV.BR> wrote: > 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, itīs 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; >

The cheap (codewise) answer is to use PROC EXPORT (with PC File Formats) to create a single sheet Excel spreadsheet, and have links to that spreadsheet in your "output" spreadsheet. Then you don't use DDE at all. You just set up the "output" spreadsheet once, manually, and then update the linked data after you overwrite the source spreadsheet.

Sent via Deja.com http://www.deja.com/ Before you buy.