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>
Subject: Re: Proc Dbload - exporting labels
Content-Type: text/plain; charset=ISO-8859-1
firstname.lastname@example.org (Shafi) wrote in message news:<email@example.com>...
> 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
> %LET xlsfile=c:\temp.xls;
> PROC DBLOAD DBMS=xls DATA=indata;
> Any suggestions would be most helpful.
Have you tried using RESET ALL; statement along with LABEL to see if
carries the SAS variable labels.
PROC DBLOAD DBMS=xls DATA=indata;
That did the trick. Note: using the RESET ALL option BEFORE the LABEL
statement will still send only the variable name.