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
Related Posts with Assign (A,B) and (B,A) to the same group?
How to calculate Difference before and after treatment for panel data? [Difference in Differences]Hi everyone, I have a panel data on which I am trying to perform DID. The difficulty I am facing is…
Chow testArray regress c.Y c.time c.A c.B c.A#c.time c.B#c.time Then i manually group some obs (Named it grp…
Comparing autocorrelationsDear Stata users, I'm struggling to find a robust way to compare the autocorrelations of two earnin…
r(603)Hi, I am trying to do the impulse response function after running the varbasic model. I have slected…
_const in logistic 0?Hello everyone, I´m fitting a logistic regression model and get a constant value close to 0, is thi…
Subscribe to:
Post Comments (Atom)
0 Response to Assign (A,B) and (B,A) to the same group?
Post a Comment