Hi!
I am trying to drop observations that do not belong to a list of 872 municipalities (I have unique codes for those in the variable ent_mun). I tried to drop them using the inlist() function, but it has a limit of 249 integer values. I saw in other posts that I could combine conditions, however, I get an error from Stata (version 15.1) that says "too many numeric literals r(130);". I used the following code:
Is there an alternative way to do this? Here's an example of my data (I use UTF-8 encoding):
Thanks a lot!
I am trying to drop observations that do not belong to a list of 872 municipalities (I have unique codes for those in the variable ent_mun). I tried to drop them using the inlist() function, but it has a limit of 249 integer values. I saw in other posts that I could combine conditions, however, I get an error from Stata (version 15.1) that says "too many numeric literals r(130);". I used the following code:
Code:
drop if !inlist(ent_mun, 01001, 01003, 01004, 01005, 01007, 01010, 01011, 02001, 02002, 02004, 03001, 03002, 03003, 03009, 04002, 04003, 04004, 04005, 04006, 04009, 04010, 04013, 05002, 05003, 05004, 05007, 05009, 05017, 05018, 05019, 05020, 05022, 05025, 05030, 05035, 05036, 06001, 06002, 06003, 06004, 06005, 06006, 06007, 06009, 06010, 07004, 07005, 07008, 07009, 07012, 07013, 07015, 07017, 07019, 07023, 07026, 07027, 07035, 07038, 07046, 07051, 07059, 07061, 07065, 07068, 07071, 07072, 07076, 07077, 07078, 07081, 07089, 07090, 07091, 07093, 07096, 07101, 07108, 07109, 07112, 08001, 08002, 08004, 08005, 08006, 08008, 08011, 08017, 08019, 08023, 08027, 08028, 08029, 08030, 08032, 08034, 08037, 08040, 08045, 08050, 08051, 08052, 08059, 08062, 08067, 09002, 09003, 09004, 09005, 09006, 09007, 09008, 09009, 09010, 09011, 09012, 09013, 09014, 09015, 09016, 09017, 10005, 10006, 10007, 10008, 10012, 10013, 10014, 10017, 10020, 10023, 10028, 10036, 10039, 11001, 11002, 11003, 11004, 11005, 11007, 11008, 11009, 11011, 11012, 11013, 11014, 11015, 11016, 11017, 11018, 11019, 11020, 11021, 11023, 11024, 11025, 11026, 11027, 11028, 11029, 11030, 11031, 11032, 11033, 11035, 11037, 11038, 11039, 11041, 11042, 11044, 11046, 12001, 12007, 12011, 12012, 12013, 12015, 12023, 12029, 12034, 12038, 12039, 12049, 12052, 12057, 12061, 12066, 12072, 12075, 12077, 13002, 13003, 13004, 13005, 13006, 13007, 13008, 13009, 13010, 13012, 13013, 13016, 13021, 13022, 13028, 13029, 13030, 13038, 13039, 13040, 13045, 13047, 13048, 13050, 13051, 13052, 13055, 13056, 13057, 13061, 13063, 13066, 13067, 13068, 13069, 13072, 13074, 13075, 13076, 13077, 13082, 13083, 14001, 14003, 14004, 14005, 14006, 14007, 14008, 14009, 14012, 14013, 14016, 14017, 14018, 14021, 14022, 14023) & !inlist(ent_mun, 14024, 14025, 14026, 14027, 14030, 14035, 14036, 14037, 14039, 14041, 14043, 14044, 14046, 14047, 14048, 14049, 14050, 14051, 14053, 14055, 14059, 14063, 14064, 14065, 14066, 14067, 14070, 14073, 14077, 14078, 14079, 14082, 14083, 14084, 14085, 14086, 14091, 14092, 14093, 14096, 14097, 14098, 14101, 14108, 14109, 14111, 14112, 14116, 14119, 14120, 14121, 14122, 14124, 14125, 15001, 15002, 15003, 15004, 15005, 15006, 15007, 15009, 15011, 15012, 15013, 15014, 15015, 15016, 15017, 15018, 15019, 15020, 15021, 15022, 15023, 15024, 15025, 15027, 15028, 15029, 15030, 15031, 15032, 15033, 15035, 15036, 15037, 15039, 15040, 15041, 15042, 15043, 15044, 15045, 15046, 15047, 15048, 15050, 15051, 15052, 15053, 15054, 15055, 15056, 15057, 15058, 15059, 15060, 15062, 15063, 15064, 15065, 15066, 15067, 15068, 15070, 15072, 15073, 15074, 15075, 15076, 15078, 15079, 15081, 15082, 15083, 15084, 15085, 15086, 15087, 15088, 15089, 15090, 15091, 15092, 15093, 15094, 15095, 15096, 15097, 15099, 15100, 15101, 15103, 15104, 15105, 15106, 15108, 15109, 15110, 15111, 15112, 15115, 15118, 15119, 15120, 15121, 15122, 15124, 16003, 16004, 16005, 16006, 16007, 16009, 16010, 16011, 16012, 16019, 16020, 16021, 16025, 16027, 16031, 16032, 16034, 16035, 16036, 16037, 16038, 16039, 16040, 16041, 16042, 16043, 16044, 16045, 16046, 16047, 16050, 16052, 16053, 16058, 16060, 16061, 16062, 16064, 16065, 16066, 16067, 16068, 16069, 16071, 16072, 16074, 16075, 16076, 16079, 16080, 16082, 16083, 16084, 16085, 16086, 16087, 16088, 16089, 16090, 16091, 16093, 16095, 16097, 16098, 16100, 16101, 16102, 16103, 16105, 16106, 16107, 16108, 16109, 16110, 16111, 16112, 16113, 17001, 17002, 17004, 17005, 17006, 17007, 17008, 17009, 17011, 17012, 17013, 17016, 17017) & !inlist(ent_mun, 17018, 17020, 17022, 17025, 17026, 17027, 17028, 17029, 17030, 17031, 18001, 18002, 18003, 18004, 18006, 18007, 18008, 18009, 18011, 18012, 18013, 18014, 18015, 18017, 18018, 18020, 19004, 19006, 19009, 19010, 19012, 19018, 19019, 19020, 19021, 19026, 19031, 19038, 19039, 19041, 19045, 19046, 19048, 19049, 20014, 20016, 20030, 20043, 20057, 20059, 20067, 20073, 20079, 20080, 20086, 20095, 20124, 20136, 20177, 20184, 20185, 20188, 20248, 20272, 20324, 20334, 20340, 20364, 20399, 20467, 20472, 20482, 20515, 20533, 21001, 21003, 21004, 21010, 21015, 21017, 21019, 21022, 21029, 21033, 21034, 21041, 21046, 21048, 21050, 21051, 21053, 21067, 21072, 21074, 21079, 21083, 21085, 21087, 21090, 21100, 21104, 21114, 21117, 21119, 21126, 21132, 21134, 21136, 21140, 21143, 21148, 21154, 21156, 21164, 21170, 21174, 21179, 21180, 21189, 21197, 21211, 22001, 22003, 22004, 22005, 22006, 22007, 22011, 22012, 22013, 22014, 22015, 22016, 22017, 23001, 23002, 23004, 23005, 23007, 23008, 23009, 23010, 23011, 24001, 24005, 24009, 24011, 24013, 24020, 24021, 24028, 24032, 24035, 24037, 24046, 24049, 24050, 24055, 24057, 25001, 25004, 25006, 25007, 25009, 25012, 25013, 25014, 25015, 25017, 25018, 26010, 26011, 26017, 26018, 26025, 26029, 26030, 26043, 26055, 26071, 27001, 27002, 27003, 27004, 27005, 27006, 27008, 27009, 27010, 27012, 27013, 27014, 27015, 27016, 27017, 28003, 28009, 28021, 28022, 28027, 28028, 28032, 28033, 28038, 28039, 28040, 29004, 29005, 29006, 29008, 29010, 29013, 29014, 29015, 29016, 29018, 29019, 29021, 29023, 29024, 29025, 29026, 29027, 29028, 29029, 29031, 29033, 29034, 29036, 29038, 29039, 29040, 29041, 29042, 29043, 29044, 29048, 29050, 29057, 29059, 30001, 30003, 30004, 30010, 30011, 30012, 30013, 30014, 30016) & !inlist(ent_mun, 30028, 30030, 30036, 30038, 30039, 30042, 30043, 30045, 30046, 30048, 30051, 30052, 30058, 30059, 30061, 30065, 30069, 30075, 30083, 30084, 30087, 30088, 30089, 30092, 30094, 30095, 30096, 30100, 30105, 30108, 30109, 30111, 30112, 30116, 30117, 30121, 30126, 30128, 30130, 30131, 30132, 30134, 30135, 30141, 30144, 30145, 30147, 30148, 30151, 30157, 30160, 30161, 30163, 30164, 30174, 30175, 30181, 30189, 30191, 30193, 30197, 30199, 30205, 30206, 30207, 31001, 31002, 31009, 31013, 31018, 31019, 31021, 31022, 31023, 31024, 31025, 31027, 31028, 31033, 31036, 31038, 31040, 31041, 31047, 31048, 31050, 31052, 31055, 31056, 31057, 31058, 31059, 31063, 31069, 31070, 31074, 31079, 31080, 31088, 31089, 31095, 31096, 31098, 31100, 31101, 31102, 32005, 32010, 32012, 32017, 32020, 32025, 32027, 32035, 32036, 32037, 32038, 32049, 32054, 32055, 32056, 32057, 30017, 30025, 30026)
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input byte entidad str31 nom_ent int mun str50 nom_mun long pobtot str8(pobfem pobmas) int ent_mun str2 cve_ent 1 "Aguascalientes" 1 "Aguascalientes" 948990 "486917" "462073" 1001 "01" 1 "Aguascalientes" 2 "Asientos" 51536 "26275" "25261" 1002 "01" 1 "Aguascalientes" 3 "Calvillo" 58250 "29687" "28563" 1003 "01" 1 "Aguascalientes" 4 "Cosío" 17000 "8708" "8292" 1004 "01" 1 "Aguascalientes" 5 "Jesús María" 129929 "65710" "64219" 1005 "01" 1 "Aguascalientes" 6 "Pabellón de Arteaga" 47646 "24269" "23377" 1006 "01" 1 "Aguascalientes" 7 "Rincón de Romos" 57369 "29268" "28101" 1007 "01" 1 "Aguascalientes" 8 "San José de Gracia" 9552 "5020" "4532" 1008 "01" 1 "Aguascalientes" 9 "Tepezalá" 22485 "11371" "11114" 1009 "01" 1 "Aguascalientes" 10 "El Llano" 20853 "10407" "10446" 1010 "01" 1 "Aguascalientes" 11 "San Francisco de los Romo" 61997 "31292" "30705" 1011 "01" 2 "Baja California" 1 "Ensenada" 443807 "222500" "221307" 2001 "02" 2 "Baja California" 2 "Mexicali" 1049792 "520544" "529248" 2002 "02" 2 "Baja California" 3 "Tecate" 108440 "51310" "57130" 2003 "02" 2 "Baja California" 4 "Tijuana" 1922523 "953783" "968740" 2004 "02" 2 "Baja California" 5 "Playas de Rosarito" 126890 "62504" "64386" 2005 "02" 2 "Baja California" 6 "San Quintín" 117568 "57790" "59778" 2006 "02" 3 "Baja California Sur" 1 "Comondú" 73021 "36217" "36804" 3001 "03" 3 "Baja California Sur" 2 "Mulegé" 64022 "30951" "33071" 3002 "03" 3 "Baja California Sur" 3 "La Paz" 292241 "146438" "145803" 3003 "03" 3 "Baja California Sur" 8 "Los Cabos" 351111 "170167" "180944" 3008 "03" 3 "Baja California Sur" 9 "Loreto" 18052 "8795" "9257" 3009 "03" 4 "Campeche" 1 "Calkiní" 59232 "30062" "29170" 4001 "04" 4 "Campeche" 2 "Campeche" 294077 "152522" "141555" 4002 "04" 4 "Campeche" 3 "Carmen" 248845 "125802" "123043" 4003 "04" 4 "Campeche" 4 "Champotón" 78170 "39140" "39030" 4004 "04" 4 "Campeche" 5 "Hecelchakán" 31917 "16204" "15713" 4005 "04" 4 "Campeche" 6 "Hopelchén" 42140 "20812" "21328" 4006 "04" 4 "Campeche" 7 "Palizada" 8683 "4260" "4423" 4007 "04" 4 "Campeche" 8 "Tenabo" 11452 "5655" "5797" 4008 "04" 4 "Campeche" 9 "Escárcega" 59923 "30455" "29468" 4009 "04" 4 "Campeche" 10 "Calakmul" 31714 "15613" "16101" 4010 "04" 4 "Campeche" 11 "Candelaria" 46913 "23239" "23674" 4011 "04" 4 "Campeche" 12 "Seybaplaya" 15297 "7660" "7637" 4012 "04" 5 "Coahuila de Zaragoza" 1 "Abasolo" 1022 "487" "535" 5001 "05" 5 "Coahuila de Zaragoza" 2 "Acuña" 163058 "81115" "81943" 5002 "05" 5 "Coahuila de Zaragoza" 3 "Allende" 23056 "11610" "11446" 5003 "05" 5 "Coahuila de Zaragoza" 4 "Arteaga" 29578 "14623" "14955" 5004 "05" 5 "Coahuila de Zaragoza" 5 "Candela" 1643 "800" "843" 5005 "05" 5 "Coahuila de Zaragoza" 6 "Castaños" 29128 "14532" "14596" 5006 "05" 5 "Coahuila de Zaragoza" 7 "Cuatro Ciénegas" 12715 "6350" "6365" 5007 "05" 5 "Coahuila de Zaragoza" 8 "Escobedo" 3047 "1518" "1529" 5008 "05" 5 "Coahuila de Zaragoza" 9 "Francisco I. Madero" 59035 "29818" "29217" 5009 "05" 5 "Coahuila de Zaragoza" 10 "Frontera" 82409 "41200" "41209" 5010 "05" 5 "Coahuila de Zaragoza" 11 "General Cepeda" 11898 "5807" "6091" 5011 "05" 5 "Coahuila de Zaragoza" 12 "Guerrero" 1643 "760" "883" 5012 "05" 5 "Coahuila de Zaragoza" 13 "Hidalgo" 1735 "839" "896" 5013 "05" 5 "Coahuila de Zaragoza" 14 "Jiménez" 9502 "4645" "4857" 5014 "05" 5 "Coahuila de Zaragoza" 15 "Juárez" 1584 "798" "786" 5015 "05" 5 "Coahuila de Zaragoza" 16 "Lamadrid" 1764 "836" "928" 5016 "05" 5 "Coahuila de Zaragoza" 17 "Matamoros" 118337 "59645" "58692" 5017 "05" 5 "Coahuila de Zaragoza" 18 "Monclova" 237951 "119893" "118058" 5018 "05" 5 "Coahuila de Zaragoza" 19 "Morelos" 7928 "3993" "3935" 5019 "05" 5 "Coahuila de Zaragoza" 20 "Múzquiz" 71627 "35771" "35856" 5020 "05" 5 "Coahuila de Zaragoza" 21 "Nadadores" 6539 "3296" "3243" 5021 "05" 5 "Coahuila de Zaragoza" 22 "Nava" 33129 "16530" "16599" 5022 "05" 5 "Coahuila de Zaragoza" 23 "Ocampo" 9642 "4650" "4992" 5023 "05" 5 "Coahuila de Zaragoza" 24 "Parras" 44472 "21938" "22534" 5024 "05" 5 "Coahuila de Zaragoza" 25 "Piedras Negras" 176327 "87616" "88711" 5025 "05" 5 "Coahuila de Zaragoza" 26 "Progreso" 3239 "1605" "1634" 5026 "05" 5 "Coahuila de Zaragoza" 27 "Ramos Arizpe" 122243 "59521" "62722" 5027 "05" 5 "Coahuila de Zaragoza" 28 "Sabinas" 64811 "32574" "32237" 5028 "05" 5 "Coahuila de Zaragoza" 29 "Sacramento" 2471 "1229" "1242" 5029 "05" 5 "Coahuila de Zaragoza" 30 "Saltillo" 879958 "442166" "437792" 5030 "05" 5 "Coahuila de Zaragoza" 31 "San Buenaventura" 24759 "12484" "12275" 5031 "05" 5 "Coahuila de Zaragoza" 32 "San Juan de Sabinas" 42260 "21338" "20922" 5032 "05" 5 "Coahuila de Zaragoza" 33 "San Pedro" 101041 "51092" "49949" 5033 "05" 5 "Coahuila de Zaragoza" 34 "Sierra Mojada" 6744 "3217" "3527" 5034 "05" 5 "Coahuila de Zaragoza" 35 "Torreón" 720848 "369095" "351753" 5035 "05" 5 "Coahuila de Zaragoza" 36 "Viesca" 20305 "10075" "10230" 5036 "05" 5 "Coahuila de Zaragoza" 37 "Villa Unión" 6188 "3058" "3130" 5037 "05" 5 "Coahuila de Zaragoza" 38 "Zaragoza" 13135 "6578" "6557" 5038 "05" 6 "Colima" 1 "Armería" 27626 "13686" "13940" 6001 "06" 6 "Colima" 2 "Colima" 157048 "80893" "76155" 6002 "06" 6 "Colima" 3 "Comala" 21661 "10768" "10893" 6003 "06" 6 "Colima" 4 "Coquimatlán" 20837 "10353" "10484" 6004 "06" 6 "Colima" 5 "Cuauhtémoc" 31267 "15538" "15729" 6005 "06" 6 "Colima" 6 "Ixtlahuacán" 5623 "2736" "2887" 6006 "06" 6 "Colima" 7 "Manzanillo" 191031 "95914" "95117" 6007 "06" 6 "Colima" 8 "Minatitlán" 10231 "4997" "5234" 6008 "06" 6 "Colima" 9 "Tecomán" 116305 "58476" "57829" 6009 "06" 6 "Colima" 10 "Villa de Álvarez" 149762 "77408" "72354" 6010 "06" 7 "Chiapas" 1 "Acacoyagua" 17994 "8997" "8997" 7001 "07" 7 "Chiapas" 2 "Acala" 21187 "10773" "10414" 7002 "07" 7 "Chiapas" 3 "Acapetahua" 26899 "13714" "13185" 7003 "07" 7 "Chiapas" 4 "Altamirano" 36160 "18128" "18032" 7004 "07" 7 "Chiapas" 5 "Amatán" 24512 "12184" "12328" 7005 "07" 7 "Chiapas" 6 "Amatenango de la Frontera" 31735 "16307" "15428" 7006 "07" 7 "Chiapas" 7 "Amatenango del Valle" 11283 "5910" "5373" 7007 "07" 7 "Chiapas" 8 "Angel Albino Corzo" 31947 "16042" "15905" 7008 "07" 7 "Chiapas" 9 "Arriaga" 41135 "21181" "19954" 7009 "07" 7 "Chiapas" 10 "Bejucal de Ocampo" 7365 "3713" "3652" 7010 "07" 7 "Chiapas" 11 "Bella Vista" 20157 "10155" "10002" 7011 "07" 7 "Chiapas" 12 "Berriozábal" 64632 "32718" "31914" 7012 "07" 7 "Chiapas" 13 "Bochil" 37263 "19055" "18208" 7013 "07" 7 "Chiapas" 14 "El Bosque" 24273 "12562" "11711" 7014 "07" 7 "Chiapas" 15 "Cacahoatán" 50112 "25685" "24427" 7015 "07" 7 "Chiapas" 16 "Catazajá" 17619 "8737" "8882" 7016 "07" 7 "Chiapas" 17 "Cintalapa" 88106 "44429" "43677" 7017 "07" 7 "Chiapas" 18 "Coapilla" 9900 "5027" "4873" 7018 "07" end
Comment