Date:         Tue, 28 May 2002 10:06:26 -0400
Reply-To:     Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <ghellrieg@T-ONLINE.DE>
Subject:      Re: re-order of the output vars

On Tue, 28 May 2002 09:14:03 -0400, Min Qi Wang <mqw@GLUE.UMD.EDU> wrote:

>Hi: would some one help with this question:
>
>I'd like to output a series of vars (say, A B C as input), to Excel in
>the following order:  B C D.
>
>Thank you for sharing your experience.
>
>Mitch


Use DDE:

filename a dde "Excel|[Mappe1]Tabelle1!Z1S1:Z31S3";
data _null_;
  set sasuser.class;
  file a;
  put name height weight;
run;

with the PUT statement you can choose any sequence you want.
In the DDE triplet simply use a area big enough to get all obs and
variables you have in the dataset or you want to put into. The DDE triplet
you can also get from EXCEL. Start EXCEL, mark the desired area and
use "copy" for that area. Go to SAS, pmenu Solutions - Accessories - DDE
Triplet and you get it in a window where you can "cut and paste" it.
With numeric variables, just be careful, that you use the appropriate
decimal character. E.g. for german EXCELs that is a "," instead of ".". So
for that EXCELs it is better to put the numerics with the COMMAX - format.