topic How can I join 2 tables and keep the data of columns with the same name? in SAS Procedures

How can I join 2 tables and keep the data of columns with the same name?

Francisco — Mon, 24 Feb 2014 13:22:41 GMT

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:

Directa
Folios

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.

Francisco

Re: How can I join 2 tables and keep the data of columns with the same name?

Barnipaz — Mon, 24 Feb 2014 14:08:42 GMT

The answer is easy: no.

You can rename the two column in input

data final;

merge Directa Folios (rename=(Burks=folios_Burks Blartd=folios_Blartd));

by xxx;

run;

If you append you can.

Re: How can I join 2 tables and keep the data of columns with the same name?

Francisco — Tue, 25 Feb 2014 15:44:35 GMT

Hi.Thanks for the answer. I try to explain with more details:

Dataset P1

Position	Code	Class
1	AF	A
2	AG	B
3	AH	C
4	AI	D
5	AJ	E

Dataset P2

Position	Code
6	AA
7	AB
8	AC
9	AD
10	AE

And I need the new data set call P_New:

Position	Code	Class
1	AF	A
2	AG	B
3	AH	C
4	AI	D
5	AJ	E
6	AA
7	AB
8	AC
9	AD
10	AE

Thanks in advanced for your help.

Regards,

Francisco

Re: How can I join 2 tables and keep the data of columns with the same name?

Barnipaz — Tue, 25 Feb 2014 15:56:41 GMT

It's an append.

Ypu can do with a datastep

data new;

set pi_1 P_new;

run;

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.

Re: How can I join 2 tables and keep the data of columns with the same name?

overmar — Tue, 25 Feb 2014 21:08:50 GMT

Or you can just stack them

data final;

set Directa

Folios;

run;

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.