Technological gaps (across regions)

[Hugo Rocha]

Dear all,

I have a particular question regarding syntax. I have sectoral data that I divided by different regions and also categorized industries by technologies (tech_intensity). If I want to get ratio of value added per worker by technological intensities by region. What would be the appropriate syntax? For instance, I want to obtain the ratio (r_val_worker) if technological intensity is 3 and region is 1 over (r_val_worker) if technological intensity is 3 and region is 3.

Thank you!

 * Example generated by -dataex-. To install: ssc install dataex
clear
input float(region tech_intensity) int year float r_valworker
1 1 1963  30675.38
1 2 1963  39635.16
1 3 1963 35247.273
2 1 1963 16038.007
2 2 1963 18873.287
2 3 1963 10885.398
3 1 1963 8968.7705
3 2 1963 12684.422
3 3 1963  6166.321
4 1 1963 13197.479
4 2 1963 17796.705
4 3 1963  10183.67
5 1 1963   9075.85
5 2 1963 10774.854
5 3 1963  6512.195
6 1 1963 4067.8264
6 2 1963  6239.126
6 3 1963  3085.248
7 1 1963  9019.552
7 2 1963 17224.043
7 3 1963  8890.454
1 1 1964 32025.865
1 2 1964  41858.67
1 3 1964 37362.668
2 1 1964 15625.635
2 2 1964 18768.445
2 3 1964   9397.57
3 1 1964  7427.771
3 2 1964  14511.18
3 3 1964  6287.877
4 1 1964 14393.644
4 2 1964  19647.38
4 3 1964 11037.786
5 1 1964  8505.627
5 2 1964 10474.984
5 3 1964  7119.239
6 1 1964 4232.3423
6 2 1964  6996.236
6 3 1964 3732.1416
7 1 1964  9298.948
7 2 1964 16923.238
7 3 1964  9064.379
1 1 1965 33074.063
1 2 1965  43372.59
1 3 1965  38590.49
2 1 1965 17023.662
2 2 1965 21874.145
2 3 1965  9824.057
3 1 1965  7076.673
3 2 1965  14429.22
3 3 1965   6272.86
4 1 1965 15181.593
4 2 1965 21277.816
4 3 1965  11669.62
5 1 1965  9009.432
5 2 1965 11424.972
5 3 1965  7756.138
6 1 1965 4121.0435
6 2 1965  7841.048
6 3 1965  3723.274
7 1 1965 10329.247
7 2 1965 19562.154
7 3 1965  9593.438
1 1 1966 34037.656
1 2 1966  44374.52
1 3 1966 38802.805
2 1 1966 16937.217
2 2 1966  22864.32
2 3 1966 10505.517
3 1 1966  8076.685
3 2 1966  27304.95
3 3 1966  8095.475
4 1 1966 15309.466
4 2 1966  22210.17
4 3 1966 11821.714
5 1 1966  9792.088
5 2 1966 11206.152
5 3 1966  7966.529
6 1 1966  5588.635
6 2 1966  8041.984
6 3 1966  3999.882
7 1 1966 10482.725
7 2 1966 20330.396
7 3 1966 10325.595
1 1 1967  35256.94
1 2 1967  46489.36
1 3 1967  39913.55
2 1 1967 18357.732
2 2 1967  26671.02
2 3 1967 11880.262
3 1 1967  7610.016
3 2 1967 23470.797
3 3 1967  7314.925
4 1 1967  16336.18
4 2 1967  26697.08
4 3 1967 12838.613
5 1 1967 10627.783
5 2 1967  20032.85
5 3 1967  8229.644
6 1 1967  5693.469
end