Help using Base SAS procedures

how to match firms by market cap

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 102
Accepted Solution

how to match firms by market cap

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? 


Accepted Solutions
Solution
‎11-15-2015 09:25 PM
Super User
Posts: 19,817

Re: how to match firms by market cap

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

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

View solution in original post


All Replies
Solution
‎11-15-2015 09:25 PM
Super User
Posts: 19,817

Re: how to match firms by market cap

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

ie a.cap between b.cap+10 and b.cap-10
Frequent Contributor
Posts: 102

Re: how to match firms by market cap

thanks for your kind guidance!!!!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 280 views
  • 2 likes
  • 2 in conversation