Date:         Wed, 8 May 2002 10:04:43 -0700
Reply-To:     Shafi <shafi@SHAFIC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Shafi <shafi@SHAFIC.COM>
Organization: http://groups.google.com/
Subject:      Re: Proc Dbload - exporting labels
Content-Type: text/plain; charset=ISO-8859-1

shafi@shafic.com (Shafi) wrote in message news:<f58036d8.0205080442.2b1c0e33@posting.google.com>...
> Hi,
>
> I am trying to create an Excel file from SAS using Proc Dbload, and I
> can't seem to get it to print the labels instead of the variable
> names.
>
> %LET xlsfile=c:\temp.xls;
>
> PROC DBLOAD DBMS=xls DATA=indata;
>   PUTNAMES=y;
>   LABEL;
>   LOAD;
>   PATH="&xlsfile";
> RUN;
>
>
> Any suggestions would be most helpful.
>
> Thanks
> Shafi

Have you tried using RESET ALL; statement along with LABEL to see if
that
carries the SAS variable labels.

PROC DBLOAD DBMS=xls DATA=indata;
  PUTNAMES=y;
  LABEL;
  LOAD;
  RESET ALL;
  PATH="&xlsfile";
RUN;

Prasad Ravi


That did the trick. Note: using the RESET ALL option BEFORE the LABEL
statement will still send only the variable name.