Hello,
I am trying to allocate an observation which is recorded at the last day of a month to a dataset which contains daily observations in a way such that the observation which is recorded at 29jan1993 is allocated to all daily observations I have in jan1993 in my second dataset.
My monthly dataset as well as my daily dataset range both from January 1993 to December 2014.
The second dataset contains different stocks, therefore each date is listed several times in the second dataset.
The monthly dataset looks like this:
date Sentiment
29jan1993 0,72
26feb1993 0,83
31mar1993 -0,88
...
31dec2014. 0,01
The daily dataset looks like this:
date var1 var2 var3 var4
04jan1993
04jan1993
04jan1993
04jan1993
04jan1993
05jan1993
05jan1993
05jan1993
05jan1993
05jan1993
...
31dec2014
31dec2014
31dec2014
31dec2014
31dec2014
My question how it is possible to transfer the observations from one dataset to another and how to allocate the one observation per month in the first dataset to all daily observations I have during a month in the second dataset.
Thank you very much!
Related Posts with Allocating monthly observation to daily data
Logistic and predict OR for a specific value of the IVHi listers, I am looking to see whether emotional well-being scores (continuous) are predictors of …
Calculating the difference between maximum and minimum variable value over three overlapping yearsDear sata experts, I have a panel data set ranging from 2010-2018 for all firms listed i the US mar…
Interpolation Quarterly to Monthly ; Missing dates when generating themDear Members of this forum, I find an anomaly while generating monthly data. At the second step of …
How to manually calculate standard errors for instrumental variables?Hi I am working on statistical inference with instrumental variables (IV) following Wooldridge (201…
Optimal Matching vs Propensity Score MatchingHello Everyone! I am new to STATA and I am trying to run sample matching. Recently a friend of mine …
Subscribe to:
Post Comments (Atom)
0 Response to Allocating monthly observation to daily data
Post a Comment