MATCH FILES
   /FILE = ……’Aims file’
   /TABLE = …….’Learner file’
   /BY l01 l03.

*/Select the Programme aim or where the Programme type is ‘None of the above’.
SELECT IF (A04=35 or A15=99) and A_ACTIVE=1.

*/Aggregate out to learner level by Programme type, to obtain whether the learner was in learning in that period for that Programme.

AGGREGATE OUTFILE= *
   MODE=ADDVARIABLE
   /BREAK= l01 l03 A15
   /p_il_p1 to p_il_p12=MAX(a_il_p1 to a_il_p12).

/* Aggregates out to get the number of times the learner was counted as in learning in that period.

AGGREGATE OUTFILE= *
   MODE=ADDVARIABLE
   /BREAK=l01 l03
   /Num_Prog_IL_p1 to Num_Prog_ IL_p12=SUM(p_il_p1 to p_il_p12).

Save outfile ‘…….\programme average in learning.sav’.

MATCH FILE /FIL= ‘..AIMS.SAV’
   /TABLE=‘…….\programme average in learning.sav’
   /BY L01 L03.

*/If the learner is inlearning for Period 1,
AVIL_P1 is Programme aims inlearning for period 1/Learner No of Programmes in learning period 1.
DO IF A_IL_p1>0.
COMPUTE AVIL_p1=A_IL_p1/ Num_Prog_IL_p1.
END IF.

*/If the learner is inlearning for Period 2,
AVIL_P2 is Programme aims inlearning for period 2/Learner No of Programmes in learning period 2.
DO IF A_IL_p2>0.
COMPUTE AVIL_p2=A_IL_p2/ Num_Prog_IL_p2.
END IF.

*/If the learner is inlearning for Period 3,
AVIL_P3 is Programme aims inlearning for period 3/Learner No of Programmes in learning period 3.
DO IF A_IL_p3>0.
COMPUTE AVIL_p3=A_IL_p3/ Num_Prog_IL _p3.
END IF.

*/If the learner is inlearning for Period 4,
AVIL_P4 is Programme aims inlearning for period 4/Learner No of Programmes in learning period 4.
DO IF A_IL_p4>0.
COMPUTE AVIL_p4=A_IL_p4/ Num_Prog_IL_p4.
END IF.

*/If the learner is inlearning for Period 5,
AVIL_P5 is Programme aims inlearning for period 5/Learner No of Programmes in learning period 5.
DO IF A_IL_p5>0.
COMPUTE AVIL_p5=A_IL_p5/ Num_Prog_IL_p5.
END IF.

*/If the learner is inlearning for Period 6,
AVIL_P6 is Programme aims inlearning for period 6/Learner No of Programmes in learning period 6.
DO IF A_IL_p6>0.
COMPUTE AVIL_p6=A_IL_p6/ Num_Prog_IL_p6.
END IF.

*/If the learner is inlearning for Period 7,
AVIL_P7 is Programme aims inlearning for period 7/Learner No of Programmes in learning period 7.
DO IF A_IL_p7>0.
COMPUTE AVIL_p7=A_IL_p7/ Num_Prog_IL_p7.
END IF.

*/If the learner is inlearning for Period 8,
AVIL_P8 is Programme aims inlearning for period 8/Learner No of Programmes in learning period 8.
DO IF A_IL_p8>0.
COMPUTE AVIL_p8=A_IL_p8/ Num_Prog_IL_p8.
END IF.

*/If the learner is inlearning for Period 9,
AVIL_P9 is Programme aims inlearning for period 9/Learner No of Programmes in learning period 9.
DO IF A_IL_p9>0.
COMPUTE AVIL_p9=A_IL_p9/ Num_Prog_IL_p9.
END IF.

*/If the learner is inlearning for Period 10,
AVIL_P10 is Programme aims inlearning for period 10/Learner No of Programmes in learning period 10.
DO IF A_IL_p10>0.
COMPUTE AVIL_p10=A_IL_p10/ Num_Prog_IL_p10.
END IF.

*/If the learner is inlearning for Period 11,
AVIL_P11 is Programme aims inlearning for period 11/Learner No of Programmes in learning period 11.
DO IF A_IL_p11>0.
COMPUTE AVIL_p11=A_IL_p11/ Num_Prog_IL_p11.
END IF.

*/If the learner is inlearning for Period 12,
AVIL_P12 is Programme aims inlearning for period 12/Learner No of Programmes in learning period 12.
DO IF A_IL_p12>0.
COMPUTE AVIL_p12=A_IL_p12/ Num_Prog_IL_p12.
END IF.

/* Sums the average in learning to arrive at a year to date figure.
/*P_AVIL.
RECODE avil_p1 TO avil_p12 (SYSMIS=0).
COMPUTE P_AVILY2D =SUM(avil_p1 TO avil_p12).
COMPUTE P_AVIL = P_AVILY2D/period.