year | diff1 | diff2 |
1970 | 1 | 0.5 |
1980 | 5 | 10 |
1990 | 6 | 8 |
While I can do this manually, I do not want to hardcode 1970 values.
My code:
replace diff1 = diff1 - 1
replace diff2 = diff1 - 0.5
Is there a way through which I can do this without hardcoding 1970 values?
0 Response to Data manipulation
Post a Comment