Hi all, I'd appreciate your help.
I need to build a matrix by origin and destination of migration flows within 22 States. This is a 22x22 matrix.
I have the following variables:
- Destination: 3000 observations with 22 possible States as destination
- Origin: 3000 observations with 22 possible States as origin
- Migration: 3000 observations with population equivalent for each observation
This is:
If I want to know the total migration flow I'd total migration. If I wat to know the total migration flow to state 1, I'd total migration by destination == state 1
The following command would generate a non presentable table:
table destination origin , statistic(total migration)
However, I'd like to generate a matrix.
Thanks in advance.
I need to build a matrix by origin and destination of migration flows within 22 States. This is a 22x22 matrix.
I have the following variables:
- Destination: 3000 observations with 22 possible States as destination
- Origin: 3000 observations with 22 possible States as origin
- Migration: 3000 observations with population equivalent for each observation
This is:
If I want to know the total migration flow I'd total migration. If I wat to know the total migration flow to state 1, I'd total migration by destination == state 1
The following command would generate a non presentable table:
table destination origin , statistic(total migration)
However, I'd like to generate a matrix.
Thanks in advance.
Comment