Hello, I am trying to count observations which have the same value for some variable but different ID.
For example,
Airline Origin Destination
AA ORD LAX
UA ORD LAX
AA IAD LAX
UA IAD LAX
I am trying to figure out the multimarket contact of two airlines(AA and UA). I want count the route where both AA and UA operate nonstop flight.
So in the example data, AA and UA operate in the 2 markets.
Please help me to figure out the command for this work. Thank you for your time and attention.