First of all, sorry if the problem is too trivial, I have started using SPSS just very recently and am not very good at using it.
I am adding a new variable for same observations that are sorted by StockID and Year. The problem is, in the first file I have quaterly data for each StockID, while in the second file I only have end-of-year data, which results in the data merging only for the first date from that year, while I would like it to appear for every observation from the year.
Here are couple of screenshots to make it a bit clearer:
The new data:
And the final data with the above already included on the right, but not the way I wish it was:
Is there any simple way to make the last variable appear in every line?
Would really appreciate some help.