My dataset has a variable called "municipio", which contains nive digits (see data sample below)
I need to extract the last seven digits in order to obtain Brazilian municipalities' IDs.
Example:
For the municipality of "Franca", "municipio" value is 153516200
What I need: to remove 15 and obtain 3516200. And so on for all municipalities
How can that be done?
Thank you
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input int idnum byte pais int estratopri float(ibge_uf_code ibge_mun_code) str2 braprov int prov str23 bramunicipio long municipio 1 15 1504 35 . "SP" 1535 "Franca" 153516200 2 15 1504 35 . "SP" 1535 "Franca" 153516200 3 15 1504 35 . "SP" 1535 "Franca" 153516200 4 15 1504 35 . "SP" 1535 "Franca" 153516200 5 15 1504 35 . "SP" 1535 "Franca" 153516200 6 15 1504 35 . "SP" 1535 "Franca" 153516200 7 15 1504 35 . "SP" 1535 "Franca" 153516200 8 15 1504 35 . "SP" 1535 "Franca" 153516200 9 15 1504 35 . "SP" 1535 "Franca" 153516200 10 15 1504 35 . "SP" 1535 "Franca" 153516200 11 15 1504 35 . "SP" 1535 "Franca" 153516200 12 15 1504 35 . "SP" 1535 "Franca" 153516200 13 15 1504 35 . "SP" 1535 "Franca" 153516200 14 15 1504 35 . "SP" 1535 "Franca" 153516200 15 15 1504 35 . "SP" 1535 "Franca" 153516200 16 15 1504 35 . "SP" 1535 "Franca" 153516200 17 15 1504 35 . "SP" 1535 "Franca" 153516200 18 15 1504 35 . "SP" 1535 "Franca" 153516200 19 15 1504 35 . "SP" 1535 "Franca" 153516200 20 15 1504 35 . "SP" 1535 "Franca" 153516200 21 15 1504 35 . "SP" 1535 "Franca" 153516200 22 15 1504 35 . "SP" 1535 "Franca" 153516200 23 15 1504 35 . "SP" 1535 "Franca" 153516200 24 15 1504 35 . "SP" 1535 "Franca" 153516200 25 15 1504 35 . "SP" 1535 "Franca" 153516200 26 15 1504 35 . "SP" 1535 "Franca" 153516200 27 15 1504 35 . "SP" 1535 "Franca" 153516200 28 15 1504 35 . "SP" 1535 "Franca" 153516200 29 15 1504 35 . "SP" 1535 "Franca" 153516200 30 15 1504 35 . "SP" 1535 "Franca" 153516200 31 15 1504 35 . "SP" 1535 "Franca" 153516200 32 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 33 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 34 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 35 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 36 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 37 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 38 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 39 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 40 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 41 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 42 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 43 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 44 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 45 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 46 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 47 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 48 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 49 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 50 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 51 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 52 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 53 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 54 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 55 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 56 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 57 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 58 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 59 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 60 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 61 15 1504 35 . "SP" 1535 "S�o Jose dos Campos" 153549904 62 15 1504 35 . "SP" 1535 "Narandiba" 153532207 63 15 1504 35 . "SP" 1535 "Narandiba" 153532207 64 15 1504 35 . "SP" 1535 "Narandiba" 153532207 65 15 1504 35 . "SP" 1535 "Narandiba" 153532207 66 15 1504 35 . "SP" 1535 "Narandiba" 153532207 67 15 1504 35 . "SP" 1535 "Narandiba" 153532207 68 15 1504 35 . "SP" 1535 "Narandiba" 153532207 69 15 1504 35 . "SP" 1535 "Narandiba" 153532207 70 15 1504 35 . "SP" 1535 "Narandiba" 153532207 71 15 1504 35 . "SP" 1535 "Narandiba" 153532207 72 15 1504 35 . "SP" 1535 "Narandiba" 153532207 73 15 1504 35 . "SP" 1535 "Narandiba" 153532207 74 15 1504 35 . "SP" 1535 "Narandiba" 153532207 75 15 1504 35 . "SP" 1535 "Narandiba" 153532207 76 15 1504 35 . "SP" 1535 "Narandiba" 153532207 77 15 1504 35 . "SP" 1535 "Narandiba" 153532207 78 15 1504 35 . "SP" 1535 "Narandiba" 153532207 79 15 1504 35 . "SP" 1535 "Narandiba" 153532207 80 15 1504 35 . "SP" 1535 "Narandiba" 153532207 81 15 1504 35 . "SP" 1535 "Narandiba" 153532207 82 15 1504 35 . "SP" 1535 "Narandiba" 153532207 83 15 1504 35 . "SP" 1535 "Narandiba" 153532207 84 15 1504 35 . "SP" 1535 "Narandiba" 153532207 85 15 1504 35 . "SP" 1535 "Narandiba" 153532207 86 15 1504 35 . "SP" 1535 "Narandiba" 153532207 87 15 1504 35 . "SP" 1535 "Narandiba" 153532207 88 15 1504 35 . "SP" 1535 "Narandiba" 153532207 89 15 1504 35 . "SP" 1535 "Narandiba" 153532207 90 15 1504 35 . "SP" 1535 "Narandiba" 153532207 91 15 1504 35 . "SP" 1535 "Narandiba" 153532207 92 15 1505 42 . "SC" 1542 "Blumenau" 154202404 93 15 1505 42 . "SC" 1542 "Blumenau" 154202404 94 15 1505 42 . "SC" 1542 "Blumenau" 154202404 95 15 1505 42 . "SC" 1542 "Blumenau" 154202404 96 15 1505 42 . "SC" 1542 "Blumenau" 154202404 97 15 1505 42 . "SC" 1542 "Blumenau" 154202404 98 15 1505 42 . "SC" 1542 "Blumenau" 154202404 99 15 1505 42 . "SC" 1542 "Blumenau" 154202404 100 15 1505 42 . "SC" 1542 "Blumenau" 154202404 end label values estratopri estratopri label def estratopri 1504 "Sudeste", modify label def estratopri 1505 "Sul", modify label values prov prov label def prov 1535 "S�o Paulo", modify label def prov 1542 "Santa Catarina", modify label values municipio municipio label def municipio 153516200 "Franca", modify label def municipio 153532207 "Narandiba", modify label def municipio 153549904 "S�o Jos� dos Campos", modify label def municipio 154202404 "Blumenau", modify
0 Response to How to extract the last seven digits of nine-digits numbers?
Post a Comment