Splitting data frames by value of a variable

[Adrienne Wold]

Hello,

I have a dataset that has 142 unique values of a variable (ea), and I want to split my dataset to be able to export an excel sheet with the observations for each ea. The values of ea are numerical but not ordered, thus I am not using a forvalues loop. Is there another way to save or drop the individual datasets to be able to export?

Here is an example of the structure of the data:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str19 sup_new int ea str33 quartiers_villages int Nbredemenage float nbre_long str9 hhid float long_entretien str1(status date irrigation)
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-021" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-046" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-031" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-016" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-025" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-068" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-061" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-019" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-074" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-052" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-042" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-023" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-044" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-056" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-048" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-050" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-014" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-039" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-018" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-035" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-004" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-059" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-043" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-051" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-029" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-071" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-034" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-027" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-009" 1 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-060" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-020" 0 "" "" ""
"amadou_dia"  45 "SYLLA WORGO" 70 33 "00045-063" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-033" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-020" 0 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-003" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-036" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-010" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-025" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-026" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-006" 0 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-038" 0 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-034" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-030" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-024" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-047" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-046" 0 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-044" 0 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-018" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-011" 1 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-008" 0 "" "" ""
"harouna_sy" 122 "THIAGAL"     46 22 "00122-014" 1 "" "" ""
end

[Rich Goldstein]

h levelsof

in particular, see the example at the bottom of the help file that puts the results of the above command in a local and then uses -foreach- to loop thru the values