topic Re: Rename columns before append in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180015#M13739 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We can do this thing with the help of Dictionary tables along with macro.</P><P>Trying to write specific code for your query...</P><P>will be back soon.</P><P></P><P>Regards</P><P>Uma Shanker Saini</P></BODY></HTML> Thu, 20 Feb 2014 09:09:20 GMT umashankersaini 2014-02-20T09:09:20Z Rename columns before append https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180014#M13738 <HTML><HEAD></HEAD><BODY><P>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).</P><P>In the next step i split the table so i can&nbsp; 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?</P></BODY></HTML> Thu, 20 Feb 2014 08:49:23 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180014#M13738 HKlaassen 2014-02-20T08:49:23Z Re: Rename columns before append https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180015#M13739 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>We can do this thing with the help of Dictionary tables along with macro.</P><P>Trying to write specific code for your query...</P><P>will be back soon.</P><P></P><P>Regards</P><P>Uma Shanker Saini</P></BODY></HTML> Thu, 20 Feb 2014 09:09:20 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180015#M13739 umashankersaini 2014-02-20T09:09:20Z Re: Rename columns before append https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180016#M13740 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be this could help: <A href="http://www.nesug.org/proceedings/nesug07/cc/cc06.pdf" title="http://www.nesug.org/proceedings/nesug07/cc/cc06.pdf">http://www.nesug.org/proceedings/nesug07/cc/cc06.pdf</A></P><P>or</P><P><A href="http://www2.sas.com/proceedings/sugi28/118-28.pdf" title="http://www2.sas.com/proceedings/sugi28/118-28.pdf">http://www2.sas.com/proceedings/sugi28/118-28.pdf</A></P><P></P><P>Regards</P><P>Uma Shanker Saini</P></BODY></HTML> Thu, 20 Feb 2014 09:29:58 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180016#M13740 umashankersaini 2014-02-20T09:29:58Z Re: Rename columns before append https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180017#M13741 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 20 Feb 2014 18:52:27 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180017#M13741 SASKiwi 2014-02-20T18:52:27Z Re: Rename columns before append https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180018#M13742 <HTML><HEAD></HEAD><BODY><P>Perhaps you should explain what you'd like to do overall and people can suggest different methods?</P></BODY></HTML> Thu, 20 Feb 2014 20:05:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Rename-columns-before-append/m-p/180018#M13742 Reeza 2014-02-20T20:05:59Z