Date:         Tue, 27 Apr 2004 16:46:10 -0400
Reply-To:     Venky Chakravarthy <venky.chakravarthy@PFIZER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Venky Chakravarthy <venky.chakravarthy@PFIZER.COM>
Subject:      Re: exporting and preserving formats and labels
Comments: To: kossackw@NJC.ORG

On Tue, 27 Apr 2004 13:14:56 -0600, William Kossack <kossackw@NJC.ORG>
wrote:

>How can I export (convert from sas to excel) a sas dataset while
>preserving the formats and labels?

You could possible use the 8.2 experimental ODS CSV to do this. Note
however, you can get either the column names or the column labels but not
both. You may be able to do that with DDE.

Sample untested suggestion retrieved from memory:

ods listing close ;
ods csv file = <path with .csv extension filename> ;
proc print noobs data = <your data> label ;
  format <vars if they are not already formated> ;
run ;
ods csv close ;
ods listing ;

Venky Chakravarthy