merge by company name

93 views
Skip to first unread message

J C

unread,
Jul 27, 2020, 9:46:03 AM7/27/20
to wrdssas
Hello everyone

I am trying to merge a dataset with Compustat/CRSP by company name because the dataset has no common identifier. 

Could someone let me know what would be the most efficient and least error prone way to do this?

Any advice is highly appreciated!

Best,
J C

EVANS BOAMAH

unread,
Jul 28, 2020, 2:01:35 PM7/28/20
to J C, wrdssas
Try using a name match. Download the fuzzy excel adds in and use excel 

--
Forum home on www.wrds.us - http://www.wrds.us/index.php/forum_wrds/
 
All posts are moderated.
---
You received this message because you are subscribed to the Google Groups "wrdssas" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wrdssas+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/wrdssas/dcb427f4-cb41-434a-aa95-4cbadad41d25o%40googlegroups.com.
--
Best Regards

Boamah Evans Ofosu
Box 10473 Accra-North
+233 541 921 727
Reply all
Reply to author
Forward
0 new messages