Date:         Fri, 22 Sep 2006 11:17:27 -0400
Reply-To:     "Gerstle, John (CDC/CCID/NCHSTP) (CTR)" <yzg9@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Gerstle, John (CDC/CCID/NCHSTP) (CTR)" <yzg9@CDC.GOV>
Subject:      Re: Order variables when exporting to Excel
Comments: To: Kevin Bladon <kevin.bladon@SILVACOM.COM>
Content-Type: text/plain; charset="US-ASCII"

Kevin,
What are you using (PROC-wise) to send you data to Excel?  Generally,
select the variables explicitly in a PROC PRINT, REPORT, TABULATE, etc..
and use ODS HTML, Tagsets, etc. to send to Excel.

I.e.:
Ods html file='someplace.somefile.xls' style=minimal;
Proc print;
        var v1 v2 f3 f4;
Run;
Ods html close;

John Gerstle, MS
Biostatistician
Northrop Grumman
CDC Information Technological Support Contract (CITS)
NCHSTP \DHAP \HICSB \Research, Analysis, and Evaluation Section
Centers for Disease Control and Prevention

"Boss. We've got cats."  "Meow"

"All truth passes through three stages:
        First, it is ridiculed;
        Second, it is violently opposed;
       Third, it is accepted as being self-evident."
        - Arthur Schopenhauer (1830)


>>-----Original Message-----
>>From: owner-sas-l@listserv.uga.edu
[mailto:owner-sas-l@listserv.uga.edu]
>>On Behalf Of Kevin Bladon
>>Sent: Friday, September 22, 2006 11:02 AM
>>To: SAS-L@LISTSERV.UGA.EDU
>>Subject: Order variables when exporting to Excel
>>
>>Hello all,
>>
>>Does anyone know how to select the order that my variables (columns)
will
>>appear in Excel when exporting from SAS?
>>
>>Thanks,
>>Kevin Bladon