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
Help in programming: Running or replicating a matlab scriptHi, I am using Stata 16 and would need some help in programming. I have a matlab script and would n…
Average Real Variability (ARV) and Variability Independent of Mean Blood PressureHi everyone, I'm Med Student and new using STATA. Currently, For a systolic blood pressure visit to…
Parallel lines assumption of ordered logit regressions with multiply imputed dataDear all, I am working with an imputed data set (M=50, N=1359) and use an ordered logisitc regressi…
Phi coefficient and Point Bi-Serial*How to calculate the Phi coefficient and Point Bi-Serial for a complex sample after creating a surve…
Replace value from different row condtionsHello everyone I have a dataset with observations that have been matched, and I have a sample weight…
Subscribe to:
Post Comments (Atom)
0 Response to Creating a variable with a data from another dataset
Post a Comment