Changing Rows into Lines

[Gabriela Santana Tavera]

Hello,
This is my first post, so I am sorry if I missed anything. I have a dataset in this very difficult format were every line is a section in a grade in a shift in a level. For example, a 8th grade class A in the morning shift at the high school level. Every line is a school and I would like to change this so every line is a class in a section. For example line 1 would be Maternal A in COMPLETA shift at the initial level in school HERNANDO GORJON.

Thank you for your help.

* Example generated by -dataex-. For more info, type help dataex

input str27 B str36 C str78 D str12 E str8 F str2 G
"Direccion Regional" "Distrito Educativo" "Centros"                                                "Codigo Viejo" "Inicial"  "" 
""                   ""                   ""                                                       ""             "COMPLETA" "" 
""                   ""                   ""                                                       ""             "Maternal" "" 
""                   ""                   ""                                                       ""             "A"        "B"
"01 BARAHONA"        "0101  PEDERNALES"   "02334 - HERNANDO GORJON"                                "16000218"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02335 - BIENVENIDO MORILLO"                             "16000416"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02336 - BARRIO LAS MERCEDES"                            "16000812"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02337 - MERCEDES, LAS"                                  "16001015"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02338 - COLONIA MENCIA"                                 "16001119"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   `"02339 - ALTAGRACIA "A", LA"'                           "16001411"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02341 - COLONIA LOS ARROYOS"                            "16001713"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02342 - AVILA"                                          "16001911"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02343 - AGUAS NEGRAS"                                   "16002010"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02344 - HIGO GRANDE"                                    "16002218"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02345 - GASTON FERNANDO DELIGNE"                        "16002533"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02346 - BUCARAL"                                        "16002718"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02347 - COLONIA JUANCHO"                                "16002920"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02348 - JUANCHO"                                        "16003119"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02350 - CAJUIL, EL"                                     "16003411"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02351 - TRES CHARCOS, LOS"                              "16003515"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02352 - MANUEL GOYA"                                    "16003713"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02353 - SITIO NUEVO"                                    "16004711"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "12097 - LUIS EMILIO PEREZ MENDEZ"                       "16005216"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00711 - TATIANA RODRIGUEZ"                              "04010011"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00712 - ISMAEL MIRANDA"                                 "04010115"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00713 - MENCIA"                                         "04010511"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00714 - ARROYO DULCE"                                   "04010719"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00715 - NARANJAL"                                       "04010813"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00716 - HIGUERO, EL"                                    "04011016"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00719 - MALAGUETA, LA"                                  "04011318"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00720 - AQUILINA TURBI GOMEZ - BUENA VISTA"             "04011412"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00721 - DOMINGO MATOS FELIZ- JUAN ISIDRO"               "04011610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00722 - AUGUSTO FELIZ MATOS - LA TORRE"                 "04011725"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00723 - DORA CORCIA SANCHEZ SANCHEZ - LOS COCOS"        "04011818"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00724 - BLANCOS, LOS"                                   "04012219"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00725 - JOSE ANTONIO ALVAREZ - PALMARITO"               "04012511"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00726 - PEÑALVA"                                       "04012719"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00727 - CALETON"                                        "04012917"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00728 - MERCEDITAS, LAS"                                "04013110"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00729 - CHENE"                                          "04013318"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00730 - EDUARDO CUEVAS PEÑA - LA ISLETA"               "04013610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00731 - PINO ABAJO, EL"                                 "04013714"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00735 - CORTICO"                                        "04015318"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00736 - PLATON, EL"                                     "04015412"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00737 - CHARCO BLANCO"                                  "04015610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00738 - SAN RAFAEL"                                     "04015714"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00739 - WANDA MARTINA JIMENEZ - LA LANZA ABAJO"         "04016011"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00741 - LEONARDO"                                       "04016313"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00742 - MALANGA"                                        "04016511"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00743 - NUEVA ROSA-CACO"                                "04016719"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00744 - HORACIO CARRASCO LEGER- LA CAOBA"               "04016813"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00745 - ERANIO MATEO MEDINA - CHARCO PRIETO"            "04017016"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00746 - ANTONIO TORRE COLON - VILLA NIZAO"              "04017610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00747 - CLARA ROSA PEREZ FELIZ - LOS PATOS"             "04017818"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00748 - EUGENIO MEDINA FELIZ - BEJUQUERO"               "04018011"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00749 - OCACIO SANTANA CARRASCO - OJEDA"                "04018219"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00787 - CAOBAS, LAS"                                    "04032317"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00791 - GUAZUMA, LA"                                    "04032911"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00801 - MANIEL, EL"                                     "04035918"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00813 - RIO SITO"                                       "04038619"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00814 - AUDON"                                          "04038718"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00815 - CRESTELEANDRO"                                  "04038916"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00816 - CANOA, LA"                                      "04039115"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00817 - TORO, EL"                                       "04040112"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00818 - PLAY, EL"                                       "04040210"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "10467 - BARRIO NUEVO"                                   "04018417"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "10552 - MENCIA"                                         "04015016"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "11166 - EL INGENIO"                                     "04038817"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00679 - BAITOITA"                                       "04000119"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00680 - CASANDRA DAMIRON"                               "04000321"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00681 - PARROQUIAL LA ALTAGRACIA"                       "04000515"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00682 - LIRIOS, LOS"                                    "04000619"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00683 - SANTO DOMINGO SAVIO"                            "04000911"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00684 - PARROQUIAL CRISTO REY"                          "04001510"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00685 - PARROQUIAL JAIME MOTA"                          "04002015"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00686 - NUEVO JARDIN"                                   "04002220"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00687 - CLUB DE LEONES"                                 "04002411"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00688 - DIVINA PASTORA"                                 "04003021"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00689 - ECONOMIA DOMESTICA"                             "04003114"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00690 - LEONOR FELTZ"                                   "04003312"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00691 - ACADEMIA FRANCISCANA"                           "04003614"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00692 - ANAIMA TEJADA CHAPMAN"                          "04003718"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00693 - SAN JUAN BOSCO"                                 "04005010"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00694 - TANQUE, EL"                                     "04005312"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00696 - FIDEL MEDINA - REFUGIO EL CACHON"               "04005718"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA"        "04006015"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00698 - SANTA ELENA"                                    "04006411"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00699 - MANANTIAL"                                      "04006619"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00700 - FILIPINAS, LAS"                                 "04006713"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00770 - MARINA SEPULVEDA"                               "04024111"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00771 - HILDA CELESTE RAMIREZ MATOS -  LOS  JAQUIMEYES" "04024715"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00772 - FIAMETA GARCIA FRANCO"                          "04025116"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00773 - JUAN PABLO DUARTE"                              "04025512"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00774 - AURA THERMA SUERO FELIZ - HABANERO"             "04025814"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00775 - HATO VIEJO"                                     "04026319"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00776 - LUIS FELIPE FELIZ Y FELIZ"                      "04026517"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00777 - CIENAGA - LEA M. MORETA, LA"                    "04026913"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00778 - ARROYO, EL"                                     "04027210"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00779 - BAHORUCO"                                       "04027814"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00780 - AGUITA BLANCA"                                  "04028017"     ""         "" 
end

[Andrew Musau]

I have a dataset in this very difficult format were every line is a section in a grade in a shift in a level. For example, a 8th grade class A in the morning shift at the high school level. Every line is a school and I would like to change this so every line is a class in a section. For example line 1 would be Maternal A in COMPLETA shift at the initial level in school HERNANDO GORJON.

This is difficult to follow. My suggestion is that you manually create an example of how you want the final output to look like, e.g., taking the first two full observations in your dataset.

"01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218"
"01 BARAHONA" "0101 PEDERNALES" "02335 - BIENVENIDO MORILLO" "16000416"

[Gabriela Santana Tavera]

Hello Andrew,

Thank you for your time, sorry if I wasn't so clear.
I would like the following
01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218" Inicial" "COMPLETA" "" "Maternal" """A"
01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218" Inicial"."COMPLETA" """Maternal" """B"
01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218" Inicial"."COMPLETA" """Maternal" """C"
01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218" Inicial""COMPLETA" """Maternal" """D"
01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218" Inicial""COMPLETA" """Maternal" """E"
"01 BARAHONA" "0101 PEDERNALES" "02335 - BIENVENIDO MORILLO" "16000416" Inicial" "COMPLETA" "" "Maternal" "A"
"01 BARAHONA" "0101 PEDERNALES" "02335 - BIENVENIDO MORILLO" "16000416" Inicial" "COMPLETA" "" "Maternal" """B"

I also added a picture of how my dataset looks like originally in excel because it is not so clear in DataEX, but as you can see every cell is an individual classroom in a school. Thank you for your help.

[Andrew Musau]

I have expanded your data example in #1 to correspond to some of the left-out columns in #2. Depending on how my expansion corresponds to your real data, you may need to make some changes to my code below as I refer to observation numbers.

* Example generated by -dataex-. To install: ssc install dataex
clear
input str27 B str36 C str78 D str12 E str8 F str3(G H) str6 I str3(J K) str12 L str3(M N)
"Direccion Regional" "Distrito Educativo" "Centros"                                                "Codigo Viejo" "Inicial"  ""    ""    ""       ""    ""    ""             ""    ""  
""                   ""                   ""                                                       ""             "COMPLETA" ""    ""    ""       ""    ""    ""             ""    ""  
""                   ""                   ""                                                       ""             "Maternal" ""    ""    "Kinder" ""    ""    "Pre_Premaria" ""    ""  
""                   ""                   ""                                                       ""             "A"        "B"   "C"   "A"      "B"   "C"   "A"            "B "  "C"  
"01 BARAHONA"        "0101  PEDERNALES"   "02334 - HERNANDO GORJON"                                "16000218"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02335 - BIENVENIDO MORILLO"                             "16000416"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02336 - BARRIO LAS MERCEDES"                            "16000812"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02337 - MERCEDES, LAS"                                  "16001015"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02338 - COLONIA MENCIA"                                 "16001119"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   `"02339 - ALTAGRACIA "A", LA"'                           "16001411"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02341 - COLONIA LOS ARROYOS"                            "16001713"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02342 - AVILA"                                          "16001911"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02343 - AGUAS NEGRAS"                                   "16002010"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02344 - HIGO GRANDE"                                    "16002218"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02345 - GASTON FERNANDO DELIGNE"                        "16002533"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02346 - BUCARAL"                                        "16002718"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02347 - COLONIA JUANCHO"                                "16002920"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02348 - JUANCHO"                                        "16003119"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02350 - CAJUIL, EL"                                     "16003411"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02351 - TRES CHARCOS, LOS"                              "16003515"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02352 - MANUEL GOYA"                                    "16003713"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "02353 - SITIO NUEVO"                                    "16004711"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0101  PEDERNALES"   "12097 - LUIS EMILIO PEREZ MENDEZ"                       "16005216"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00711 - TATIANA RODRIGUEZ"                              "04010011"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00712 - ISMAEL MIRANDA"                                 "04010115"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00713 - MENCIA"                                         "04010511"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00714 - ARROYO DULCE"                                   "04010719"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00715 - NARANJAL"                                       "04010813"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00716 - HIGUERO, EL"                                    "04011016"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00719 - MALAGUETA, LA"                                  "04011318"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00720 - AQUILINA TURBI GOMEZ - BUENA VISTA"             "04011412"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00721 - DOMINGO MATOS FELIZ- JUAN ISIDRO"               "04011610"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00722 - AUGUSTO FELIZ MATOS - LA TORRE"                 "04011725"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00723 - DORA CORCIA SANCHEZ SANCHEZ - LOS COCOS"        "04011818"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00724 - BLANCOS, LOS"                                   "04012219"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00725 - JOSE ANTONIO ALVAREZ - PALMARITO"               "04012511"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00726 - PEÑALVA"                                       "04012719"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00727 - CALETON"                                        "04012917"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00728 - MERCEDITAS, LAS"                                "04013110"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00729 - CHENE"                                          "04013318"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00730 - EDUARDO CUEVAS PEÑA - LA ISLETA"               "04013610"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00731 - PINO ABAJO, EL"                                 "04013714"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00735 - CORTICO"                                        "04015318"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00736 - PLATON, EL"                                     "04015412"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00737 - CHARCO BLANCO"                                  "04015610"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00738 - SAN RAFAEL"                                     "04015714"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00739 - WANDA MARTINA JIMENEZ - LA LANZA ABAJO"         "04016011"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00741 - LEONARDO"                                       "04016313"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00742 - MALANGA"                                        "04016511"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00743 - NUEVA ROSA-CACO"                                "04016719"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00744 - HORACIO CARRASCO LEGER- LA CAOBA"               "04016813"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00745 - ERANIO MATEO MEDINA - CHARCO PRIETO"            "04017016"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00746 - ANTONIO TORRE COLON - VILLA NIZAO"              "04017610"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00747 - CLARA ROSA PEREZ FELIZ - LOS PATOS"             "04017818"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00748 - EUGENIO MEDINA FELIZ - BEJUQUERO"               "04018011"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00749 - OCACIO SANTANA CARRASCO - OJEDA"                "04018219"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00787 - CAOBAS, LAS"                                    "04032317"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00791 - GUAZUMA, LA"                                    "04032911"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00801 - MANIEL, EL"                                     "04035918"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00813 - RIO SITO"                                       "04038619"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00814 - AUDON"                                          "04038718"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00815 - CRESTELEANDRO"                                  "04038916"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00816 - CANOA, LA"                                      "04039115"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00817 - TORO, EL"                                       "04040112"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "00818 - PLAY, EL"                                       "04040210"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "10467 - BARRIO NUEVO"                                   "04018417"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "10552 - MENCIA"                                         "04015016"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0102  ENRIQUILLO"   "11166 - EL INGENIO"                                     "04038817"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00679 - BAITOITA"                                       "04000119"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00680 - CASANDRA DAMIRON"                               "04000321"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00681 - PARROQUIAL LA ALTAGRACIA"                       "04000515"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00682 - LIRIOS, LOS"                                    "04000619"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00683 - SANTO DOMINGO SAVIO"                            "04000911"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00684 - PARROQUIAL CRISTO REY"                          "04001510"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00685 - PARROQUIAL JAIME MOTA"                          "04002015"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00686 - NUEVO JARDIN"                                   "04002220"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00687 - CLUB DE LEONES"                                 "04002411"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00688 - DIVINA PASTORA"                                 "04003021"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00689 - ECONOMIA DOMESTICA"                             "04003114"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00690 - LEONOR FELTZ"                                   "04003312"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00691 - ACADEMIA FRANCISCANA"                           "04003614"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00692 - ANAIMA TEJADA CHAPMAN"                          "04003718"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00693 - SAN JUAN BOSCO"                                 "04005010"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00694 - TANQUE, EL"                                     "04005312"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00696 - FIDEL MEDINA - REFUGIO EL CACHON"               "04005718"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA"        "04006015"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00698 - SANTA ELENA"                                    "04006411"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00699 - MANANTIAL"                                      "04006619"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00700 - FILIPINAS, LAS"                                 "04006713"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00770 - MARINA SEPULVEDA"                               "04024111"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00771 - HILDA CELESTE RAMIREZ MATOS -  LOS  JAQUIMEYES" "04024715"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00772 - FIAMETA GARCIA FRANCO"                          "04025116"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00773 - JUAN PABLO DUARTE"                              "04025512"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00774 - AURA THERMA SUERO FELIZ - HABANERO"             "04025814"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00775 - HATO VIEJO"                                     "04026319"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00776 - LUIS FELIPE FELIZ Y FELIZ"                      "04026517"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00777 - CIENAGA - LEA M. MORETA, LA"                    "04026913"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00778 - ARROYO, EL"                                     "04027210"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00779 - BAHORUCO"                                       "04027814"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
"01 BARAHONA"        "0103  BARAHONA"     "00780 - AGUITA BLANCA"                                  "04028017"     "xxx"      "yyy" "zzz" "xxx"    "yyy" "zzz" "xxx"          "yyy" "zzz"
end

foreach var of varlist B-E{
    rename `var' `=lower(strtoname(`var'[1]))'
}

local v
foreach var of varlist F-N{
    if missing(`var'[3]){
        replace `var'= `v'[3] in 3
    }
    local v `var'
}

foreach var of varlist F-N{
rename `var' `=lower(strtoname(`var'[3]))'`=`var'[4]'
}
drop in 1/4
reshape long maternal kinder pre_premaria, i(centros) j(which) string

Result follows in #5. Note that if you need "maternal", "kinder" and "pre_premaria" in one variable, you just reshape long again.

[Andrew Musau]

Edited Res.:

. l centros which direccion_regional distrito_educativo maternal kinder pre_premaria , sepby(centros)

     +--------------------------------------------------------------------------------------------------------------------------------+
     |                                                centros   which   direccion~l   distrito_educa~o   maternal   kinder   pre_pr~a |
     |--------------------------------------------------------------------------------------------------------------------------------|
  1. |                                       00679 - BAITOITA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
  2. |                                       00679 - BAITOITA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
  3. |                                       00679 - BAITOITA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
  4. |                               00680 - CASANDRA DAMIRON       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
  5. |                               00680 - CASANDRA DAMIRON       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
  6. |                               00680 - CASANDRA DAMIRON       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
  7. |                       00681 - PARROQUIAL LA ALTAGRACIA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
  8. |                       00681 - PARROQUIAL LA ALTAGRACIA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
  9. |                       00681 - PARROQUIAL LA ALTAGRACIA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 10. |                                    00682 - LIRIOS, LOS       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 11. |                                    00682 - LIRIOS, LOS       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 12. |                                    00682 - LIRIOS, LOS       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 13. |                            00683 - SANTO DOMINGO SAVIO       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 14. |                            00683 - SANTO DOMINGO SAVIO       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 15. |                            00683 - SANTO DOMINGO SAVIO       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 16. |                          00684 - PARROQUIAL CRISTO REY       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 17. |                          00684 - PARROQUIAL CRISTO REY       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 18. |                          00684 - PARROQUIAL CRISTO REY       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 19. |                          00685 - PARROQUIAL JAIME MOTA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 20. |                          00685 - PARROQUIAL JAIME MOTA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 21. |                          00685 - PARROQUIAL JAIME MOTA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 22. |                                   00686 - NUEVO JARDIN       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 23. |                                   00686 - NUEVO JARDIN       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 24. |                                   00686 - NUEVO JARDIN       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 25. |                                 00687 - CLUB DE LEONES       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 26. |                                 00687 - CLUB DE LEONES       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 27. |                                 00687 - CLUB DE LEONES       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 28. |                                 00688 - DIVINA PASTORA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 29. |                                 00688 - DIVINA PASTORA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 30. |                                 00688 - DIVINA PASTORA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 31. |                             00689 - ECONOMIA DOMESTICA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 32. |                             00689 - ECONOMIA DOMESTICA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 33. |                             00689 - ECONOMIA DOMESTICA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 34. |                                   00690 - LEONOR FELTZ       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 35. |                                   00690 - LEONOR FELTZ       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 36. |                                   00690 - LEONOR FELTZ       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 37. |                           00691 - ACADEMIA FRANCISCANA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 38. |                           00691 - ACADEMIA FRANCISCANA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 39. |                           00691 - ACADEMIA FRANCISCANA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 40. |                          00692 - ANAIMA TEJADA CHAPMAN       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 41. |                          00692 - ANAIMA TEJADA CHAPMAN       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 42. |                          00692 - ANAIMA TEJADA CHAPMAN       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 43. |                                 00693 - SAN JUAN BOSCO       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 44. |                                 00693 - SAN JUAN BOSCO       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 45. |                                 00693 - SAN JUAN BOSCO       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 46. |                                     00694 - TANQUE, EL       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 47. |                                     00694 - TANQUE, EL       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 48. |                                     00694 - TANQUE, EL       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 49. |               00696 - FIDEL MEDINA - REFUGIO EL CACHON       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 50. |               00696 - FIDEL MEDINA - REFUGIO EL CACHON       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 51. |               00696 - FIDEL MEDINA - REFUGIO EL CACHON       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 52. |        00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 53. |        00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 54. |        00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
 55. |                                    00698 - SANTA ELENA       A   01 BARAHONA     0103  BARAHONA        xxx      xxx        xxx |
 56. |                                    00698 - SANTA ELENA       B   01 BARAHONA     0103  BARAHONA        yyy      yyy        yyy |
 57. |                                    00698 - SANTA ELENA       C   01 BARAHONA     0103  BARAHONA        zzz      zzz        zzz |
    *BREAK
     |--------------------------------------------------------------------------------------------------------------------------------|
196. |                                    00787 - CAOBAS, LAS       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
197. |                                    00787 - CAOBAS, LAS       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
198. |                                    00787 - CAOBAS, LAS       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
199. |                                    00791 - GUAZUMA, LA       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
200. |                                    00791 - GUAZUMA, LA       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
201. |                                    00791 - GUAZUMA, LA       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
202. |                                     00801 - MANIEL, EL       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
203. |                                     00801 - MANIEL, EL       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
204. |                                     00801 - MANIEL, EL       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
205. |                                       00813 - RIO SITO       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
206. |                                       00813 - RIO SITO       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
207. |                                       00813 - RIO SITO       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
208. |                                          00814 - AUDON       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
209. |                                          00814 - AUDON       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
210. |                                          00814 - AUDON       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
211. |                                  00815 - CRESTELEANDRO       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
212. |                                  00815 - CRESTELEANDRO       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
213. |                                  00815 - CRESTELEANDRO       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
214. |                                      00816 - CANOA, LA       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
215. |                                      00816 - CANOA, LA       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
216. |                                      00816 - CANOA, LA       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
217. |                                       00817 - TORO, EL       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
218. |                                       00817 - TORO, EL       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
219. |                                       00817 - TORO, EL       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
220. |                                       00818 - PLAY, EL       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
221. |                                       00818 - PLAY, EL       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
222. |                                       00818 - PLAY, EL       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
223. |                                02334 - HERNANDO GORJON       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
224. |                                02334 - HERNANDO GORJON       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
225. |                                02334 - HERNANDO GORJON       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
226. |                             02335 - BIENVENIDO MORILLO       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
227. |                             02335 - BIENVENIDO MORILLO       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
228. |                             02335 - BIENVENIDO MORILLO       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
229. |                            02336 - BARRIO LAS MERCEDES       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
230. |                            02336 - BARRIO LAS MERCEDES       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
231. |                            02336 - BARRIO LAS MERCEDES       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
232. |                                  02337 - MERCEDES, LAS       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
233. |                                  02337 - MERCEDES, LAS       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
234. |                                  02337 - MERCEDES, LAS       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
235. |                                 02338 - COLONIA MENCIA       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
236. |                                 02338 - COLONIA MENCIA       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
237. |                                 02338 - COLONIA MENCIA       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
238. |                             02339 - ALTAGRACIA "A", LA       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
239. |                             02339 - ALTAGRACIA "A", LA       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
240. |                             02339 - ALTAGRACIA "A", LA       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
241. |                            02341 - COLONIA LOS ARROYOS       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
242. |                            02341 - COLONIA LOS ARROYOS       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
243. |                            02341 - COLONIA LOS ARROYOS       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
244. |                                          02342 - AVILA       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
245. |                                          02342 - AVILA       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
246. |                                          02342 - AVILA       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
247. |                                   02343 - AGUAS NEGRAS       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
248. |                                   02343 - AGUAS NEGRAS       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
249. |                                   02343 - AGUAS NEGRAS       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
250. |                                    02344 - HIGO GRANDE       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
251. |                                    02344 - HIGO GRANDE       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
252. |                                    02344 - HIGO GRANDE       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
253. |                        02345 - GASTON FERNANDO DELIGNE       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
254. |                        02345 - GASTON FERNANDO DELIGNE       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
255. |                        02345 - GASTON FERNANDO DELIGNE       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
256. |                                        02346 - BUCARAL       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
257. |                                        02346 - BUCARAL       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
258. |                                        02346 - BUCARAL       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
259. |                                02347 - COLONIA JUANCHO       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
260. |                                02347 - COLONIA JUANCHO       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
261. |                                02347 - COLONIA JUANCHO       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
262. |                                        02348 - JUANCHO       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
263. |                                        02348 - JUANCHO       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
264. |                                        02348 - JUANCHO       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
265. |                                     02350 - CAJUIL, EL       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
266. |                                     02350 - CAJUIL, EL       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
267. |                                     02350 - CAJUIL, EL       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
268. |                              02351 - TRES CHARCOS, LOS       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
269. |                              02351 - TRES CHARCOS, LOS       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
270. |                              02351 - TRES CHARCOS, LOS       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
271. |                                    02352 - MANUEL GOYA       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
272. |                                    02352 - MANUEL GOYA       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
273. |                                    02352 - MANUEL GOYA       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
274. |                                    02353 - SITIO NUEVO       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
275. |                                    02353 - SITIO NUEVO       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
276. |                                    02353 - SITIO NUEVO       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
277. |                                   10467 - BARRIO NUEVO       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
278. |                                   10467 - BARRIO NUEVO       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
279. |                                   10467 - BARRIO NUEVO       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
280. |                                         10552 - MENCIA       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
281. |                                         10552 - MENCIA       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
282. |                                         10552 - MENCIA       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
283. |                                     11166 - EL INGENIO       A   01 BARAHONA   0102  ENRIQUILLO        xxx      xxx        xxx |
284. |                                     11166 - EL INGENIO       B   01 BARAHONA   0102  ENRIQUILLO        yyy      yyy        yyy |
285. |                                     11166 - EL INGENIO       C   01 BARAHONA   0102  ENRIQUILLO        zzz      zzz        zzz |
     |--------------------------------------------------------------------------------------------------------------------------------|
286. |                       12097 - LUIS EMILIO PEREZ MENDEZ       A   01 BARAHONA   0101  PEDERNALES        xxx      xxx        xxx |
287. |                       12097 - LUIS EMILIO PEREZ MENDEZ       B   01 BARAHONA   0101  PEDERNALES        yyy      yyy        yyy |
288. |                       12097 - LUIS EMILIO PEREZ MENDEZ       C   01 BARAHONA   0101  PEDERNALES        zzz      zzz        zzz |
     +--------------------------------------------------------------------------------------------------------------------------------+

.

[Gabriela Santana Tavera]

Hello again Andrew,

I get a mistake on the sintax of rename

syntax error
    Syntax is
        rename  oldname    newname   [, renumber[(#)] addnumber[(#)] sort ...]
        rename (oldnames) (newnames) [, renumber[(#)] addnumber[(#)] sort ...]
        rename  oldnames              , {upper|lower|proper}
r(198);

When I try to run:
. foreach var of varlist B-E{
2. rename `var' `=lower(strtoname(`var'[1]))'
3. }

[Andrew Musau]

The code in #4 is based on the data example in #1. I suspect that observation 1 is empty in your real dataset, so rename encounters

rename B

instead of

rename B centros

You need to provide a dataex of your real dataset if you cannot amend the code provided.

dataex in 1/10

[Gabriela Santana Tavera]

Hello again Andrew,
here is the dataex. Thank you again for your time and help.

* Example generated by -dataex-. For more info, type help dataex
clear
input str27 B str36 C str78 D str12 E str8 F str2 G
"Direccion Regional" "Distrito Educativo" "Centros"                                                "Codigo Viejo" "Inicial"  "" 
""                   ""                   ""                                                       ""             "COMPLETA" "" 
""                   ""                   ""                                                       ""             "Maternal" "" 
""                   ""                   ""                                                       ""             "A"        "B"
"01 BARAHONA"        "0101  PEDERNALES"   "02334 - HERNANDO GORJON"                                "16000218"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02335 - BIENVENIDO MORILLO"                             "16000416"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02336 - BARRIO LAS MERCEDES"                            "16000812"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02337 - MERCEDES, LAS"                                  "16001015"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02338 - COLONIA MENCIA"                                 "16001119"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   `"02339 - ALTAGRACIA "A", LA"'                           "16001411"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02341 - COLONIA LOS ARROYOS"                            "16001713"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02342 - AVILA"                                          "16001911"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02343 - AGUAS NEGRAS"                                   "16002010"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02344 - HIGO GRANDE"                                    "16002218"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02345 - GASTON FERNANDO DELIGNE"                        "16002533"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02346 - BUCARAL"                                        "16002718"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02347 - COLONIA JUANCHO"                                "16002920"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02348 - JUANCHO"                                        "16003119"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02350 - CAJUIL, EL"                                     "16003411"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02351 - TRES CHARCOS, LOS"                              "16003515"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02352 - MANUEL GOYA"                                    "16003713"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "02353 - SITIO NUEVO"                                    "16004711"     ""         "" 
"01 BARAHONA"        "0101  PEDERNALES"   "12097 - LUIS EMILIO PEREZ MENDEZ"                       "16005216"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00711 - TATIANA RODRIGUEZ"                              "04010011"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00712 - ISMAEL MIRANDA"                                 "04010115"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00713 - MENCIA"                                         "04010511"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00714 - ARROYO DULCE"                                   "04010719"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00715 - NARANJAL"                                       "04010813"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00716 - HIGUERO, EL"                                    "04011016"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00719 - MALAGUETA, LA"                                  "04011318"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00720 - AQUILINA TURBI GOMEZ - BUENA VISTA"             "04011412"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00721 - DOMINGO MATOS FELIZ- JUAN ISIDRO"               "04011610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00722 - AUGUSTO FELIZ MATOS - LA TORRE"                 "04011725"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00723 - DORA CORCIA SANCHEZ SANCHEZ - LOS COCOS"        "04011818"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00724 - BLANCOS, LOS"                                   "04012219"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00725 - JOSE ANTONIO ALVAREZ - PALMARITO"               "04012511"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00726 - PEÑALVA"                                       "04012719"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00727 - CALETON"                                        "04012917"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00728 - MERCEDITAS, LAS"                                "04013110"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00729 - CHENE"                                          "04013318"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00730 - EDUARDO CUEVAS PEÑA - LA ISLETA"               "04013610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00731 - PINO ABAJO, EL"                                 "04013714"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00735 - CORTICO"                                        "04015318"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00736 - PLATON, EL"                                     "04015412"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00737 - CHARCO BLANCO"                                  "04015610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00738 - SAN RAFAEL"                                     "04015714"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00739 - WANDA MARTINA JIMENEZ - LA LANZA ABAJO"         "04016011"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00741 - LEONARDO"                                       "04016313"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00742 - MALANGA"                                        "04016511"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00743 - NUEVA ROSA-CACO"                                "04016719"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00744 - HORACIO CARRASCO LEGER- LA CAOBA"               "04016813"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00745 - ERANIO MATEO MEDINA - CHARCO PRIETO"            "04017016"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00746 - ANTONIO TORRE COLON - VILLA NIZAO"              "04017610"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00747 - CLARA ROSA PEREZ FELIZ - LOS PATOS"             "04017818"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00748 - EUGENIO MEDINA FELIZ - BEJUQUERO"               "04018011"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00749 - OCACIO SANTANA CARRASCO - OJEDA"                "04018219"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00787 - CAOBAS, LAS"                                    "04032317"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00791 - GUAZUMA, LA"                                    "04032911"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00801 - MANIEL, EL"                                     "04035918"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00813 - RIO SITO"                                       "04038619"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00814 - AUDON"                                          "04038718"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00815 - CRESTELEANDRO"                                  "04038916"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00816 - CANOA, LA"                                      "04039115"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00817 - TORO, EL"                                       "04040112"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "00818 - PLAY, EL"                                       "04040210"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "10467 - BARRIO NUEVO"                                   "04018417"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "10552 - MENCIA"                                         "04015016"     ""         "" 
"01 BARAHONA"        "0102  ENRIQUILLO"   "11166 - EL INGENIO"                                     "04038817"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00679 - BAITOITA"                                       "04000119"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00680 - CASANDRA DAMIRON"                               "04000321"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00681 - PARROQUIAL LA ALTAGRACIA"                       "04000515"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00682 - LIRIOS, LOS"                                    "04000619"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00683 - SANTO DOMINGO SAVIO"                            "04000911"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00684 - PARROQUIAL CRISTO REY"                          "04001510"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00685 - PARROQUIAL JAIME MOTA"                          "04002015"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00686 - NUEVO JARDIN"                                   "04002220"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00687 - CLUB DE LEONES"                                 "04002411"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00688 - DIVINA PASTORA"                                 "04003021"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00689 - ECONOMIA DOMESTICA"                             "04003114"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00690 - LEONOR FELTZ"                                   "04003312"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00691 - ACADEMIA FRANCISCANA"                           "04003614"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00692 - ANAIMA TEJADA CHAPMAN"                          "04003718"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00693 - SAN JUAN BOSCO"                                 "04005010"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00694 - TANQUE, EL"                                     "04005312"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00696 - FIDEL MEDINA - REFUGIO EL CACHON"               "04005718"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA"        "04006015"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00698 - SANTA ELENA"                                    "04006411"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00699 - MANANTIAL"                                      "04006619"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00700 - FILIPINAS, LAS"                                 "04006713"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00770 - MARINA SEPULVEDA"                               "04024111"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00771 - HILDA CELESTE RAMIREZ MATOS -  LOS  JAQUIMEYES" "04024715"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00772 - FIAMETA GARCIA FRANCO"                          "04025116"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00773 - JUAN PABLO DUARTE"                              "04025512"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00774 - AURA THERMA SUERO FELIZ - HABANERO"             "04025814"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00775 - HATO VIEJO"                                     "04026319"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00776 - LUIS FELIPE FELIZ Y FELIZ"                      "04026517"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00777 - CIENAGA - LEA M. MORETA, LA"                    "04026913"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00778 - ARROYO, EL"                                     "04027210"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00779 - BAHORUCO"                                       "04027814"     ""         "" 
"01 BARAHONA"        "0103  BARAHONA"     "00780 - AGUITA BLANCA"                                  "04028017"     ""         "" 
end

[Gabriela Santana Tavera]

Hello again,

I figured out my previous problem but now I think the issue is that the grades are not uniquely identified to reshape to long.
I have modified the code as follows.

foreach var of varlist B-E{
    rename `var' `=lower(strtoname(`var'[1]))'
}

local v
foreach var of varlist F-HR{
    if missing(`var'[3]){
        replace `var'= `v'[3] in 3
    }
    local v `var'
}

local v
foreach var of varlist F-HR{
    if missing(`var'[2]){
        replace `var'= `v'[2] in 2
    }
    local v `var'
}


local v
foreach var of varlist F-HR{
    if missing(`var'[1]){
        replace `var'= `v'[1] in 1
    }
    local v `var'
}

drop HS

drop in 1

The output now looks as follows:

CODE]
* Example generated by -dataex-. For more info, type help dataex
clear
input str27 direccion_regional str36 distrito_educativo str78 centros str12 codigo_viejo str8(F G H I J K L) str12(M N O) str8 P
"" "" "" "" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "COMPLETA" "MATUTINA"
"" "" "" "" "Maternal" "Maternal" "Maternal" "Kinder" "Kinder" "Kinder" "Kinder" "Pre-Primaria" "Pre-Primaria" "Pre-Primaria" "Maternal"
"" "" "" "" "A" "B" "C" "A" "B" "C" "D" "A" "B" "C" "A"
"01 BARAHONA" "0101 PEDERNALES" "02334 - HERNANDO GORJON" "16000218" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02335 - BIENVENIDO MORILLO" "16000416" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02336 - BARRIO LAS MERCEDES" "16000812" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02337 - MERCEDES, LAS" "16001015" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02338 - COLONIA MENCIA" "16001119" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" `"02339 - ALTAGRACIA "A", LA"' "16001411" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02341 - COLONIA LOS ARROYOS" "16001713" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02342 - AVILA" "16001911" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02343 - AGUAS NEGRAS" "16002010" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02344 - HIGO GRANDE" "16002218" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02345 - GASTON FERNANDO DELIGNE" "16002533" "" "" "" "" "" "" "" "" "" "" "1"
"01 BARAHONA" "0101 PEDERNALES" "02346 - BUCARAL" "16002718" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02347 - COLONIA JUANCHO" "16002920" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02348 - JUANCHO" "16003119" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02350 - CAJUIL, EL" "16003411" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02351 - TRES CHARCOS, LOS" "16003515" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02352 - MANUEL GOYA" "16003713" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "02353 - SITIO NUEVO" "16004711" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0101 PEDERNALES" "12097 - LUIS EMILIO PEREZ MENDEZ" "16005216" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00711 - TATIANA RODRIGUEZ" "04010011" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00712 - ISMAEL MIRANDA" "04010115" "" "" "" "" "" "" "" "37" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00713 - MENCIA" "04010511" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00714 - ARROYO DULCE" "04010719" "" "" "" "" "" "" "" "" "" "" "1"
"01 BARAHONA" "0102 ENRIQUILLO" "00715 - NARANJAL" "04010813" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00716 - HIGUERO, EL" "04011016" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00719 - MALAGUETA, LA" "04011318" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00720 - AQUILINA TURBI GOMEZ - BUENA VISTA" "04011412" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00721 - DOMINGO MATOS FELIZ- JUAN ISIDRO" "04011610" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00722 - AUGUSTO FELIZ MATOS - LA TORRE" "04011725" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00723 - DORA CORCIA SANCHEZ SANCHEZ - LOS COCOS" "04011818" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00724 - BLANCOS, LOS" "04012219" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00725 - JOSE ANTONIO ALVAREZ - PALMARITO" "04012511" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00726 - PEÑALVA" "04012719" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00727 - CALETON" "04012917" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00728 - MERCEDITAS, LAS" "04013110" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00729 - CHENE" "04013318" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00730 - EDUARDO CUEVAS PEÑA - LA ISLETA" "04013610" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00731 - PINO ABAJO, EL" "04013714" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00735 - CORTICO" "04015318" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00736 - PLATON, EL" "04015412" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00737 - CHARCO BLANCO" "04015610" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00738 - SAN RAFAEL" "04015714" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00739 - WANDA MARTINA JIMENEZ - LA LANZA ABAJO" "04016011" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00741 - LEONARDO" "04016313" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00742 - MALANGA" "04016511" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00743 - NUEVA ROSA-CACO" "04016719" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00744 - HORACIO CARRASCO LEGER- LA CAOBA" "04016813" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00745 - ERANIO MATEO MEDINA - CHARCO PRIETO" "04017016" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00746 - ANTONIO TORRE COLON - VILLA NIZAO" "04017610" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00747 - CLARA ROSA PEREZ FELIZ - LOS PATOS" "04017818" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00748 - EUGENIO MEDINA FELIZ - BEJUQUERO" "04018011" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00749 - OCACIO SANTANA CARRASCO - OJEDA" "04018219" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00787 - CAOBAS, LAS" "04032317" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00791 - GUAZUMA, LA" "04032911" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00801 - MANIEL, EL" "04035918" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00813 - RIO SITO" "04038619" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00814 - AUDON" "04038718" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00815 - CRESTELEANDRO" "04038916" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00816 - CANOA, LA" "04039115" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00817 - TORO, EL" "04040112" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "00818 - PLAY, EL" "04040210" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "10467 - BARRIO NUEVO" "04018417" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "10552 - MENCIA" "04015016" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0102 ENRIQUILLO" "11166 - EL INGENIO" "04038817" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00679 - BAITOITA" "04000119" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00680 - CASANDRA DAMIRON" "04000321" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00681 - PARROQUIAL LA ALTAGRACIA" "04000515" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00682 - LIRIOS, LOS" "04000619" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00683 - SANTO DOMINGO SAVIO" "04000911" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00684 - PARROQUIAL CRISTO REY" "04001510" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00685 - PARROQUIAL JAIME MOTA" "04002015" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00686 - NUEVO JARDIN" "04002220" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00687 - CLUB DE LEONES" "04002411" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00688 - DIVINA PASTORA" "04003021" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00689 - ECONOMIA DOMESTICA" "04003114" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00690 - LEONOR FELTZ" "04003312" "" "" "" "" "" "" "" "" "" "" "1"
"01 BARAHONA" "0103 BARAHONA" "00691 - ACADEMIA FRANCISCANA" "04003614" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00692 - ANAIMA TEJADA CHAPMAN" "04003718" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00693 - SAN JUAN BOSCO" "04005010" "" "" "" "" "" "" "" "24" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00694 - TANQUE, EL" "04005312" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00696 - FIDEL MEDINA - REFUGIO EL CACHON" "04005718" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00697 - FIDELINA FELIZ MATOS PROF. - LA GUAZARA" "04006015" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00698 - SANTA ELENA" "04006411" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00699 - MANANTIAL" "04006619" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00700 - FILIPINAS, LAS" "04006713" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00770 - MARINA SEPULVEDA" "04024111" "" "" "" "" "" "" "" "22" "7" "" ""
"01 BARAHONA" "0103 BARAHONA" "00771 - HILDA CELESTE RAMIREZ MATOS - LOS JAQUIMEYES" "04024715" "" "" "" "" "" "" "" "1" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00772 - FIAMETA GARCIA FRANCO" "04025116" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00773 - JUAN PABLO DUARTE" "04025512" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00774 - AURA THERMA SUERO FELIZ - HABANERO" "04025814" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00775 - HATO VIEJO" "04026319" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00776 - LUIS FELIPE FELIZ Y FELIZ" "04026517" "" "" "" "" "" "" "" "" "" "" "15"
"01 BARAHONA" "0103 BARAHONA" "00777 - CIENAGA - LEA M. MORETA, LA" "04026913" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00778 - ARROYO, EL" "04027210" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00779 - BAHORUCO" "04027814" "" "" "" "" "" "" "" "" "" "" "1"
"01 BARAHONA" "0103 BARAHONA" "00780 - AGUITA BLANCA" "04028017" "" "" "" "" "" "" "" "" "" "" ""
"01 BARAHONA" "0103 BARAHONA" "00781 - HELECHOS, LOS" "04028215" "" "" "" "" "" "" "" "" "" "" ""
end
[/CODE]

[Andrew Musau]

If I add to the data in #9

foreach var of varlist F-P{
    rename `var' `=substr(`var'[1], 1, 3)'_`=lower(strtoname(`var'[2]))'`=`var'[3]'
}
drop in 1/3
reshape long COM MAT, i(centros) j(which) string
replace which= substr(which, 2,.)

I get:

Res.:

. l in 1/50, sep(0)

     +-------------------------------------------------------------------------------------------------------+
     |                          centros           which   direccion~l   distrito_ed~o   codigo~o   COM   MAT |
     |-------------------------------------------------------------------------------------------------------|
  1. |                 00679 - BAITOITA         kinderA   01 BARAHONA   0103 BARAHONA   04000119             |
  2. |                 00679 - BAITOITA         kinderB   01 BARAHONA   0103 BARAHONA   04000119             |
  3. |                 00679 - BAITOITA         kinderC   01 BARAHONA   0103 BARAHONA   04000119             |
  4. |                 00679 - BAITOITA         kinderD   01 BARAHONA   0103 BARAHONA   04000119             |
  5. |                 00679 - BAITOITA       maternalA   01 BARAHONA   0103 BARAHONA   04000119             |
  6. |                 00679 - BAITOITA       maternalB   01 BARAHONA   0103 BARAHONA   04000119             |
  7. |                 00679 - BAITOITA       maternalC   01 BARAHONA   0103 BARAHONA   04000119             |
  8. |                 00679 - BAITOITA   pre_primariaA   01 BARAHONA   0103 BARAHONA   04000119             |
  9. |                 00679 - BAITOITA   pre_primariaB   01 BARAHONA   0103 BARAHONA   04000119             |
 10. |                 00679 - BAITOITA   pre_primariaC   01 BARAHONA   0103 BARAHONA   04000119             |
 11. |         00680 - CASANDRA DAMIRON         kinderA   01 BARAHONA   0103 BARAHONA   04000321             |
 12. |         00680 - CASANDRA DAMIRON         kinderB   01 BARAHONA   0103 BARAHONA   04000321             |
 13. |         00680 - CASANDRA DAMIRON         kinderC   01 BARAHONA   0103 BARAHONA   04000321             |
 14. |         00680 - CASANDRA DAMIRON         kinderD   01 BARAHONA   0103 BARAHONA   04000321             |
 15. |         00680 - CASANDRA DAMIRON       maternalA   01 BARAHONA   0103 BARAHONA   04000321             |
 16. |         00680 - CASANDRA DAMIRON       maternalB   01 BARAHONA   0103 BARAHONA   04000321             |
 17. |         00680 - CASANDRA DAMIRON       maternalC   01 BARAHONA   0103 BARAHONA   04000321             |
 18. |         00680 - CASANDRA DAMIRON   pre_primariaA   01 BARAHONA   0103 BARAHONA   04000321             |
 19. |         00680 - CASANDRA DAMIRON   pre_primariaB   01 BARAHONA   0103 BARAHONA   04000321             |
 20. |         00680 - CASANDRA DAMIRON   pre_primariaC   01 BARAHONA   0103 BARAHONA   04000321             |
 21. | 00681 - PARROQUIAL LA ALTAGRACIA         kinderA   01 BARAHONA   0103 BARAHONA   04000515             |
 22. | 00681 - PARROQUIAL LA ALTAGRACIA         kinderB   01 BARAHONA   0103 BARAHONA   04000515             |
 23. | 00681 - PARROQUIAL LA ALTAGRACIA         kinderC   01 BARAHONA   0103 BARAHONA   04000515             |
 24. | 00681 - PARROQUIAL LA ALTAGRACIA         kinderD   01 BARAHONA   0103 BARAHONA   04000515             |
 25. | 00681 - PARROQUIAL LA ALTAGRACIA       maternalA   01 BARAHONA   0103 BARAHONA   04000515             |
 26. | 00681 - PARROQUIAL LA ALTAGRACIA       maternalB   01 BARAHONA   0103 BARAHONA   04000515             |
 27. | 00681 - PARROQUIAL LA ALTAGRACIA       maternalC   01 BARAHONA   0103 BARAHONA   04000515             |
 28. | 00681 - PARROQUIAL LA ALTAGRACIA   pre_primariaA   01 BARAHONA   0103 BARAHONA   04000515             |
 29. | 00681 - PARROQUIAL LA ALTAGRACIA   pre_primariaB   01 BARAHONA   0103 BARAHONA   04000515             |
 30. | 00681 - PARROQUIAL LA ALTAGRACIA   pre_primariaC   01 BARAHONA   0103 BARAHONA   04000515             |
 31. |              00682 - LIRIOS, LOS         kinderA   01 BARAHONA   0103 BARAHONA   04000619             |
 32. |              00682 - LIRIOS, LOS         kinderB   01 BARAHONA   0103 BARAHONA   04000619             |
 33. |              00682 - LIRIOS, LOS         kinderC   01 BARAHONA   0103 BARAHONA   04000619             |
 34. |              00682 - LIRIOS, LOS         kinderD   01 BARAHONA   0103 BARAHONA   04000619             |
 35. |              00682 - LIRIOS, LOS       maternalA   01 BARAHONA   0103 BARAHONA   04000619             |
 36. |              00682 - LIRIOS, LOS       maternalB   01 BARAHONA   0103 BARAHONA   04000619             |
 37. |              00682 - LIRIOS, LOS       maternalC   01 BARAHONA   0103 BARAHONA   04000619             |
 38. |              00682 - LIRIOS, LOS   pre_primariaA   01 BARAHONA   0103 BARAHONA   04000619             |
 39. |              00682 - LIRIOS, LOS   pre_primariaB   01 BARAHONA   0103 BARAHONA   04000619             |
 40. |              00682 - LIRIOS, LOS   pre_primariaC   01 BARAHONA   0103 BARAHONA   04000619             |
 41. |      00683 - SANTO DOMINGO SAVIO         kinderA   01 BARAHONA   0103 BARAHONA   04000911             |
 42. |      00683 - SANTO DOMINGO SAVIO         kinderB   01 BARAHONA   0103 BARAHONA   04000911             |
 43. |      00683 - SANTO DOMINGO SAVIO         kinderC   01 BARAHONA   0103 BARAHONA   04000911             |
 44. |      00683 - SANTO DOMINGO SAVIO         kinderD   01 BARAHONA   0103 BARAHONA   04000911             |
 45. |      00683 - SANTO DOMINGO SAVIO       maternalA   01 BARAHONA   0103 BARAHONA   04000911             |
 46. |      00683 - SANTO DOMINGO SAVIO       maternalB   01 BARAHONA   0103 BARAHONA   04000911             |
 47. |      00683 - SANTO DOMINGO SAVIO       maternalC   01 BARAHONA   0103 BARAHONA   04000911             |
 48. |      00683 - SANTO DOMINGO SAVIO   pre_primariaA   01 BARAHONA   0103 BARAHONA   04000911             |
 49. |      00683 - SANTO DOMINGO SAVIO   pre_primariaB   01 BARAHONA   0103 BARAHONA   04000911             |
 50. |      00683 - SANTO DOMINGO SAVIO   pre_primariaC   01 BARAHONA   0103 BARAHONA   04000911             |
     +-------------------------------------------------------------------------------------------------------+

. l in -50/l, sep(0)

     +---------------------------------------------------------------------------------------------------------+
     |                          centros           which   direccion~l   distrito_educ~o   codigo~o   COM   MAT |
     |---------------------------------------------------------------------------------------------------------|
921. |              02353 - SITIO NUEVO         kinderA   01 BARAHONA   0101 PEDERNALES   16004711             |
922. |              02353 - SITIO NUEVO         kinderB   01 BARAHONA   0101 PEDERNALES   16004711             |
923. |              02353 - SITIO NUEVO         kinderC   01 BARAHONA   0101 PEDERNALES   16004711             |
924. |              02353 - SITIO NUEVO         kinderD   01 BARAHONA   0101 PEDERNALES   16004711             |
925. |              02353 - SITIO NUEVO       maternalA   01 BARAHONA   0101 PEDERNALES   16004711             |
926. |              02353 - SITIO NUEVO       maternalB   01 BARAHONA   0101 PEDERNALES   16004711             |
927. |              02353 - SITIO NUEVO       maternalC   01 BARAHONA   0101 PEDERNALES   16004711             |
928. |              02353 - SITIO NUEVO   pre_primariaA   01 BARAHONA   0101 PEDERNALES   16004711             |
929. |              02353 - SITIO NUEVO   pre_primariaB   01 BARAHONA   0101 PEDERNALES   16004711             |
930. |              02353 - SITIO NUEVO   pre_primariaC   01 BARAHONA   0101 PEDERNALES   16004711             |
931. |             10467 - BARRIO NUEVO         kinderA   01 BARAHONA   0102 ENRIQUILLO   04018417             |
932. |             10467 - BARRIO NUEVO         kinderB   01 BARAHONA   0102 ENRIQUILLO   04018417             |
933. |             10467 - BARRIO NUEVO         kinderC   01 BARAHONA   0102 ENRIQUILLO   04018417             |
934. |             10467 - BARRIO NUEVO         kinderD   01 BARAHONA   0102 ENRIQUILLO   04018417             |
935. |             10467 - BARRIO NUEVO       maternalA   01 BARAHONA   0102 ENRIQUILLO   04018417             |
936. |             10467 - BARRIO NUEVO       maternalB   01 BARAHONA   0102 ENRIQUILLO   04018417             |
937. |             10467 - BARRIO NUEVO       maternalC   01 BARAHONA   0102 ENRIQUILLO   04018417             |
938. |             10467 - BARRIO NUEVO   pre_primariaA   01 BARAHONA   0102 ENRIQUILLO   04018417             |
939. |             10467 - BARRIO NUEVO   pre_primariaB   01 BARAHONA   0102 ENRIQUILLO   04018417             |
940. |             10467 - BARRIO NUEVO   pre_primariaC   01 BARAHONA   0102 ENRIQUILLO   04018417             |
941. |                   10552 - MENCIA         kinderA   01 BARAHONA   0102 ENRIQUILLO   04015016             |
942. |                   10552 - MENCIA         kinderB   01 BARAHONA   0102 ENRIQUILLO   04015016             |
943. |                   10552 - MENCIA         kinderC   01 BARAHONA   0102 ENRIQUILLO   04015016             |
944. |                   10552 - MENCIA         kinderD   01 BARAHONA   0102 ENRIQUILLO   04015016             |
945. |                   10552 - MENCIA       maternalA   01 BARAHONA   0102 ENRIQUILLO   04015016             |
946. |                   10552 - MENCIA       maternalB   01 BARAHONA   0102 ENRIQUILLO   04015016             |
947. |                   10552 - MENCIA       maternalC   01 BARAHONA   0102 ENRIQUILLO   04015016             |
948. |                   10552 - MENCIA   pre_primariaA   01 BARAHONA   0102 ENRIQUILLO   04015016             |
949. |                   10552 - MENCIA   pre_primariaB   01 BARAHONA   0102 ENRIQUILLO   04015016             |
950. |                   10552 - MENCIA   pre_primariaC   01 BARAHONA   0102 ENRIQUILLO   04015016             |
951. |               11166 - EL INGENIO         kinderA   01 BARAHONA   0102 ENRIQUILLO   04038817             |
952. |               11166 - EL INGENIO         kinderB   01 BARAHONA   0102 ENRIQUILLO   04038817             |
953. |               11166 - EL INGENIO         kinderC   01 BARAHONA   0102 ENRIQUILLO   04038817             |
954. |               11166 - EL INGENIO         kinderD   01 BARAHONA   0102 ENRIQUILLO   04038817             |
955. |               11166 - EL INGENIO       maternalA   01 BARAHONA   0102 ENRIQUILLO   04038817             |
956. |               11166 - EL INGENIO       maternalB   01 BARAHONA   0102 ENRIQUILLO   04038817             |
957. |               11166 - EL INGENIO       maternalC   01 BARAHONA   0102 ENRIQUILLO   04038817             |
958. |               11166 - EL INGENIO   pre_primariaA   01 BARAHONA   0102 ENRIQUILLO   04038817             |
959. |               11166 - EL INGENIO   pre_primariaB   01 BARAHONA   0102 ENRIQUILLO   04038817             |
960. |               11166 - EL INGENIO   pre_primariaC   01 BARAHONA   0102 ENRIQUILLO   04038817             |
961. | 12097 - LUIS EMILIO PEREZ MENDEZ         kinderA   01 BARAHONA   0101 PEDERNALES   16005216             |
962. | 12097 - LUIS EMILIO PEREZ MENDEZ         kinderB   01 BARAHONA   0101 PEDERNALES   16005216             |
963. | 12097 - LUIS EMILIO PEREZ MENDEZ         kinderC   01 BARAHONA   0101 PEDERNALES   16005216             |
964. | 12097 - LUIS EMILIO PEREZ MENDEZ         kinderD   01 BARAHONA   0101 PEDERNALES   16005216             |
965. | 12097 - LUIS EMILIO PEREZ MENDEZ       maternalA   01 BARAHONA   0101 PEDERNALES   16005216             |
966. | 12097 - LUIS EMILIO PEREZ MENDEZ       maternalB   01 BARAHONA   0101 PEDERNALES   16005216             |
967. | 12097 - LUIS EMILIO PEREZ MENDEZ       maternalC   01 BARAHONA   0101 PEDERNALES   16005216             |
968. | 12097 - LUIS EMILIO PEREZ MENDEZ   pre_primariaA   01 BARAHONA   0101 PEDERNALES   16005216             |
969. | 12097 - LUIS EMILIO PEREZ MENDEZ   pre_primariaB   01 BARAHONA   0101 PEDERNALES   16005216             |
970. | 12097 - LUIS EMILIO PEREZ MENDEZ   pre_primariaC   01 BARAHONA   0101 PEDERNALES   16005216             |
     +---------------------------------------------------------------------------------------------------------+

.

[Gabriela Santana Tavera]

Thank you Andrew it worked wonderfully!