how to match firms by market cap

[aarony]

hi, i have a sas data file (sasdata1) with firmname,size, and industry. i have another sas data file (sasdata2) with firm name, size, and industry. i wanted to match firms in sasdata1 with sasdata2 in terms of size and industry. the issue is that the size is not identical and i wanted to give it a bandwith. how may i identify firms in sas and match the two files? 

[Reeza · Accepted solution]

In a sql merge you can apply a range on your join condition.

ie a.cap between b.cap+10 and b.cap-10

[aarony]

thanks for your kind guidance!!!!