Hello, I have the following data: Year Date of Forcast Forecast Value 2018 20171102 0.65 2018 20180227 0.63 2018 20180509 0.64 2018 20180730 0.66 2018 20181110 0.69 2019 20190308 0.73 2019 20190509 0.52 2019 20190806 0.49 2019 20191108 0.49         The first row, for example, states that the earning forecast for the year 2018 is 0.65 and this forecast was given on the second of August 2017. The second-row state that the forecast for the year 2018 was updated on the 27th of February 2018 to the value of 0.63. I want to write a code that will take the latest forecast value for each year as long as the "date of forecast" is not later than the 31 of March of the same year. For example for the first 5 rows (which all refer to the year 2018), the new variable (called "updated value") will be equal to 0.63. For the next 4 rows (which all refer to the year 2019) the new variable will be equal to 0.73.   Could anyone assist in writing the code? Thank you, Lior ... View more

Hello, I have variables with observations in different lengths as 000R201806, ZY201906 and I want to separate it into the letters (or digits) at the beginning of the string, the year, and the month:  000R     2018    04 ZY         2019    06   What code can I use?   Thank you, Lior ... View more

Hello,   I have the following dataset: value string -0.04 000R201406 -0.03 000R201409 0.13 000R201412 0.14 000R201503 0.02 000R201509 0.01 000R201512 0.07 000R201603 0.15 000R201606 0.13 000R201609 0.1 000R201612 0.12 000R201612 0.2 000R201703 0.08 000R201706 0.08 000R201709 0.1 000R201712 0.17 000R201803   and I want to receive the following data set:   value_2 value_1 string   -0.04 000R201406   -0.03 000R201409   0.13 000R201412   0.14 000R201503   0.02 000R201509   0.01 000R201512   0.07 000R201603   0.15 000R201606   0.13 000R201609 0.12 0.1 000R201612 0.12 0.1 000R201612   0.2 000R201703   0.08 000R201706   0.08 000R201709   0.1 000R201712   0.17 000R201803   Meaning, if there are two rows with identical  "string" the value of the first row will enter a variable called: value_1 and the value of the second row will enter a variable called: value_2. Does anyone have an idea what code to use?   Thank you, Lior ... View more