Date:         Wed, 2 Sep 2009 10:31:38 -0700
Reply-To:     Sri <subhadrasri@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sri <subhadrasri@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Label in PROC EXPORT
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On Sep 2, 1:25 pm, Arthur Tabachneck <art...@netscape.net> wrote:
> Sri,
>
> You might want to take a look at Vince DelGobbo's paper on exporting
> to XML, as it does provide a way to export the labels.  You can find
> it at:http://support.sas.com/rnd/papers/sugi29/ExcelXML.pdf
>
> HTH,
> Art
> ------------
> On Sep 2, 12:17 pm, Sri <subhadra...@gmail.com> wrote:
>
>
>
> > Hello All,
> > Can any one of you let me know how to use LABEL option in PROC EXPORT.
> > I defined labels for my variables in PROC SQL step and i want to ouput
> > the data into excel using proc export. But SAS is writing only
> > variable names, not labels.
>
> > Here is the example code:
>
> > proc sql;
> > create table class as select
> > name label="Name of the Student",
> > sex label="Gender of the Student"
> > from sashelp.class;
> > quit;
>
> > proc export data=class outfile='C:\temp\Class.xls'
> > DBMS=EXCEL REPLACE; label;
> > run;
>
> > I greatly appreciate any kind of help.
>
> > Thanks,
> > Sri- Hide quoted text -
>
> - Show quoted text -

Thank you Kenneth and Arthur for your responses.