Hi, if someone can help me with this it would be greatly appreciated. I have a data that looks like:
jan-05 feb05 ... mar09 (by month along the columns)
a
b
c
d
...
The problem is say variable a first get data at feb05 so before that it would have all zeros, all the different variables starts getting non-zeros at different time.
How do i make this to a new dataset that has:
1st.month 2nd.month ...... x.month first24monthsum
a
b
c
d
...
So I can have each variable showing the first month it has data and onwards (so no leading zeros). And also a new column at the end that shows the sum of the first24month that it has data.
Thanks!!
jan-05 feb05 ... mar09 (by month along the columns)
a
b
c
d
...
The problem is say variable a first get data at feb05 so before that it would have all zeros, all the different variables starts getting non-zeros at different time.
How do i make this to a new dataset that has:
1st.month 2nd.month ...... x.month first24monthsum
a
b
c
d
...
So I can have each variable showing the first month it has data and onwards (so no leading zeros). And also a new column at the end that shows the sum of the first24month that it has data.
Thanks!!