topic Re: Proc report provides column name, "NAME OF FORMER VARIABLE" in New SAS User

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

Barkat — Wed, 15 Dec 2021 17:26:40 GMT

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;

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

Reeza — Wed, 15 Dec 2021 17:31:05 GMT

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.

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

PaigeMiller — Wed, 15 Dec 2021 17:37:11 GMT

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.

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

Barkat — Wed, 15 Dec 2021 17:38:04 GMT

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;

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

Barkat — Wed, 15 Dec 2021 17:38:58 GMT

Thanks so much!