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>
Subject: Re: Label in PROC EXPORT
Content-Type: text/plain; charset=ISO-8859-1
On Sep 2, 1:25 pm, Arthur Tabachneck <art...@netscape.net> wrote:
> 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
> 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.