Proc report provides column name, "NAME OF FORMER VARIABLE"

[Barkat]

When I run the following code. The column name of the "name" variable displays as "NAME OF FORMER VARIABLE". I would like to keep the name as it is in the data table. 

proc report data=have;
column  _All_ ;
define Name / display ;
run;

[Reeza · Accepted solution]

It's likely showing the label not name. You likely changed the name but not the label somewhere. I'd back up to that step and ensure the label was also updated or explicitly specify the label you want in PROC REPORT.

[Barkat]

Thanks.
I should have tried what you suggested, before I had asked the question. 🙂

The following code worked.

proc report data=have;
column _All_ ;
define Name / display "Name" ;
run;

[PaigeMiller]

proc report data=have;
    column  _All_ ;
    define Name / display "Gorillas" ;
run;

This makes the column for variable NAME to appear with the label "Gorillas".

PS @Barkat please enclose any SAS code you might want to show us in a code box. Click on the "little running man" icon and paste your code into that box. We're trying to help you, from now on, its also necessary that you help us.

[Barkat]

Thanks so much!