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
Cleaning Raw Data--How to edit non-numeric data records using commandsHello! I'm sure this has been addressed before, but I have been unable to find a forum post or yout…
Convert high frequency data to lower frequencyHi! I have a dataset with minute data (stock price) which I would like to convert into 30min data in…
fractional polynomial vs multivariable fractional polynomialHello, I am a little confused between the two concepts listed in the subject line. FP in stata can …
Collapse a variable for every percentileHi, I have a dataset of wages at the individual level. I want to collapse this dataset at every per…
test quadratic terms whether are statistically significant different in two different groupsHello, I am considering to do a test to test whether quadratic terms are statistically significant …
Subscribe to:
Post Comments (Atom)
0 Response to Creating a variable with a data from another dataset
Post a Comment