Export SAS Data to Excel - change var names

[Reader587]

How to get SAS data into excel using different variable names?

[ballardw]

Please provide an example of your current variable names and what you expect the result to be.

[andreas_lds]

Depends on the way you used to export the dataset. So please post the code you have, so that we can suggest something working in your setup.

Have a look at docs the rename-statement and/or the rename-option.

[PaigeMiller · Accepted solution]

A simple example

ods excel file="newfile.xlsx";
proc print data=sashelp.class(rename=(height=tallness weight=heaviness sex=gender));
run;
ods excel close;

[Reeza]

1. Use labels and export with the labels instead - usually just an option to set on your export.
2. Change the variable names with a RENAME statement as a data set option (see PaigeMilers solution)
3. Export as separate tables using PROC REPORT and the NOHEADER options (overkill by far)

[Tom]

EXCEL files do not have variables. 

Are you asking how to make an Excel sheet with column headers that are different than the variable names in the source dataset?