Looks like the first three variables generate 4*3*2=24 combinations, one per row in the file.
And the last two variables generate 2*3=6 combinations, one per each value in a row.
Why not just let the DO loop take care of the values.
Looks like the values are in this order. But perhaps you will need to reorder the DO statements to match the pattern used to create the source data file.
data Project2;
length district $20 race $1 gender $1 learntype $10 level $10;
do district='OKEECHOBEE','SEMINOLE','VOLUSIA','WALTON';
do race = 'B','W','O';
do gender='M','F' ;
do learntype= 'Passive','Active';
do level= 'Elementary','Middle','High';
input absenses @ ;
output;
end;
end;
end;
end;
end;
datalines;
100 300 1600 750 250 700
150 1150 2350 450 550 850
3350 850 1800 750 600 150
1250 350 700 400 1650 700
1650 700 1150 850 250 1100
200 1600 3700 450 600 750
3800 650 1750 700 550 250
1050 400 650 350 2200 1050
1550 750 1100 900 600 1250
250 1650 2700 450 650 450
2800 1150 1550 650 800 300
600 450 1150 450 2050 1100
350 350 1650 650 200 750
100 950 1350 500 600 900
1700 550 1550 850 750 50
1200 300 850 200 1600 750
1600 3700 10 400 350 2000
335 1750 1550 2100 700 100
480 650 550 650 1600 800
220 1100 950 1600 650 50
1640 2700 500 450 400 1450
1185 1550 1900 2150 750 50
100 300 1600 750 250 700
150 1150 2350 450 550 850
;
Obs district race gender learntype level absenses
1 OKEECHOBEE B M Passive Elementary 100
2 OKEECHOBEE B M Passive Middle 300
3 OKEECHOBEE B M Passive High 1600
4 OKEECHOBEE B M Active Elementary 750
5 OKEECHOBEE B M Active Middle 250
6 OKEECHOBEE B M Active High 700
7 OKEECHOBEE B F Passive Elementary 150
... View more
