topic join two tables with specific condition in SAS Programming

join two tables with specific condition

monona — Fri, 22 Feb 2019 07:12:39 GMT

Hello,

I have two tables: sample1&sample2. I would like to merge "e" column into sample1 if corresponding 'b' falls into 'c' and 'd'. Appreciate if you could you give some brief idea.

Re: join two tables with specific condition

Satish_Parida — Fri, 22 Feb 2019 07:31:37 GMT

Please let us know if it worked for you.

proc sql;
	create table result as
	select s1.a, s1.b, s2.e /*,s2.c,s2.d*/  from sample1 s1, sample2 s2
	where s1.b ge s2.c and s1.b le s2.d;
quit;