Hello, I am a new member to this forum! Nice to meet you all.
I have just went through set of posts regarding rangejoin, but I could not apply it to my own data project, and all helps would be very grateful!
So, I have two data sets where
use dataSet1
PERMNO FIRSTDATE LASTDATE
25881 19701113 19780630
10015 19830920 19860731
10023 19721214 19730605
and
use dataSet2
PERMNO TargetDate
25881 19701220
10015 19840305
10023 19721216
and on.
so, using dataset 1, I ran the following code
(Both my FirstDate and LastDate are in long format)
rangejoin NamesDate FirstDate LastDate using dataSet2.dta, by (PERMNO)
but I am getting
no observation with valid interval bounds to use as my error message. Would anyone be willing to help me out? Thank you all.
Related Posts with Doing Merge using rangejoin
Testing for Equality of Coefficients with Dynamic Panel DataHello! I have conducted a systems-GMM analysis aiming to determine whether a relationship exists be…
[Epidemiologic study] Creating a parametre based on a set a criteriaHi! in short: - What is the best way to look at prevalence in a dataset utilizing a questionaire an…
Saving, combining and exporting stphplot graphs to PDFHello, I'm new to Stata. I'm working on a Cox regression analysis (also new to this) on quite a lar…
Combining variables in wide format into one variable in a long datasetHi. I'd very much appreciate help with the following: I have data in long form which comprises a dru…
OLS, areg , xtreg, fixed effect and randomHello everyone, I'm doing a stata project with the seatbelts dataset with all the 51 US States. This…
Subscribe to:
Post Comments (Atom)
0 Response to Doing Merge using rangejoin
Post a Comment