topic proc sql label change in SAS Procedures

proc sql label change

tmm — Mon, 19 Mar 2012 20:03:05 GMT

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

proc sql label change

art297 — Mon, 19 Mar 2012 20:13:48 GMT

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

proc sql label change

tmm — Mon, 19 Mar 2012 20:18:19 GMT

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.

proc sql label change

art297 — Mon, 19 Mar 2012 20:21:38 GMT

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

data want;

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

label who=;

run;

proc sql label change

tmm — Mon, 19 Mar 2012 21:41:09 GMT

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.

proc sql label change

Tom — Mon, 19 Mar 2012 21:47:55 GMT

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