join two tables with specific condition

[monona]

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.

[Satish_Parida · Accepted solution]

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;