topic Re: Keep Label Headings in PROC EXPORT in New SAS User

Keep Label Headings in PROC EXPORT

marleeakerson — Tue, 24 Mar 2020 14:19:33 GMT

Hello,

I am trying to export a sas table to excel but I want the columns labels to be printed instead of the column names. Does anyone know how to do this?

ballardw — Tue, 24 Mar 2020 14:28:54 GMT

Since there are several ways to create Excel related output you might share the code for what you used so we can suggest a compatible solution.

For example if you use Proc Export then your Proc Export statement should include the option LABEL.

ghosh — Tue, 24 Mar 2020 14:30:34 GMT

Use the label option

proc export outfile='filename.xlsx' label dbms=xlsx replace; run;

marleeakerson — Tue, 24 Mar 2020 14:42:52 GMT

Here is the code I am using:

PROC EXPORT DATA=data
OUTFILE="filepath\model.xlsx"
DBMS=Excel REPLACE label;
RUN;

but it doesn't print the excel table with the labels

Ksharp — Wed, 25 Mar 2020 11:49:22 GMT

PROC EXPORT DATA=data
OUTFILE="filepath\model.xlsx"
DBMS=XLSX REPLACE label;
RUN;

or Try

PROC EXPORT DATA=data
OUTFILE="filepath\model.xlsx"
DBMS=XLSX REPLACE;

label;
RUN;