topic Data merge with different field names in SAS Procedures

Data merge with different field names

omega1983 — Tue, 21 May 2013 13:22:37 GMT

data trial;

merge trial1

trial2;

by ???

run;

trial1 has the field gen_id

trial2 has the field sys_id

they are an equal join but with different names. If they had the same name it would be a simple by statement. How can I join these two when they have equal value and different names?

Re: Data merge with different field names

Anotherdream — Tue, 21 May 2013 13:27:22 GMT

data trial;

merge trial1(rename=(gen_id=sys_id)) trial2;

by sys_id;

run;

Re: Data merge with different field names

Haikuo — Tue, 21 May 2013 13:29:46 GMT

Choose the "id" you want to keep and rename the other one:

data trial;

merge trial1 /*keeping gen_id*/

trial2 (rename=sys_id=gen_id);

by gen_id;

run;

Or without renaming/Sorting, use

Proc sql;

create table trail as

select * from trail1 a, trial2 b where a.gen_id=b.sys_id;

quit;

Haikuo

Re: Data merge with different field names

DBailey — Tue, 21 May 2013 14:54:24 GMT

proc sql;

create table trial as

select

from

trial1 t1

inner join trial2 t2

on t1.gen_id=t2.sys_id;

quit;