Help using Base SAS procedures

Proc Export

Reply
N/A
Posts: 0

Proc Export

I use proc export to put my data into Excel but how can I have the Variable labels printed into Excel other than the Variable names.. I know ODS does't it by does Proc Export have some option to do that ??

Matt
SAS Super FREQ
Posts: 8,868

Re: Proc Export

Posted in reply to deleted_user
Hi:
PROC EXPORT in SAS 9.2 does have the LABEL option (I think it was new for 9.2, though so it might not work in SAS 9.1.3):
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a000316288.htm

cynthia
N/A
Posts: 0

Re: Proc Export

Posted in reply to deleted_user
You can also use the dblabel option in the Excel libname.

libname xls "C:\test.xls";
data mylib.mydata(dblabel=yes);
set new;
run;
libname xls clear;
Ask a Question
Discussion stats
  • 2 replies
  • 303 views
  • 0 likes
  • 2 in conversation