Dear all,
I come to you as I face a problem that sounds easy but I have stuck for good. I have two datasets to which I have a variable of a unique ID number to each (e.g. link, pair). I want to tell Stata to search if each ID number of the one variable (e.g. link) is present on the other variable (pair) and generate a dummy as an indicator.
I have searched on the Internet and tried several ways but with no success.
The last thing that maybe is important to know is that the datasets are large (191,000 and 26,000,000 obs).
Any ideas would be highly appreciated.
Thank you in advance.
Related Posts with Vlookup style function of variable from other dataset
Questions on Differece-in-Differences and Triple DifferencesHi Statalist. This may be a long one. I am assessing the effects of a change in state legislation o…
Cumulative percentage of LossHi, I have the following panel data (gvkey fyear). Loss is a dummy variable that equals 1 if ib <…
Questions on portfolio analysisDear all, I am having trouble in replicating a paper which involves the following procedures: "1. …
stset for time series data - incorrect person timeI have time series data with daily dates for each id, I have tried to stset my data using: Code: …
How to merge 10 datasets and loop through them?Hi, I have ten datasets in a folder named "Bond Data" and I am trying to run through the same code f…
Subscribe to:
Post Comments (Atom)
0 Response to Vlookup style function of variable from other dataset
Post a Comment