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?
Asdoc not applying weights in pwcorrI've been using asdoc to create a word document. I have several frequency and correlation tables tha…
Datepart/ClockpartHi everyone In my dataset I have a time variable. It is in format: %tcDay_Mon_DD_HH:MM:SS_CCYY (this…
count the number of string variableI was wondering if there exists a function or command that counts the number of string variables in …
Graphing InteractionsHi all, We are wondering how to graph a 3-way interaction on stata? It is a continuous x continuous…
Bootstrapping produces coef onlyHello, I am trying to use bootstrapping to get a 95% CI for Cohen's d, but the command produces coe…
Subscribe to:
Post Comments (Atom)
0 Response to Assign (A,B) and (B,A) to the same group?
Post a Comment