I have two dataset. I need to fill (or generate) the variable Priceintargetpricedate in dataset one (Target_Prices).
Dataset one (Target_Prices), with the follow variables:
CompanyId ReleaseDate TargetPrice DateTargetPrice Priceintargetpricedate
101 31/01/2014 30.00 31/12/2014
Dataset two (Prices), with the follow variables:
CompanyId Date Price
101 01/12/2014 28.00
101 02/12/2014 26.50
101 03/12/2014 27.00
.
.
.
.
101 30/12/2014 32.00
101 31/12/2014 31.50
101 02/01/2015 30.00
.
.
.
Using CompanyId and DateTargetPrice from dataset one, I want to get the price from dataset two and put this in variable Priceintargetpricedate.
Thanks!
Related Posts with Creating a variable with a data from another dataset
Calculations of quarterly stock holding data by shareholderDear Statalists, I am dealing with an unbalanced panel data for calculating the share holdings by a…
Major change in coefficient when adding a squared variable in fixed effects model. Interpretation?When I use the xtreg command with fixed effects to look at the correlation between use of marijuana …
Categorical dependent variable, how to choose the right modelI would like to Regress the likelihood that collateral are pledged on firm variables, loan contract …
Interpreting Panel data coefficient estimates where the variable doesnt change across observationsHi, I am looking at the effect of different variables on the recycling rate in England. I have 311 …
Automate file names using current dateHi All! I'm trying to create a local string reflecting the current date in the format, "YYYY-MM-DD"…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a variable with a data from another dataset
Post a Comment