Hi there,
I am looking to make some graphs of the evolution of export volumes in various regions of South Africa over time. I have transaction level data of all exports within a particular period in South Africa with variables including the province (region) the product exited the country, the time (month and year), the value and the product classification (hs6 code). My raw data looks as follows:
CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str19 province float t long hs6_code double v
"Western Cape" 684 493 25853.615234375
"Western Cape" 684 516 802.1882934570313
"Western Cape" 684 560 7379.763671875
"Western Cape" 684 572 1229.825439453125
"Western Cape" 684 824 1633.1315307617187
"Western Cape" 684 945 47.77739334106445
"Western Cape" 684 957 49.98930740356445
"Western Cape" 684 1172 115.01964569091797
"Western Cape" 684 1224 1051.7662353515625
"Western Cape" 684 1279 71.73982238769531
"Western Cape" 684 1362 7.8891682624816895
"Western Cape" 684 1459 720.716064453125
"Western Cape" 684 1460 5142.70556640625
"Western Cape" 684 1464 88051.2265625
"Western Cape" 684 1465 902.9779663085938
"Western Cape" 684 1468 217.57884216308594
"Western Cape" 684 1469 6633.31591796875
"Western Cape" 684 1470 216.17796325683594
"Western Cape" 684 1542 2145.558837890625
"Western Cape" 684 1663 63.776920318603516
"Western Cape" 684 1682 153.65444946289062
"Western Cape" 684 1686 326.6263122558594
"Western Cape" 684 1688 481.38671875
"Western Cape" 684 1701 1863.24462890625
"Western Cape" 684 1718 227.09007263183594
"Western Cape" 684 2174 285.41094970703125
"Western Cape" 684 2433 154.17056274414062
"Western Cape" 684 2496 81.25106048583984
"Western Cape" 684 2517 509.9941711425781
"Western Cape" 684 2845 66.57868194580078
"Western Cape" 684 2854 606.4337158203125
"Western Cape" 684 2900 3254.46630859375
"Western Cape" 684 2932 285.48468017578125
"Western Cape" 684 3015 146.65005493164062
"Western Cape" 684 3028 844.3621826171875
"Western Cape" 684 3032 132.05140686035156
"Western Cape" 684 3126 4493.9501953125
"Western Cape" 684 3132 7738.16796875
"Western Cape" 684 3156 35.16946792602539
"Western Cape" 684 3195 827.1092529296875
"Western Cape" 684 3208 23532.578125
"Western Cape" 684 3220 35.31692886352539
"Western Cape" 684 3248 50012.609375
"Western Cape" 684 3255 500.4829406738281
"Western Cape" 684 3259 5929.410217285156
"Western Cape" 684 3299 260.4900207519531
"Western Cape" 684 3311 538.2329711914063
"Western Cape" 684 3374 780.8801879882813
"Western Cape" 684 3429 3218.70703125
"Western Cape" 684 3430 3553.5909423828125
"Western Cape" 684 3557 6740.888671875
"Western Cape" 684 3558 663.8698120117188
"Western Cape" 684 3598 2676.787353515625
"Western Cape" 684 3602 127670.2587890625
"Western Cape" 684 3603 22828.303466796875
"Western Cape" 684 3729 4714.9208984375
"Western Cape" 684 3750 3770.65380859375
"Western Cape" 684 3777 97.0293960571289
"Western Cape" 684 3779 101.52696228027344
"Western Cape" 684 3780 916.6918334960938
"Western Cape" 684 3782 229.96556091308594
"Western Cape" 684 3822 524.1504516601563
"Western Cape" 684 3824 1912.34912109375
"Western Cape" 684 3955 13969.2841796875
"Western Cape" 684 3969 449.8300476074219
"Western Cape" 684 3971 2259.988525390625
"Western Cape" 684 4020 3887.369140625
"Western Cape" 684 4048 6245.56689453125
"Western Cape" 684 4049 4394.93017578125
"Western Cape" 684 4075 14501.0283203125
"Western Cape" 684 4184 1282.8377685546875
"Western Cape" 684 2430 72878.36605834961
"Western Cape" 684 479 420.26409912109375
"Western Cape" 684 564 103.22276306152344
"Western Cape" 684 1172 3.6865272521972656
"Western Cape" 684 1235 38.413612365722656
"Western Cape" 684 1236 8047.09912109375
"Western Cape" 684 1247 8801.3623046875
"Western Cape" 684 1253 3805.60205078125
"Western Cape" 684 1350 663.5748901367188
"Western Cape" 684 1362 566.4718017578125
"Western Cape" 684 1446 .7373054623603821
"Western Cape" 684 1563 47.92485427856445
"Western Cape" 684 1564 78.1543779373169
"Western Cape" 684 1565 98.8726577758789
"Western Cape" 684 1577 109.12120819091797
"Western Cape" 684 1705 195.3859405517578
"Western Cape" 684 1714 3291.84765625
"Western Cape" 684 2171 2348.0966796875
"Western Cape" 684 2273 7397.6806640625
"Western Cape" 684 2287 871.2001342773438
"Western Cape" 684 2302 995.3623657226563
"Western Cape" 684 2371 387.0853576660156
"Western Cape" 684 2428 13428.2490234375
"Western Cape" 684 2855 169.0641326904297
"Western Cape" 684 3024 11.059581756591797
"Western Cape" 684 3104 897.2269897460938
"Western Cape" 684 3173 123.13001251220703
"Western Cape" 684 3259 99797.90430641174
"Western Cape" 684 3405 61.933658599853516
end
format %tm t
label values hs6_code hs6_code
label def hs6_code 479 "170490", modify
label def hs6_code 493 "190190", modify
label def hs6_code 516 "200520", modify
label def hs6_code 560 "210390", modify
label def hs6_code 564 "210610", modify
label def hs6_code 572 "220421", modify
label def hs6_code 824 "282590", modify
label def hs6_code 945 "290511", modify
label def hs6_code 957 "290541", modify
label def hs6_code 1172 "300691", modify
label def hs6_code 1224 "320890", modify
label def hs6_code 1235 "321511", modify
label def hs6_code 1236 "321519", modify
label def hs6_code 1247 "330290", modify
label def hs6_code 1253 "330499", modify
label def hs6_code 1279 "340399", modify
label def hs6_code 1350 "380993", modify
label def hs6_code 1362 "381400", modify
label def hs6_code 1446 "391710", modify
label def hs6_code 1459 "391990", modify
label def hs6_code 1460 "392190", modify
label def hs6_code 1464 "392321", modify
label def hs6_code 1465 "392329", modify
label def hs6_code 1468 "392350", modify
label def hs6_code 1469 "392390", modify
label def hs6_code 1470 "392410", modify
label def hs6_code 1542 "401691", modify
label def hs6_code 1563 "420219", modify
label def hs6_code 1564 "420221", modify
label def hs6_code 1565 "420222", modify
label def hs6_code 1577 "420340", modify
label def hs6_code 1663 "480100", modify
label def hs6_code 1682 "481830", modify
label def hs6_code 1686 "481920", modify
label def hs6_code 1688 "481940", modify
label def hs6_code 1701 "482360", modify
label def hs6_code 1705 "490199", modify
label def hs6_code 1714 "490810", modify
label def hs6_code 1718 "491110", modify
label def hs6_code 2171 "590700", modify
label def hs6_code 2174 "591000", modify
label def hs6_code 2273 "611420", modify
label def hs6_code 2287 "620119", modify
label def hs6_code 2302 "620319", modify
label def hs6_code 2371 "621143", modify
label def hs6_code 2428 "630621", modify
label def hs6_code 2430 "630630", modify
label def hs6_code 2433 "630710", modify
label def hs6_code 2496 "680422", modify
label def hs6_code 2517 "681310", modify
label def hs6_code 2845 "730640", modify
label def hs6_code 2854 "730729", modify
label def hs6_code 2855 "730791", modify
label def hs6_code 2900 "731822", modify
label def hs6_code 2932 "732620", modify
label def hs6_code 3015 "760719", modify
label def hs6_code 3024 "761290", modify
label def hs6_code 3028 "761510", modify
label def hs6_code 3032 "761699", modify
label def hs6_code 3104 "820411", modify
label def hs6_code 3126 "820790", modify
label def hs6_code 3132 "820900", modify
label def hs6_code 3156 "830160", modify
label def hs6_code 3173 "830629", modify
label def hs6_code 3195 "840290", modify
label def hs6_code 3208 "840721", modify
label def hs6_code 3220 "840999", modify
label def hs6_code 3248 "841381", modify
label def hs6_code 3255 "841440", modify
label def hs6_code 3259 "841480", modify
label def hs6_code 3299 "842123", modify
label def hs6_code 3311 "842382", modify
label def hs6_code 3374 "843319", modify
label def hs6_code 3405 "843890", modify
label def hs6_code 3429 "844331", modify
label def hs6_code 3430 "844360", modify
label def hs6_code 3557 "847110", modify
label def hs6_code 3558 "847170", modify
label def hs6_code 3598 "848110", modify
label def hs6_code 3602 "848180", modify
label def hs6_code 3603 "848190", modify
label def hs6_code 3729 "852530", modify
label def hs6_code 3750 "853180", modify
label def hs6_code 3777 "853630", modify
label def hs6_code 3779 "853649", modify
label def hs6_code 3780 "853650", modify
label def hs6_code 3782 "853669", modify
label def hs6_code 3822 "854420", modify
label def hs6_code 3824 "854441", modify
label def hs6_code 3955 "890710", modify
label def hs6_code 3969 "900319", modify
label def hs6_code 3971 "900410", modify
label def hs6_code 4020 "901890", modify
label def hs6_code 4048 "902610", modify
label def hs6_code 4049 "902620", modify
label def hs6_code 4075 "903180", modify
label def hs6_code 4184 "940380", modify
[/CODE]
So far, I have used the province (region), time (monthly) and product code (hs6 code) variables to collapse the data to allow me to make a graph of the evolution of aggregate export volume changes across different provinces by collapsing the data as follows:
collapse (count) ExportVolume = hs6_code (sum) ExportValue = v, by(province t)
Now, I am looking to calculate the growth rate of the volume of exports WITHIN each province/region, but am unsure how to do this correctly. I tried, using data as collapsed above, to do:
egen id = group(province t)
tsset id t, m
gen growth = ((ExportVolume - l.ExportVolume)/l.ExportVolume) * 100
This just yielded missing values within the growth variable for each observation. Essentially what I want to know is how to calculate the growth rates within each province, so that I can use the twoway command to construct a line graph of the evolution of the growth rate in export volumes of different provinces across time. I am using Stata 15 on Windows 11.
Any help would be appreciated. Thank you!
I am looking to make some graphs of the evolution of export volumes in various regions of South Africa over time. I have transaction level data of all exports within a particular period in South Africa with variables including the province (region) the product exited the country, the time (month and year), the value and the product classification (hs6 code). My raw data looks as follows:
CODE]
* Example generated by -dataex-. To install: ssc install dataex
clear
input str19 province float t long hs6_code double v
"Western Cape" 684 493 25853.615234375
"Western Cape" 684 516 802.1882934570313
"Western Cape" 684 560 7379.763671875
"Western Cape" 684 572 1229.825439453125
"Western Cape" 684 824 1633.1315307617187
"Western Cape" 684 945 47.77739334106445
"Western Cape" 684 957 49.98930740356445
"Western Cape" 684 1172 115.01964569091797
"Western Cape" 684 1224 1051.7662353515625
"Western Cape" 684 1279 71.73982238769531
"Western Cape" 684 1362 7.8891682624816895
"Western Cape" 684 1459 720.716064453125
"Western Cape" 684 1460 5142.70556640625
"Western Cape" 684 1464 88051.2265625
"Western Cape" 684 1465 902.9779663085938
"Western Cape" 684 1468 217.57884216308594
"Western Cape" 684 1469 6633.31591796875
"Western Cape" 684 1470 216.17796325683594
"Western Cape" 684 1542 2145.558837890625
"Western Cape" 684 1663 63.776920318603516
"Western Cape" 684 1682 153.65444946289062
"Western Cape" 684 1686 326.6263122558594
"Western Cape" 684 1688 481.38671875
"Western Cape" 684 1701 1863.24462890625
"Western Cape" 684 1718 227.09007263183594
"Western Cape" 684 2174 285.41094970703125
"Western Cape" 684 2433 154.17056274414062
"Western Cape" 684 2496 81.25106048583984
"Western Cape" 684 2517 509.9941711425781
"Western Cape" 684 2845 66.57868194580078
"Western Cape" 684 2854 606.4337158203125
"Western Cape" 684 2900 3254.46630859375
"Western Cape" 684 2932 285.48468017578125
"Western Cape" 684 3015 146.65005493164062
"Western Cape" 684 3028 844.3621826171875
"Western Cape" 684 3032 132.05140686035156
"Western Cape" 684 3126 4493.9501953125
"Western Cape" 684 3132 7738.16796875
"Western Cape" 684 3156 35.16946792602539
"Western Cape" 684 3195 827.1092529296875
"Western Cape" 684 3208 23532.578125
"Western Cape" 684 3220 35.31692886352539
"Western Cape" 684 3248 50012.609375
"Western Cape" 684 3255 500.4829406738281
"Western Cape" 684 3259 5929.410217285156
"Western Cape" 684 3299 260.4900207519531
"Western Cape" 684 3311 538.2329711914063
"Western Cape" 684 3374 780.8801879882813
"Western Cape" 684 3429 3218.70703125
"Western Cape" 684 3430 3553.5909423828125
"Western Cape" 684 3557 6740.888671875
"Western Cape" 684 3558 663.8698120117188
"Western Cape" 684 3598 2676.787353515625
"Western Cape" 684 3602 127670.2587890625
"Western Cape" 684 3603 22828.303466796875
"Western Cape" 684 3729 4714.9208984375
"Western Cape" 684 3750 3770.65380859375
"Western Cape" 684 3777 97.0293960571289
"Western Cape" 684 3779 101.52696228027344
"Western Cape" 684 3780 916.6918334960938
"Western Cape" 684 3782 229.96556091308594
"Western Cape" 684 3822 524.1504516601563
"Western Cape" 684 3824 1912.34912109375
"Western Cape" 684 3955 13969.2841796875
"Western Cape" 684 3969 449.8300476074219
"Western Cape" 684 3971 2259.988525390625
"Western Cape" 684 4020 3887.369140625
"Western Cape" 684 4048 6245.56689453125
"Western Cape" 684 4049 4394.93017578125
"Western Cape" 684 4075 14501.0283203125
"Western Cape" 684 4184 1282.8377685546875
"Western Cape" 684 2430 72878.36605834961
"Western Cape" 684 479 420.26409912109375
"Western Cape" 684 564 103.22276306152344
"Western Cape" 684 1172 3.6865272521972656
"Western Cape" 684 1235 38.413612365722656
"Western Cape" 684 1236 8047.09912109375
"Western Cape" 684 1247 8801.3623046875
"Western Cape" 684 1253 3805.60205078125
"Western Cape" 684 1350 663.5748901367188
"Western Cape" 684 1362 566.4718017578125
"Western Cape" 684 1446 .7373054623603821
"Western Cape" 684 1563 47.92485427856445
"Western Cape" 684 1564 78.1543779373169
"Western Cape" 684 1565 98.8726577758789
"Western Cape" 684 1577 109.12120819091797
"Western Cape" 684 1705 195.3859405517578
"Western Cape" 684 1714 3291.84765625
"Western Cape" 684 2171 2348.0966796875
"Western Cape" 684 2273 7397.6806640625
"Western Cape" 684 2287 871.2001342773438
"Western Cape" 684 2302 995.3623657226563
"Western Cape" 684 2371 387.0853576660156
"Western Cape" 684 2428 13428.2490234375
"Western Cape" 684 2855 169.0641326904297
"Western Cape" 684 3024 11.059581756591797
"Western Cape" 684 3104 897.2269897460938
"Western Cape" 684 3173 123.13001251220703
"Western Cape" 684 3259 99797.90430641174
"Western Cape" 684 3405 61.933658599853516
end
format %tm t
label values hs6_code hs6_code
label def hs6_code 479 "170490", modify
label def hs6_code 493 "190190", modify
label def hs6_code 516 "200520", modify
label def hs6_code 560 "210390", modify
label def hs6_code 564 "210610", modify
label def hs6_code 572 "220421", modify
label def hs6_code 824 "282590", modify
label def hs6_code 945 "290511", modify
label def hs6_code 957 "290541", modify
label def hs6_code 1172 "300691", modify
label def hs6_code 1224 "320890", modify
label def hs6_code 1235 "321511", modify
label def hs6_code 1236 "321519", modify
label def hs6_code 1247 "330290", modify
label def hs6_code 1253 "330499", modify
label def hs6_code 1279 "340399", modify
label def hs6_code 1350 "380993", modify
label def hs6_code 1362 "381400", modify
label def hs6_code 1446 "391710", modify
label def hs6_code 1459 "391990", modify
label def hs6_code 1460 "392190", modify
label def hs6_code 1464 "392321", modify
label def hs6_code 1465 "392329", modify
label def hs6_code 1468 "392350", modify
label def hs6_code 1469 "392390", modify
label def hs6_code 1470 "392410", modify
label def hs6_code 1542 "401691", modify
label def hs6_code 1563 "420219", modify
label def hs6_code 1564 "420221", modify
label def hs6_code 1565 "420222", modify
label def hs6_code 1577 "420340", modify
label def hs6_code 1663 "480100", modify
label def hs6_code 1682 "481830", modify
label def hs6_code 1686 "481920", modify
label def hs6_code 1688 "481940", modify
label def hs6_code 1701 "482360", modify
label def hs6_code 1705 "490199", modify
label def hs6_code 1714 "490810", modify
label def hs6_code 1718 "491110", modify
label def hs6_code 2171 "590700", modify
label def hs6_code 2174 "591000", modify
label def hs6_code 2273 "611420", modify
label def hs6_code 2287 "620119", modify
label def hs6_code 2302 "620319", modify
label def hs6_code 2371 "621143", modify
label def hs6_code 2428 "630621", modify
label def hs6_code 2430 "630630", modify
label def hs6_code 2433 "630710", modify
label def hs6_code 2496 "680422", modify
label def hs6_code 2517 "681310", modify
label def hs6_code 2845 "730640", modify
label def hs6_code 2854 "730729", modify
label def hs6_code 2855 "730791", modify
label def hs6_code 2900 "731822", modify
label def hs6_code 2932 "732620", modify
label def hs6_code 3015 "760719", modify
label def hs6_code 3024 "761290", modify
label def hs6_code 3028 "761510", modify
label def hs6_code 3032 "761699", modify
label def hs6_code 3104 "820411", modify
label def hs6_code 3126 "820790", modify
label def hs6_code 3132 "820900", modify
label def hs6_code 3156 "830160", modify
label def hs6_code 3173 "830629", modify
label def hs6_code 3195 "840290", modify
label def hs6_code 3208 "840721", modify
label def hs6_code 3220 "840999", modify
label def hs6_code 3248 "841381", modify
label def hs6_code 3255 "841440", modify
label def hs6_code 3259 "841480", modify
label def hs6_code 3299 "842123", modify
label def hs6_code 3311 "842382", modify
label def hs6_code 3374 "843319", modify
label def hs6_code 3405 "843890", modify
label def hs6_code 3429 "844331", modify
label def hs6_code 3430 "844360", modify
label def hs6_code 3557 "847110", modify
label def hs6_code 3558 "847170", modify
label def hs6_code 3598 "848110", modify
label def hs6_code 3602 "848180", modify
label def hs6_code 3603 "848190", modify
label def hs6_code 3729 "852530", modify
label def hs6_code 3750 "853180", modify
label def hs6_code 3777 "853630", modify
label def hs6_code 3779 "853649", modify
label def hs6_code 3780 "853650", modify
label def hs6_code 3782 "853669", modify
label def hs6_code 3822 "854420", modify
label def hs6_code 3824 "854441", modify
label def hs6_code 3955 "890710", modify
label def hs6_code 3969 "900319", modify
label def hs6_code 3971 "900410", modify
label def hs6_code 4020 "901890", modify
label def hs6_code 4048 "902610", modify
label def hs6_code 4049 "902620", modify
label def hs6_code 4075 "903180", modify
label def hs6_code 4184 "940380", modify
[/CODE]
So far, I have used the province (region), time (monthly) and product code (hs6 code) variables to collapse the data to allow me to make a graph of the evolution of aggregate export volume changes across different provinces by collapsing the data as follows:
collapse (count) ExportVolume = hs6_code (sum) ExportValue = v, by(province t)
Now, I am looking to calculate the growth rate of the volume of exports WITHIN each province/region, but am unsure how to do this correctly. I tried, using data as collapsed above, to do:
egen id = group(province t)
tsset id t, m
gen growth = ((ExportVolume - l.ExportVolume)/l.ExportVolume) * 100
This just yielded missing values within the growth variable for each observation. Essentially what I want to know is how to calculate the growth rates within each province, so that I can use the twoway command to construct a line graph of the evolution of the growth rate in export volumes of different provinces across time. I am using Stata 15 on Windows 11.
Any help would be appreciated. Thank you!
Comment