SORT CASES BY SEX RACE. SPLIT FILE BY SEX. FREQUENCIES VARS=INCOME /STATISTICS=MEDIAN. SPLIT FILE BY SEX RACE. FREQUENCIES VARS=INCOME /STATISTICS=MEDIAN. • The first SPLIT FILE command applies to the first FREQUENCIES procedure. The second SPLIT FILE command overrides the first and splits the file by sex and race. This split is in effect for the second FREQUENCIES procedure.