Dear all,
I have a data handling question which should be basic but for which I don't figure out the answer, hopefully someone else will easily.
I have a table of size 101*101, where the 100 rows/lines below the top one contain 100 origins and the 100 columns next to the 1st one contain 100 destinations. The bottom left triangle of about half the cells contain the distances, the top right triangle with the iother half are empty. As driving from B to A is just as far as driving from A to B, I'd like to replace any distance from B to A which is missing with the distance from A to B which is not missing, but I don't know how to best program this.
One idea I had was to Create 10'000 groups of 1-2 elements each such that (A,B) and (B,A) are in the same group. Then I could just use -bysort group (distance): replace distance = distance[1]- to replace the missing with the non-missing distance. But when I -egen group = group(origin destination)-, then (A,B) and (B,A) are treated as separate.
Would anyone know how to solve this?
Thank you so much, PM
I have a data handling question which should be basic but for which I don't figure out the answer, hopefully someone else will easily.
I have a table of size 101*101, where the 100 rows/lines below the top one contain 100 origins and the 100 columns next to the 1st one contain 100 destinations. The bottom left triangle of about half the cells contain the distances, the top right triangle with the iother half are empty. As driving from B to A is just as far as driving from A to B, I'd like to replace any distance from B to A which is missing with the distance from A to B which is not missing, but I don't know how to best program this.
One idea I had was to Create 10'000 groups of 1-2 elements each such that (A,B) and (B,A) are in the same group. Then I could just use -bysort group (distance): replace distance = distance[1]- to replace the missing with the non-missing distance. But when I -egen group = group(origin destination)-, then (A,B) and (B,A) are treated as separate.
Would anyone know how to solve this?
Thank you so much, PM
Comment