topic Re: Export SAS Data to Excel - change var names in SAS Programming

Export SAS Data to Excel - change var names

Reader587 — Mon, 04 Oct 2021 06:44:58 GMT

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

Re: SAS Data

ballardw — Mon, 04 Oct 2021 04:01:08 GMT

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

Re: Export SAS Data to Excel - change var names

andreas_lds — Mon, 04 Oct 2021 08:55:08 GMT

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.

Re: Export SAS Data to Excel - change var names

PaigeMiller — Mon, 04 Oct 2021 09:57:54 GMT

A simple example

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

Re: Export SAS Data to Excel - change var names

Reeza — Mon, 04 Oct 2021 16:23:28 GMT

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)

Re: Export SAS Data to Excel - change var names

Tom — Mon, 04 Oct 2021 16:29:20 GMT

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?