topic Re: rename column in data step in SAS Procedures

rename column in data step

tmm — Wed, 14 Mar 2012 20:56:50 GMT

data chi (drop = no yes rename=tin=who);

set tax;

array _col(2) no yes;

do _n_=1 to 2;

admission = vname (_col(_n_));

count = _col(_n_);

output;

end;

run;

It does not change my column named tin to name it who instead. everything else works great.

rename column in data step

Hima — Wed, 14 Mar 2012 21:07:08 GMT

data chi (drop = yes no RENAME=(TIN=WHO));

set tax;

array _col(2) no yes;

do _n_=1 to 2;

admission = vname (_col(_n_));

count = _col(_n_);

output;

end;

run;

rename column in data step

tmm — Wed, 14 Mar 2012 21:31:57 GMT

Hum. That did not work. It is still named TIN

rename column in data step

Reeza — Wed, 14 Mar 2012 22:14:02 GMT

You might still see the name 'tin' because the label assigned to the variable 'who' is 'tin'.

try the following with all labels removed. Or just right click the variable and check the properties.

data chi (drop = yes no RENAME=(TIN=WHO));

set tax;

attrib _all_ label='';

array _col(2) no yes;

do _n_=1 to 2;

admission = vname (_col(_n_));

count = _col(_n_);

output;

end;

run;

rename column in data step

Haikuo — Wed, 14 Mar 2012 22:22:16 GMT

When you just have one variable to rename, parenthesis is not must to have, your original code should work.

My guess is that the variable name has already been changed, however, the label is still 'tin'. When you open in explorer, it still shows the original label name. Find out the answer by double click the variable name or use proc print, proc contents.

Regards,

Haikuo

rename column in data step

art297 — Wed, 14 Mar 2012 22:54:07 GMT

Haikuo: A second thing I learned this week! And it is only Wednesday! I'm still going to use parentheses in my own recode statements, as I know it will ALWAYS work regardless of the number of variables being recoded, but I never knew that you didn't need them for just one recode.

rename column in data step

Haikuo — Wed, 14 Mar 2012 23:28:35 GMT

Art, if I have to count how many SAS stuff that I have learned directly from you, I would need a counter that at least supports 3 digits. :smileysilly:. BTW, what was the first thing if you don't mind sharing?

Haikuo

rename column in data step

art297 — Wed, 14 Mar 2012 23:57:13 GMT

Haikuo: Howard's use of imbedding _numeric_ and _character_ in variable lists. e.g.:

proc print data=sashelp.class;

var name-numeric-weight;

run;

Hey, I've been trying to learn this language for 38 years now and, almost every week, still learn something I didn't know.

Re: rename column in data step

Haikuo — Thu, 15 Mar 2012 22:46:50 GMT

Thanks, Art! And Howard! This is so COOL!

Re: rename column in data step

Reeza — Thu, 15 Mar 2012 23:13:37 GMT

Am I missing something or do the following produce the exact same output?

What was the first one supposed to do?

proc print data=sashelp.class;

var name-numeric-weight;

run;

proc print data=sashelp.class;

var _numeric_;

run;

Re: rename column in data step

art297 — Thu, 15 Mar 2012 23:53:37 GMT

Fareeza, My fault! I unsuccessfully tried to copy and paste from a previous post. Try the following:

proc print data=sashelp.class;

var name _numeric_;

run;

proc print data=sashelp.class;

var _numeric_;

run;

Re: rename column in data step

Reeza — Fri, 16 Mar 2012 00:02:04 GMT

That makes way more sense! Thanks

Re: rename column in data step

Linlin — Fri, 16 Mar 2012 01:12:53 GMT

Hi Art,

I thought you wanted to show how to print all numeric or character variables between two variables. In the example below, the two outputs are different. Thanks -Linlin

data class;

set sashelp.class;

age2=age;

w2=weight;

proc print data=class;

title print out all numeric variables;

var _numeric_;

run;

proc print data=class;

title print out all numeric variables between name and weight;

var name-numeric-weight;

run;