Learner Level Delivery Location Postcode 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 Learner Level Delivery Location Postcode data definition.

L_A23

WBL & ESF SR

2 The following SPSS code illustrates how to derive L_A23 for WBL & ESF SR

/*This is carried out on the frameworks and aims file.
GET FILE ‘…………FRAMEWORK AND AIMS data set’.

/* For WBL the L_A23 belongs to the programme type with the latest start date.
SELECT IF A10=50 OR (ANY(A10,40,70,80) AND NOT ANY(A15,2,3)).
SORT CASES L01 L03 A27.
AGGREGATE OUTFILE *
 /BREAK=L01 L03
 /L_A23=LAST(A23).

FE, UfI & ACL

3 The following SPSS code illustrates how to derive L_A23 for FE, UfI & ACL

GET FILE ………….AIMS.SAV'.
/* For FE L_A23 belongs to the aim with the highest NVQ, level. Where there are more than one aim with the same highest NVQ level and different delivery provider postcodes, we take into account the actual cyglh assosciated with each postcode.
/* Exclude those aims which are not included for analytical purposes.
SELECT IF A_LIVE_B>1.

/* Set the value of Other to 0, so that it has a lower priority then the NVQ levels 1 to 4.
RECODE A_NVQLEV (9=0).
SORT CASES L01 L03 A_NVQLEV.

/*Aggregate out to a temporary file at learner level to get the highest NVQ level per learner.
AGGREGATE OUTFILE '…………NVQLEV.SAV'
 /BREAK= L01 L03
 /N_NVQLEV=MAXIMUM(A_NVQLEV).

/* Match the learner level NVQ back on to the aims file.
MATCH FILE /FILE *
 /TABLE=’…………….NVQLEV.SAV'
 /BY L01 L03.

/* Select only those cases where the learners aim NVQ level equals the learner NVQ level.
SELECT IF N_NVQLEV=A_NVQLEV.

/*Aggregate out to another temporary file, to sum the actual cyglh for each delivery provider postcode.
AGGREGATE OUTFILE ‘…………….NVQLEV3.SAV'
 /BREAK= L01 L03 A23
 /N_ACT_B=SUM(A_ACT_B).

/* Next we look at the temporary file and aggregate it using the sum of the actual cyglh as a break variable to see if there is more than one postcode with the same actual cyglh.
GET FILE '…………….NVQLEV3.SAV'.
AGGREGATE OUTFILE '…………….NVQLEV4.SAV'
 /BREAK= L01 L03 N_ACT_B
 /N=N.

/* Repeat the first process and select aims that have the same NVQ level as the learner NVQ level
MATCH FILE /FILE= '…………….AIMS.SAV'
 /TABLE='…………….NVQLEV.SAV'
 /BY L01 L03.

/* Exclude those aims which are not included for analytical purposes.
SELECT IF A_LIVE_B>1.
RECODE N_NVQLEV (0=9).
SELECT IF N_NVQLEV=A_NVQLEV.
SORT CASES L01 L03 A23.

/* Match on the temporary file with the sum of the actual cyglh for each delivery provider postcode.
MATCH FILE /FILE *
 /TABLE='…………….NVQLEV3.SAV'
 /BY L01 L03 A23.

/* Match on the temporary file with the number of postcodes with the same actual cyglh.
SORT CASES L01 L03 N_ACT_B.
MATCH FILE /FILE= *
 /TABLE='…………….NVQLEV4.SAV'
 /BY L01 L03 N_ACT_B.

/*Create a new variable L_A23 and set the value to be equal to A23.
SORT CASES L01 L03 N_ACT_B.
STRING L_A23 (A8).
COMPUTE L_A23=A23.

/*If there are cases where ther is more than one deli8very provider postcode with he same maximum cyglh, then set the value in L_A23 to MIX DP, i.e. there is no one main delivery provider postcode for the learner.
IF N>1 L_A23="MIX DP".
SELECT IF A_LIVE_B>1.

/*Aggregate out to the learner level to get just one record per learner.
AGGREGATE OUTFILE '…………….NVQLEV5.SAV'
 /BREAK=L01 L03
 /L_A23=LAST(L_A23).

Creator	Analysis and MI Team
Date issued	3 January 2006
Date created	22 December 2005
Document ref.	\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-learnerleveldeliverylocationpostcodesamplecode-report-03jan2006.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: 3 Jan 06