https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234643#M54962 In a sql merge you can apply a range on your join condition.<BR /><BR />ie a.cap between b.cap+10 and b.cap-10 Fri, 13 Nov 2015 15:53:24 GMT Reeza 2015-11-13T15:53:24Z https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234636#M54961 <P>hi, i have a sas data file (sasdata1) with firmname,<SPAN>size, and industry</SPAN><SPAN>. </SPAN>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?&nbsp;</P> Fri, 13 Nov 2015 15:27:40 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234636#M54961 aarony 2015-11-13T15:27:40Z https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234643#M54962 In a sql merge you can apply a range on your join condition.<BR /><BR />ie a.cap between b.cap+10 and b.cap-10 Fri, 13 Nov 2015 15:53:24 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234643#M54962 Reeza 2015-11-13T15:53:24Z https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234826#M54979 <P>thanks for your kind guidance!!!!</P> Mon, 16 Nov 2015 02:25:53 GMT https://communities.sas.com/t5/SAS-Procedures/how-to-match-firms-by-market-cap/m-p/234826#M54979 aarony 2015-11-16T02:25:53Z