FE Success Rates Tri-files 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 SPSS code is provided to illustrate the FE Success Rate Tri-files Production definition and should be read in conjunction with that definition.

Recoding of BTEC National Diplomas

* code to recognise BTEC Nation Dips with three letters in A36. This code identifies high grades and uses the.
* two character code "HI".


STRING temp (A3).
COMPUTE temp = a36.
DELETE VARIABLES a36.


STRING a36 (A2).
DO IF (((SUBSTR(temp,3,1) = "D") OR (SUBSTR(temp,3,1) = "M") OR (SUBSTR(temp,3,1) = "P"))
AND (SUBSTR(temp,1,1) <> "P") AND (SUBSTR(temp,2,1) <> "P") AND (SUBSTR(temp,3,1) <> "P")).
COMPUTE a36 = "HI".
ELSE.
COMPUTE a36=temp.
END IF.


DELETE VARIABLES temp.

Calculation of Funding Status

Select if ANY(A10,20,70,80,99).

RECODE A10 (20=1) (80=1) (70=1)(ELSE=0) into fundstat.

Calculation of Unique Learner Reference

** Calculate newref to ensure matching works okay
** Match in INST code on UPIN.
** Save, dropping unwanted variables.


STRING triml03 (A12).
COMPUTE Triml03=LTRIM(L03).

COMPUTE no_zeros = 0.

LOOP.
COMPUTE no_zeros = no_zeros + 1.
END LOOP IF (SUBST(triml03,no_zeros,1)<>"0").

STRING new_l03 (A12).
COMPUTE new_l03 = SUBSTR(triml03,no_zeros, (13 - no_zeros)).


STRING newref (A19).
COMPUTE newref = CONCAT(STRING(l01,F6.0)," ",new_l03).

SORT CASES BY L01.

SAVE OUTFILE = 'Tri File xxxx/xx.sav'
/DROP a05 a11a a32 l15 l16 l17 l29 l32 l34a l34b l34c l35 random triml03 no_zeros new_l03.

Creator

Analysis and MI Team

Date issued

22 December 2005

Date created

1 December 2005

Document ref.

\\records.lsc.local\NAT\23 LrngSkillsPolicyInfrastr\23-07 DataCollectAlysis\23-07-03 LrnrDataAlysisDiss\nat-fesuccessratestri-filessamplecode-report-22dec2005.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: 23 Dec 05