BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

Merging two data sets using joinby but with capitol and lower case differences
Merging two data sets using joinby but with capitol and lower case differences

Dear Statalisters,

I need some help because I am trying to merge two databases using

Code:

joinby firms

, but I have a problem because in one database the names of the firms are in capital letters and the second database the firms names are in low case letters (actually only the first letter is in capital letter".

My question for you is if are there any way to do the merge without changing the names of each firm one by one since I have 3800 different firms?

Hope to be clear with my question.
Best regards,

Alejandro

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Merging two data sets using joinby but with capitol and lower case differences
Merging two data sets using joinby but with capitol and lower case differences

0 Response to Merging two data sets using joinby but with capitol and lower case differences

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Merging two data sets using joinby but with capitol and lower case differences Merging two data sets using joinby but with capitol and lower case differences

0 Response to Merging two data sets using joinby but with capitol and lower case differences