cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
FA1
‎01-18-2018
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Merging two databases with two common variables, one of common var...

by Calcite | Level 5 in SAS Data Management
‎01-17-2018 11:27 PM
‎01-17-2018 11:27 PM
Dear KurBremser                     Thank you so Much. Yes, SAS Data Quality Server is the best option for me to solve this problem. Actually there are two ways to overcome this problem 1)Scoring method, 2) Fuzzy matching using SAS Data Quality Server. I have attached a pdf that explains these two ways very well. It was very helpful for me.    Kind regards, FA1 ... View more

Merging two databases with two common variables, one of common variabl...

by Calcite | Level 5 in SAS Data Management
‎01-09-2018 01:51 AM
‎01-09-2018 01:51 AM
Hello, I want two merge two databases:1) KLD, 2)Compustat They have two common variables: 1)Year and 2)Company Name.  Because my data are panel data I have to use both common variables to merge.  However, company name is not exactly similar in two databases (they may different in terms of  capital letters, abbreviations, spelling errors, etc.) Could you please let me know the coding of how merging these two databases. I am not familiar with SAS, but I have found out SAS can solve this problem.  If somebody give me the whole codes for this purpose, I would be very thankful.   Kind regards, FA1    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-18-2018 12:00 AM
Quick links