BookmarkSubscribeRSS Feed
marleeakerson
Calcite | Level 5

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?

4 REPLIES 4
ballardw
Super User

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
Barite | Level 11

Use the label option

https://support.sas.com/kb/41/735.html

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

 

marleeakerson
Calcite | Level 5

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
Super User

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;

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1403 views
  • 1 like
  • 4 in conversation