Querying a students ethnicity can be tricky. Aeries can hold multiple Race Categories per student (STU.RC1, STU.RC2, STU.RC3, etc.) . They are also over taken by STU.ETH. If a parent states they are Hispanic (STU.ETH = "Y") then no matter what they use in STU.RC1, they are marked as Hispanic. This means that using STU.RC1? may not yield the correct Ethnicity. The query below helps with these problems.
LIST STU ID NM ETH RC1 RC2 (( IIF ( ETH = "Y", "HISPANIC", IIF ( RC1/100 = 1 and RC2 = " ", "NATIVE AMERICAN", IIF ( RC1/100 = 2 and RC2 = " ", "ASIAN", IIF ( RC1/100 = 3 and RC2 = " ", "PACIFIC ISLANDER", IIF ( RC1/100 = 4 and RC2 = " ", "FILIPINO", IIF ( RC1/100 = 6 and RC2 = " ", "AFRICAN AMERICAN", IIF ( RC1/100 = 7 and RC2 = " ", "WHITE", IIF ( RC2/100 > 0, "TWO OR MORE RACES", "X" ) ) ) ) ) ) ) ) ))