I wish to transform the first table (below) into the second table -- a simplified example of a more complex Data file. I attempted to use syntax select-if the break the file into distinct ethnic and gender groups to no avail. Is this a transposition or restructure problem? Help.
|
Raw Enrollment |
|
|
|
|
|
|
|
|
|
| School |
Ethnics |
Gender |
Enroll1 |
Enroll2 |
Total |
|
|
|
|
|
|
| Madison High |
Hispanic |
Female |
10 |
15 |
25 |
| Madison High |
Hispanic |
Male |
20 |
10 |
30 |
| Madison High |
Asian |
Female |
5 |
7 |
12 |
| Madison High |
Asian |
Male |
5 |
7 |
12 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Transformed Enrollment |
|
|
|
|
|
|
|
|
|
|
|
Enrollments |
|
|
|
Hispanic |
Hispanic |
Asian |
Asian |
Total |
| School |
Enrolll1 |
Enroll2 |
Enroll1 |
Enroll2 |
|
|
(M + F) |
(M + F) |
(M + F) |
(M + F) |
|
|
|
|
|
|
|
| Madison High |
30 |
25 |
10 |
14 |
79 |
------------------------------
Benjamin Bowser
------------------------------