02-24-2014 08:22 AM
Hello. I've a little problem. How can I join 2 tables and keep the data of columns with the same name? The data of 2 tables is different, and i need make a new table with the result.
The name of tables are:
And the same columns of both tables are called "Burks" and "Blartd". The output must be create a new table, with the name "Final".
Thanks in advanced.
02-24-2014 09:08 AM
The answer is easy: no.
You can rename the two column in input
merge Directa Folios (rename=(Burks=folios_Burks Blartd=folios_Blartd));
If you append you can.
02-25-2014 10:44 AM
Hi.Thanks for the answer. I try to explain with more details:
And I need the new data set call P_New:
Thanks in advanced for your help.
02-25-2014 10:56 AM
It's an append.
Ypu can do with a datastep
set pi_1 P_new;
Or with the proc append.
Proc append base=P_1 data=P_new force; run;
The code is written by memory so some error could be in it. Test it and change it.
02-25-2014 04:08 PM
Or you can just stack them
As long as they are in the same positions, ie the data that you had presented earlier this will just stack the two of them on top of each other.