Active on Census Date 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 Active on Census Date data definition

A_OCT

2 The following table shows the steps required to derive A_OCT

Step

Condition

Action if true

Action if false

1

A27=1 October current academic year

set A_OCT to 1

Go To 2

2

A27 < 1 October relevant academic year and A31>1 October relevant academic year

set A_OCT to 1

Go To 3

3

A27< 1 October relevant academic year and A28 >= 1 October current academic year and no date in A31

set A_OCT to 1

Go To 4

4

A27< 1 October relevant academic year and A28 < 1 August current academic year and no date in A31

set A_OCT to 1

Go To 5

5

A27< 1 October relevant academic year, no date in A28, no date in A31 and A34 is either missing or = 1

set A_OCT to 1

3 The following SPSS code illustrates how to derive A_OCT

COMPUTE A_OCT=0.

/* If course starts on 1/10, then a_oct=1.
IF A27 = DATE.DMY(1,10,relevant academic year) A_OCT =1.
/* If course starts before 1/10 and finishes after 1/10, then a_oct=1.
IF A27 < DATE.DMY(1,10,relevant academic year) AND a31 >= DATE.DMY(1,10,relevant academic year) A_OCT =1.

/* If course starts before 1/10 and is expected to finish after 1/10 OR
/* If the course has an expected date of before 1/8 but the actual
/* enddate is blank, then a_oct=1.
IF A27 < DATE.DMY(1,10,relevant academic year) AND (A28 >= DATE.DMY(1,10,relevant academic year) OR A28 < DATE.DMY(1,8,relevant academic year) ) AND MISSING(A31) A_OCT =1.

/* If course starts before 1/10, there is no expected or actual enddate
/* and a34=1 or missing, then a_oct=1.
IF ( A27 < DATE.DMY(1,10,relevant academic year) AND MISSING(A31) AND MISSING(A28) AND (A34=1 OR MISSING(A34))) A_OCT =1.

VARIABLE LABELS A_OCT 'DV - Qualification active on 1 October in this year'.

VALUE LABELS A_OCT
0 'Not active on 1 October'
1 'Active on 1 October'.

L_OCT

4 The following table shows the steps required to derive L_OCT

Step

Condition

Action if true

Action if false

1

Is Collection=WBL or ESF SR

Go to 3

Go to 2

2

Is A_LIVE_B>1

Go to 3

Stop

3

Is any A_OCT=1

Set L_OCT to 1

Set L_OCT to 0

5 The following SPSS code illustrates how to derive L_OCT

/* sort cases according to variables to be used in aggregate.
SORT CASES L01 L03 A_OCT

/* A temporary select is made on all learners who are active according to the October Census date.
/* Aggregation is to learner level to obtain the maximum of a_oct. i.e where it equals 1.
TEMPORARY.
SELECT IF A_LIVE_B > 1.
AGGREGATE OUTFILE=*
 /PRESORTED
 /BREAK=L01 L03
 /L_OCT 'DV - Learner was active on 1 Oct in this year'=max(A_OCT).

A_NOV

6 The following table shows the steps required to derive A_NOV

Step

Condition

Action if true

Action if false

1

A27=1 November relevant academic year

set A_NOV to 1

Go To 2

2

A27 < 1 November relevant academic year and A31>1 November relevant academic year

set A_NOV to 1

Go To 3

3

A27< 1 November relevant academic year and A28 >= 1 November relevant academic year and no date in A31

set A_NOV to 1

Go To 4

4

A27< 1 November relevant academic year and A28 < 1 August relevant academic year and no date in A31

set A_NOV to 1

Go To 5

5

A27< 1 November relevant academic year, no date in A28, no date in A31 and A34 is either missing or = 1

set A_NOV to 1

7 The following SPSS code illustrates how to derive A_NOV

COMPUTE A_NOV=0.

/* If course starts on 1/11, then A_NOV=1.
IF A27 = DATE.DMY(1,11,relevant academic year) A_NOV =1.

/* If course starts before 1/11 and finishes after 1/11, then A_NOV=1.
IF A27 < DATE.DMY(1,11,relevant academic year) AND A31 >= DATE.DMY(1,11,relevant academic year) A_NOV =1.

/* If course starts before 1/11 and is expected to finish after 1/11 OR
/* If the course has an expected date of before 1/8 but the actual
/* enddate is blank, then A_NOV=1.
IF A27 < DATE.DMY(1,11,relevant academic year) AND (A28 >= DATE.DMY(1,11,relevant academic year) OR A28 < DATE.DMY(1,8,relevant academic year) ) AND MISSING(A31) A_NOV =1.

/* If course starts before 1/11, there is no expected or actual enddate
/* and A34=1 or missing, then A_NOV=1.
IF ( A27 < DATE.DMY(1,11,relevant academic year) AND MISSING(A31) AND MISSING(A28) AND (A34=1 OR MISSING(A34))) A_NOV =1.

VARIABLE LABELS A_NOV 'DV - Qualification active on 1 November in this year'.

VALUE LABELS A_NOV
 0 'Not active on 1 November'
 1 'Active on 1 November'.

L_NOV

8 The following table shows the steps required to derive L_NOV

Step

Condition

Action if true

Action if false

1

Is Collection=WBL or ESF SR

Go to 3

Go to 2

2

Is A_LIVE_B>1

Go to 3

Stop

3

Is any A_NOV=1

Set L_NOV to 1

Set L_NOV to 0

9 The following SPSS code illustrates how to derive L_NOV

/* sort cases according to variables to be used in aggregate.
SORT CASES L01 L03 A_NOV

/* A temporary select is made on all learners who are active according to the November Census date.
/* Aggregation is to learner level to obtain the maximum of a_Nov. i.e where it equals 1.
TEMPORARY.
SELECT IF A_LIVE_B > 1.
AGGREGATE OUTFILE=*
 /PRESORTED
 /BREAK=L01 L03
 /L_NOV 'DV - Learner was active on 1 Nov in this year'=MAX(A_NOV).

A_JAN

10 The following table shows the steps required to derive A_JAN

Step

Condition

Action if true

Action if false

1

A27=1 January relevant academic year + 1

set A_JAN to 1

Go To 2

2

A27 < 1 January relevant academic year + 1 and A31>1 January relevant academic year + 1

set A_JAN to 1

Go To 3

3

A27< 1 January relevant academic year + 1 and A28 >= 1 January relevant academic year + 1 and no date in A31

set A_JAN to 1

Go To 4

4

A27< 1 January relevant academic year + 1 and A28 < 1 August relevant academic year + 1and no date in A31

set A_JAN to 1

Go To 5

5

A27< 1 January relevant academic year, no date in A28, no date in A31 and A34 is either missing or = 1

set A_JAN to 1

11 The following SPSS code illustrates how to derive A_JAN

COMPUTE A_JAN=0.

/* If course starts on 1/1, then A_JAN=1.
IF A27 = DATE.DMY(1,1,relevant academic year + 1) A_JAN =1.

/* If course starts before 1/1 and finishes after 1/1, then A_JAN=1.
IF A27 < DATE.DMY(1,1,relevant academic year + 1) AND a31 >= DATE.DMY(1,1,relevant academic year + 1) A_JAN =1.

/* If course starts before 1/1 and is expected to finish after 1/1 OR
/* If the course has an expected date of before 1/8 but the actual
/* enddate is blank, then A_JAN=1.
IF A27 < DATE.DMY(1,1,relevant academic year + 1) AND (A28 >= DATE.DMY(1,1,relevant academic year) OR A28 < DATE.DMY(1,8,relevant academic year) ) AND MISSING(A31) A_JAN =1.

/* If course starts before 1/1, there is no expected or actual enddate
/* and a34=1 or missing, then A_JAN=1.
IF ( A27 < DATE.DMY(1,1,relevant academic year + 1) AND MISSING(A31) AND MISSING(A28) AND (A34=1 OR MISSING(A34))) A_JAN =1.

VARIABLE LABELS A_JAN 'DV - Qualification active on 1 January in this year'.

VALUE LABELS A_JAN
 0 'Not active on 1 January'
 1 'Active on 1 January'.

L_JAN

12 The following table shows the steps required to derive L_JAN

Step

Condition

Action if true

Action if false

1

Is Collection=WBL or ESF SR

Go to 3

Go to 2

2

Is A_LIVE_B>1

Go to 3

Stop

3

Is any A_JAN=1

Set L_JAN to 1

Set L_JAN to 0

13 The following SPSS code illustrates how to derive L_JAN

/* sort cases according to variables to be used in aggregate.
SORT CASES L01 L03 A_JAN

/* A temporary select is made on all learners who are active according to the January Census date.
/* Aggregation is to learner level to obtain the maximum of a_Jan. i.e where it equals 1.
TEMPORARY.
SELECT IF A_LIVE_B > 1.
AGGREGATE OUTFILE=*
 /PRESORTED
 /BREAK=L01 L03
 /L_JAN 'DV - Learner was active on 1 Jan in this year'=MAX(A_JAN).

Creator

Analysis and MI Team

Date issued

25 January 2005

Date created

9 December 2005

Document ref.

\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-activeoncensusdatesamplecode-report-25jan2005.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