Rename columns before append

[HKlaassen]

I joined a table on itself, and in the output each column name appears twice, one column is called (example; name) and the other one (example; name1, done automatic bij SAS Enterprise Guide).

In the next step i split the table so i can  place the results below eachother with a append. Is there a way to rename all collumns that end with the "1" so i can append the two tables?

[umashankersaini]

Hi,

We can do this thing with the help of Dictionary tables along with macro.

Trying to write specific code for your query...

will be back soon.

Regards

Uma Shanker Saini

[umashankersaini]

Hi,

May be this could help: http://www.nesug.org/proceedings/nesug07/cc/cc06.pdf

or

http://www2.sas.com/proceedings/sugi28/118-28.pdf

Regards

Uma Shanker Saini

[SASKiwi]

If you are wanting to append a table onto itself why don't you use the EG Append Table task? If you do that you can avoid the joining rename issue.

[Reeza]

Perhaps you should explain what you'd like to do overall and people can suggest different methods?