topic Re: Proc Export in SAS Procedures

Proc Export

deleted_user — Fri, 23 Apr 2010 17:12:25 GMT

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

Re: Proc Export

Cynthia_sas — Fri, 23 Apr 2010 18:05:57 GMT

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

Re: Proc Export

deleted_user — Mon, 03 May 2010 01:24:13 GMT

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;