Hi,
I have two samples. Sample 1 (main sample) includes 200 companies from Sweden. Sample 2 includes 5000 companies from the US. Using sample 2, I want to find one match company for each company includes in sample 1. I want to find my match sample based on sic code (company industry identity), assets (company's assets value), ROA and audit fees.
All the companies are identified by a specific identity number, ISIN number. Both samples show the variables: sic code, year, assets, ROA and audit fees.
I would be grateful if one could help me that how can I find the match based on the several variables or criteria.
Note:
I am using mac and Stata 15.
Best regards,
Mahmoud
Related Posts with Matching sample based on multiple variables
Summing or combining duplicate observationsHello all, I would like to ask how to combine/sum up data from duplicate observations. In the below…
reformat (destring) var questionHi Hi, I am relatively new to stata and want to reformat a variable. the var is named p3_start_TS, …
Two-Stage Least Squares with cross-section weights and adjusted-R2Hi! I am currently analysing daily yield spreads of the euro-area countries over a 10-year period. I…
Help on Threshold regressioGood afternoon to you all My name is David and am new to Stata. My problem is that i want to use Sta…
Double Sorting quantilesHello, I have got the following problem: I am trying to sort my variable into five quintiles and wit…
Subscribe to:
Post Comments (Atom)
0 Response to Matching sample based on multiple variables
Post a Comment