In article <39AEA22C.A2DFE873@inep.gov.br>,
=?iso-8859-1?Q?Jos=E9?= Ailton Alencar Andrade
> 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
> before my excel file and maintain the excel file opened during the
> exportation, so how can I create a excel file automatically by using
> 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;
> put x y z;
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.