topic Merge tables in SAS Programming

Merge tables

zimcom — Sat, 14 Jul 2018 22:06:31 GMT

I have 5 table to merge all sorted by the common field SUBJECT and part of the view column looks like below

		Type	Length	format	Informat
T_1	SUBJECT	Text	8	$8	$8
T_2	SUBJECT	Text	8	$8	$8
T_3	SUBJECT	Text	8	$8	$8
T_4	SUBJECT	Number	8	BEST.
T_5	SUBJECT	Text	8	$8	$8

Then I have

proc sort data = T_1; by SUBJECT; run;

proc sort data = T_2; by SUBJECT; run;

proc sort data = T_3; by SUBJECT; run;

proc sort data = T_4; by SUBJECT; run;

proc sort data = T_5; by SUBJECT; run;

data all; merge T_1 (in=a) T_2 T_3 T_4 T_5; by SUBJECT; if a; run;

the merge was failed due to one of the SUBJECT is number, any suggestion on how to fix this? I tried to convert the numeric SUBJECT to character and renaming, in the end the merge is not working

Thank you!

zimcom

Re: Merge tables

novinosrin — Sat, 14 Jul 2018 22:44:40 GMT

Is this what you did?

proc sort data = T_1; by SUBJECT; run;

proc sort data = T_2; by SUBJECT; run;   

proc sort data = T_3; by SUBJECT; run;
/*covert to char*/
data T_4(rename=(k=subject));
set T_4;
k=put(SUBJECT,8. -l);/*assuming the values are numbers */
drop subject;
run;
proc sort data = T_4; by SUBJECT; run;

proc sort data = T_5; by SUBJECT; run;
data all; merge T_1 (in=a) T_2 T_3 T_4 T_5; by SUBJECT; if a; run;

Re: Merge tables

Reeza — Sat, 14 Jul 2018 22:43:43 GMT

@zimcom wrote:

tried to convert the numeric SUBJECT to character and renaming, in the end the merge is not working

Thank you!

zimcom

This is the correct approach so you likely did something incorrect in that step. If you post that code, we can help point out where the issues is.

Re: Merge tables

zimcom — Sat, 14 Jul 2018 22:53:25 GMT

novinosrin,

the codes works

you saved my life today!

don't know how I should thank you for all the helps you gave to me!

zimcom

Re: Merge tables

novinosrin — Sat, 14 Jul 2018 22:56:01 GMT

No biggie. I am glad. I am about to catch the train and go home and enjoy world cup football finals tomorrow croatia vs france. Keep your questions coming. It's fun to ask, find and share. Cheers

Re: Merge tables

zimcom — Sat, 14 Jul 2018 23:07:01 GMT

Thank you, you deserve a good relax Sunday and enjoy the game tomorrom

Re: Merge tables

Andygray — Sun, 15 Jul 2018 21:03:17 GMT

@zimcom You could close the thread my marking some relevant answer as accepted solution rather than leaving completely open for too long

Re: Merge tables

zimcom — Sun, 15 Jul 2018 21:08:52 GMT

Hi Andygrey,

Thank you for letting me know.

As I am still kind of new to this forum (yesterday actually is my very first day here), I will make sure to close my thread as soon as I have an answer. This forum is really helpfull.

Have a good day!