operation series different size
Posted: Wed Aug 09, 2017 3:44 am
Hi there, I hope you are keeping well. I am sorry to bother you but really need help with this due to is the last part of my dissertation.
I need to create a new serie "z" which is the difference between "x" and "y" series. However, the series "x" and "y" have different size. "x" from observation 1 to observation 5222, but really it contains values from 1 to 504 (from 505 ahead, NA). On the other hand, "y" has observations from 23 to 5222 (between 1 and 22, NA). So, my problem is that I need to create a serie "z" taking the difference of 504 observations between "x" and "y" but considering that this 504 observation must be the last 504 observations of "y" (from 4719 to 5222=504). So far, I have created "z" with wrong values. I have tried to do the following in order to capture only the relevant observation of the serie "y" but is not working:
y.sheet
smpl 4719 5222
series z=x-y
Please find attached the files. Really I need your support.
all the best
MS
I need to create a new serie "z" which is the difference between "x" and "y" series. However, the series "x" and "y" have different size. "x" from observation 1 to observation 5222, but really it contains values from 1 to 504 (from 505 ahead, NA). On the other hand, "y" has observations from 23 to 5222 (between 1 and 22, NA). So, my problem is that I need to create a serie "z" taking the difference of 504 observations between "x" and "y" but considering that this 504 observation must be the last 504 observations of "y" (from 4719 to 5222=504). So far, I have created "z" with wrong values. I have tried to do the following in order to capture only the relevant observation of the serie "y" but is not working:
y.sheet
smpl 4719 5222
series z=x-y
Please find attached the files. Really I need your support.
all the best
MS