Dear,
Can anyone help me to manage the data?
I have interval data. Since the data are only available at five-year intervals, I want you to fill out the in-between years as follows: between 1950 and 1955. For example, I want to set the missing values for 1951, 1952, 1953, and 1954, equal to the 1950 values. So, for example, the one of variables, LPC (Percentage of Primary Complete) for Australia would take the value of 27.15% for 1950, 1951, 1952, 1953, and 1954. The same variable LPC will take the value of 22.58% for 1955, 1956, 1957, 1958, and 1959.
So, I need to generate missing years and duplicate values.
Data looks as follows.
Many Thanks,
Can anyone help me to manage the data?
I have interval data. Since the data are only available at five-year intervals, I want you to fill out the in-between years as follows: between 1950 and 1955. For example, I want to set the missing values for 1951, 1952, 1953, and 1954, equal to the 1950 values. So, for example, the one of variables, LPC (Percentage of Primary Complete) for Australia would take the value of 27.15% for 1950, 1951, 1952, 1953, and 1954. The same variable LPC will take the value of 22.58% for 1955, 1956, 1957, 1958, and 1959.
So, I need to generate missing years and duplicate values.
Data looks as follows.
Many Thanks,
Attached Files
Comment