Looking in the documentation, I don't see anything about that.

That would be nice to have such a capability. I figured that since SI didn't do it, it was because you could do it in the data step instead of the proc export...

My 0.00002 $

Sincerely yours, \\\|/// \\ - - // ( O O ) +-----oOOo-(_)-oOOo------------+--------------------------------+ | Patrice Bourdages | | | Information System Analyst | Tel : (418) 650-4600 x3216 | | Industrielle Alliance, | Fax : (418) 650-4825 | | Assurances auto & habitation | E-mail: pbourdages@iag.qc.ca | +--------------Oooo------------+--------------------------------+ oooO ( ) ( ) ) / \ ( (_/ \_)

-----Message d'origine----- De : Jeff Morison [mailto:jmt_mtf@YAHOO.COM] Envoyé : 20 juin, 2001 14:38 À : SAS-L@LISTSERV.UGA.EDU Objet : Ordering variables

In PROC EXPORT or in PROC DBLOAD is there anyway we could specify the order of the variables to be displayed in the EXCEL file we are exporting to.

I know how to do it in SAS when creating the dataset, using RETAIN statement before SET statement, but I would like to know if there is any option available in those procedures to order the SAS variables when the data is exported to EXCEL.

TIA, Jeff.

__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/