Location of the Provider 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 Location of the Provider data definition.

L_PLLSC, L_PREG, L_PLA, L_PWAR01, L_PWAR03, L_PWARD

2 The following SPSS code illustrates how to match Location of the Provider fields on to the Learner or Aims data set.

/* Match the UPIN to LLSC look up onto the file in order to get the providers postcode 
SORT CASES L01.
MATCH FILES /FILE=*
/TABLE=’……………………….UPIN to LLSC Lookup.sav’
/BY L01.
RECODE L_PLLSC (SYSMIS=-99).
SORT CASES P_POSTCODE.

/* Rename the providers postcode so that it matches the name of the postcode field in the postcode file.
RENAME VARIABLES (p_postcode=postcode).
MATCH FILES /FILE=*
/TABLE = ‘…………………………POSCTODE data set.sav’
/BY POSTCODE.

/* Rename the ward variables matched on from the postcode file.
RENAME VARIABLE (LAUAcode=L_PLA) (WARD_91=L_PWARD) (WARD_01=L_PWAR01) (WARD_03=L_PWAR03).
VARIABLE LABELS L_PLLSC 'DV - LLSC based on the 1-1 owner relationship UPIN to LLSC'
 /L_PWARD 'DV - Local Authority ward code of the Owning Provider (1991), based on the Provider postcode'
 /L_PWAR01 'DV - Local Authority ward code of the Owning Provider (2001), based on the Provider postcode'
 /L_PWAR03 'DV - Local Authority ward code of the Owning Provider (2003), based on the Provider postcode'
 /L_PREG 'DV - Region of the Owning Provider, based on the Provider postcode'.
 /L_PLA ‘DV - Local Authority based on the Provider postcode’.

Creator	Analysis and MI Team
Date issued	25 September 2006
Date created	22 December 2005
Document ref.	G:\Organisational Data\DCA\A&MI\Documentation\web data dictionary\200607\SampleCode\nat-locationoftheprovidersamplecode-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