Subscribe Bookmark RSS Feed

Renaming a column

asvp

Community Trekker

Joined:

Jun 23, 2011

I am trying to rename a column using the following script but it does not work, can anyone tell me what is wrong with this script? are there better ways to rename columns?

col2 = Column(2);
col2 = Set Name ("XYZ");

Thanks.
3 REPLIES
pmroz

Super User

Joined:

Jun 23, 2011

You're close. Try this instead:


col2 = Column(2);
col2 << Set Name ("XYZ");
asvp

Community Trekker

Joined:

Jun 23, 2011

Thanks....that works.
jorgeramosdealm

Community Trekker

Joined:

Feb 20, 2012

You can also use munger to change part of the name of a column. This is useful after "tabulate" or "summary" specially if you iterate through the different variables.

eg one variable

column(data_table,2)<<set name(munger(munger(eval(char(column(data_table,2))),1,"Column(\!"text_that_you_want_to_change ",""),1,")\!")",""));

eg all variables

for(i=1,i<=n col(data_table),i++,

column(data_table,i)<<set name(munger(munger(eval(char(column(data_table,i))),1,"Column(\!"text_that_you_want_to_change ",""),1,")\!")","")));