Skills for Life Flags 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 Skills for Life data definition

A_SFL

2 The following table shows the steps required to derive A_SFL

Step	Condition	Action if true	Action if false
1	Does A_SFL =1	Set A_SFL to 1	Set A_SFL to 0

3 The following SPSS code illustrates how to derive A_SFL

/*Calculates whether an aim is a skills for life aim 
/* Matches the current working file (aims file) with the Analytical Lad dataset by A09 (Qualification Aim Reference).
GET FILE=’………………….AIMS data set.’.
SORT CASES BY A09.
MATCH FILES /FILE=*
 /TABLE=’………………….Analytical LAD data set’
 /BY A09.

VARIABLE LABELS A_SFL ‘DV - 1/0 flag to indicate if the aim counts towards the Skills for Life Target'

L_SFL

4 The following table shows the steps required to derive L_SFL

Step	Condition	Action if true	Action if false
1	Does 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_SFL=1	Set L_SFL to 1	Set L_SFL to 0

5 The following SPSS code illustrates how to derive L_SFL

WBL, ESF SR

/* Calculating Basic Skills at Learner Level for WBL and ESF SR.
/* Data is aggregated by Provider Number (L01) and Learner Reference Number (L03) and the maximum basic skills taken.
SORT CASES L01 L03 A05.
AGGREGATE OUTFILE=*
 /BREAK=L01 L03
 /L_SFL ‘DV - Skills for Life learner'=max(A_SFL).

FE, UfI, ACL

/* Calculating Basic Skills at Learner Level for FE,UfI and ACL.
/*Only aims where A_LIVE_B >1 are selected
/* Data is aggregated by Provider Number (L01) and Learner Reference Number (L03) and the maximum basic skills taken.
SELECT IF A_LIVE_B>1. 
AGGREGATE OUTFILE=*
 /PRESORTED
 /BREAK=L01 L03
 /L_SFL 'DV - Skills for Life learner'=MAX(A_SFL).

Creator	Analysis and MI Team
Date issued	25 September 2006
Date created	3 January 2006
Document ref.	\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-skillsforlifesamplecode-report-25sep2006.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: 26 Sep 06