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 at the school "HERNANDO GORJON".
Thank you for your help.
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 at the school "HERNANDO GORJON".
Thank you for your help.
Code:
* 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
