proc sql label change

[tmm]

I have this code and thou it changes the column code it does not change the label code. I can right click the table and change things but want to do it using SAS code

data table (drop = mem no yes rename=(tin = who));

set counts2;

array _col(2) no yes;

do _n_=1 to 2;

admission = vname (_col(_n_));

count = _col(_n_);

output;

end;

run;

So the tin is changed to who as the column but I want the label changed too

[art297]

What do you want to change it to?  And what does this have to do with proc sql?

[tmm]

I just typed the stuff in wrong for the header. I want the label and column to be who

I need to do it in the above data step. Boss does not want the whole right click and manually changed. everything has to be code.

[art297]

How about just assigning a null label.  e.g.:

data want;

  set sashelp.class (rename=(sex=who));

  label who=;

run;

[tmm]

what is sashelp.class? I tried the above but used my table instead of the sashelp item and it still will not change the label name of TIN to WHO.

[Tom · Accepted solution]

Since you are renaming the variable on the way out you need to use the old name of the variable in your Label statement.