Hello
I have the following data
and
I have to fill in missing values based on 4 nearest lat and long for variable d , replace the missing value of 0 with the average of 4 nearest points please
how I can do this please
----------------------- copy starting from the next line -----------------------
------------------ copy up to and including the previous line ------------------
I have the following data
and
I have to fill in missing values based on 4 nearest lat and long for variable d , replace the missing value of 0 with the average of 4 nearest points please
how I can do this please
----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input float(latnum longnum d) int year byte month float(time coord missing)
0 0 1 2021 3 734 1 0
0 0 .22 2022 4 747 1 0
0 0 .201 2021 5 736 1 0
0 0 .535 2021 2 733 1 0
24.23531 68.578545 .358 2022 4 747 2 0
24.23531 68.578545 .24 2021 2 733 2 0
24.23531 68.578545 .264 2021 5 736 2 0
24.23531 68.578545 .346 2021 3 734 2 0
24.29183 67.68441 .354 2022 4 747 3 0
24.29183 67.68441 .606 2021 3 734 3 0
24.29183 67.68441 .315 2021 2 733 3 0
24.29183 67.68441 .472 2021 5 736 3 0
24.3051 67.62449 .484 2021 3 734 4 0
24.3051 67.62449 .531 2021 5 736 4 0
24.3051 67.62449 .398 2021 2 733 4 0
24.3051 67.62449 .449 2022 4 747 4 0
24.333544 68.25871 .346 2022 4 747 5 0
24.333544 68.25871 .339 2021 2 733 5 0
24.333544 68.25871 .358 2021 3 734 5 0
24.333544 68.25871 .362 2021 5 736 5 0
24.4073 68.0002 .346 2021 2 733 6 0
24.4073 68.0002 .472 2021 3 734 6 0
24.4073 68.0002 .461 2021 5 736 6 0
24.4073 68.0002 .425 2022 4 747 6 0
24.58326 68.84695 .508 2021 3 734 7 0
24.58326 68.84695 .61 2021 5 736 7 0
24.58326 68.84695 .433 2021 2 733 7 0
24.58326 68.84695 .476 2022 4 747 7 0
24.664936 68.82957 .461 2022 4 747 8 0
24.664936 68.82957 .437 2021 2 733 8 0
24.664936 68.82957 .417 2021 5 736 8 0
24.664936 68.82957 .5 2021 3 734 8 0
24.69325 69.24865 .441 2021 3 734 9 0
24.69325 69.24865 .354 2021 2 733 9 0
24.69325 69.24865 .386 2021 5 736 9 0
24.69325 69.24865 .433 2022 4 747 9 0
24.73327 67.94638 .205 2022 4 747 10 0
24.73327 67.94638 .248 2021 3 734 10 0
24.73327 67.94638 .177 2021 2 733 10 0
24.73327 67.94638 .394 2021 5 736 10 0
24.82097 67.0228 0 2022 4 747 11 0
24.82097 67.0228 0 2021 2 733 11 0
24.82097 67.0228 0 2021 3 734 11 0
24.82097 67.0228 0 2021 5 736 11 0
24.82809 67.13196 0 2021 2 733 12 0
24.82809 67.13196 0 2021 5 736 12 0
24.82809 67.13196 0 2021 3 734 12 0
24.82809 67.13196 0 2022 4 747 12 0
24.83239 66.999664 0 2021 3 734 13 0
24.83239 66.999664 0 2021 5 736 13 0
24.83239 66.999664 0 2021 2 733 13 0
24.83239 66.999664 0 2022 4 747 13 0
24.83339 67.016266 0 2021 2 733 14 0
24.83339 67.016266 0 2021 5 736 14 0
24.83339 67.016266 0 2022 4 747 14 0
24.83339 67.016266 0 2021 3 734 14 0
24.833817 67.16148 0 2021 3 734 15 0
24.833817 67.16148 0 2022 4 747 15 0
24.833817 67.16148 0 2021 5 736 15 0
24.833817 67.16148 0 2021 2 733 15 0
24.837254 67.01205 0 2021 5 736 16 0
24.837254 67.01205 0 2021 2 733 16 0
24.837254 67.01205 0 2021 3 734 16 0
24.837254 67.01205 0 2022 4 747 16 0
24.8378 67.1263 0 2021 5 736 17 0
24.8378 67.1263 0 2022 4 747 17 0
24.8378 67.1263 0 2021 2 733 17 0
24.8378 67.1263 0 2021 3 734 17 0
24.84752 67.1944 0 2021 5 736 18 0
24.84752 67.1944 0 2021 2 733 18 0
24.84752 67.1944 0 2022 4 747 18 0
24.84752 67.1944 0 2021 3 734 18 0
24.86844 67.388504 .268 2021 3 734 19 0
24.86844 67.388504 .508 2021 5 736 19 0
24.86844 67.388504 .236 2021 2 733 19 0
24.86844 67.388504 .374 2022 4 747 19 0
24.86852 67.05905 0 2021 3 734 20 0
24.86852 67.05905 0 2021 2 733 20 0
24.86852 67.05905 0 2021 5 736 20 0
24.86852 67.05905 0 2022 4 747 20 0
24.868704 67.00315 .327 2021 3 734 21 0
24.868704 67.00315 . 2021 5 736 21 1
24.868704 67.00315 . 2021 2 733 21 1
24.868704 67.00315 .315 2022 4 747 21 0
24.869104 66.98569 . 2021 5 736 22 1
24.869104 66.98569 .283 2022 4 747 22 0
24.869104 66.98569 . 2021 3 734 22 1
24.869104 66.98569 . 2021 2 733 22 1
24.87051 67.048805 0 2021 2 733 23 0
24.87051 67.048805 0 2021 3 734 23 0
24.87051 67.048805 0 2022 4 747 23 0
24.87051 67.048805 0 2021 5 736 23 0
24.870966 67.0646 0 2022 4 747 24 0
24.870966 67.0646 0 2021 2 733 24 0
24.870966 67.0646 0 2021 3 734 24 0
24.870966 67.0646 0 2021 5 736 24 0
24.874966 67.053955 0 2021 2 733 25 0
24.874966 67.053955 0 2022 4 747 25 0
24.874966 67.053955 0 2021 3 734 25 0
24.874966 67.053955 0 2021 5 736 25 0
end
Comment