Status for Inclusion in Analysis Sample Code

Note: This page is from an older version of the Data Dictionary and may therefore contain information that is now out of date. It is included here for reference only.

1 The following pseudo code and SPSS code is provided to illustrate the Status for Inclusion in Analysis data definition.

2 The following table shows the steps required to derive A_LIVE_B

Step	Condition	Action if true	Action if false
1	Is the collection ACL	Go To 3	Go To 2
2	Does A17 = 6	Set A_LIVE_B to 0	Go To 3
3	Does PRD_ACT=0 AND PRD_EXP >= 1	Set A_LIVE_B to 1	Go To 4
4	Does PRD_ACT >= 1 AND PRD_EXP=0	Set A_LIVE_B to 2	Go To 5
5	Does PRD_ACT >= 1 AND PRD_EXP >= 1	Set A_LIVE_B to 3	Go To 6
6	Does (PRD_ACT=0 AND PRD_EXP=0) A_LIVE_B	Set A_LIVE_B to 0

3 The following SPSS code illustrates how to derive A_LIVE_B.

A_LIVE_B

/* Create a variable A_LIVE_B which staets whether the aim was actual/expected in this academic year.
/* if aim is absent for the year set status to not included. Then for others look at expected
/* and actual periods in this academic year to determine its status.
/* There are two similar routines, one for FE and Ufi and one for ACL, the FE and UfI return classify according to the variable A17, which is not collected for ACL.
/* Firstly look at collections that aren’t ACL, i.e. FE and UfI. 
/* Excludes aims where the delivery mode of attendance is marked as being absent for the year, they will remain with a value of 0. 
/* If the total actual terms are zero and the total expected terms are one or more for the current academic year then the aims was expected to be there
/* If the total actual terms are one or more and the total expected terms are zero for the current academic year then the learner was actually there but not expected to be 
/* If the total actual terms are one or more and the total expected terms are one or more for the current academic year then the aims was expected to be and was actually there
/* If the total actual terms are zero and the total expected terms are zero for the current academic year then the aims was not there
/* The same categorisation approach is used for ACL, except for the exclusion on A17, as this is not collected for ACL.
COMPUTE A_LIVE_B=0.
DO IF UPCASE(SUBSTR(COLLECTION,1,1)) NE 'C'.
 DO IF A17 NE 6.
  IF (PRD_ACT=0 AND PRD_EXP >= 1) A_LIVE_B=1.
  IF (PRD_ACT >= 1 AND PRD_EXP=0) A_LIVE_B=2.
  IF (PRD_ACT >= 1 AND PRD_EXP >= 1) A_LIVE_B=3.
  IF (PRD_ACT=0 AND PRD_EXP=0) A_LIVE_B=0.
 END IF.
ELSE IF UPCASE(SUBSTR(COLLECTION,1,1))='C'.
 IF (PRD_ACT=0 AND PRD_EXP >= 1) A_LIVE_B=1.
 IF (PRD_ACT >= 1 AND PRD_EXP=0) A_LIVE_B=2.
 IF (PRD_ACT >= 1 AND PRD_EXP >= 1) A_LIVE_B=3.
 IF (PRD_ACT=0 AND PRD_EXP=0) A_LIVE_B=0.
END IF.

VARIABLE LABELS A_LIVE_B ‘DV - Status of aim for inclusion in analysis’.
VALUE LABELS A_LIVE_B 
 0 'not included'
 1 'included on expected'
 2 'included on actual'
 3 'always included'.

L_LIVE_B

4 The following table shows the steps required to derive L_LIVE_B

Step	Condition	Action if true	Action if false
1	Does any A_LIVE_B=0	Set L_LIVE_B to 0, Go To 2	Go To 2
2	Does any A_LIVE_B=1	Set L_LIVE_B to 1, Go To 3	Go To 3
3	Does any A_LIVE_B=2	Set L_LIVE_B to 2, Go To 4	Go To 4
4	Does any A_LIVE_B=3	Set L_LIVE_B to 3, Go To 4	Go To 5

5 The following SPSS code illustrates how to derive L_LIVE_B.

/* Convert any missing values of A_LIVE_B to 0.
RECODE A_LIVE_B (SYSMIS=0).
SORT CASES L01 L03.

/* Exclude those aims which are not included for analytical purposes and aggregate individual aim records up to learner level. 
SELECT IF (A_LIVE_B > 0).
AGGREGATE OUTFILE=*
 /BREAK=L01 L03
 /L_LIVE_B=MAX(A_LIVE_B).

Creator	Analysis and MI Team
Date issued	25 January 2006
Date created	21 December 2005
Document ref.	\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-statusforinclusioninanalysissamplecode-report-25jan2006.doc
LSC office	Learning and Skills Council Cheylesmore House Quinton Road Coventry CV1 2WT T 0845 019 4170 F 024 7682 3675 www.lsc.gov.uk/

Last Modified: 27 Jan 06