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
Content-Type: text/plain; charset="US-ASCII"
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.
Ods html file='someplace.somefile.xls' style=minimal;
var v1 v2 f3 f4;
Ods html close;
John Gerstle, MS
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)
>>On Behalf Of Kevin Bladon
>>Sent: Friday, September 22, 2006 11:02 AM
>>Subject: Order variables when exporting to Excel
>>Does anyone know how to select the order that my variables (columns)
>>appear in Excel when exporting from SAS?