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!