Proc Export

[deleted_user]

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

[Cynthia_sas]

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

[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;