Disability Premium Extraction of Data from HESA Record

Disability Premium – extraction of data from HESA Record

***************************************************************************************************************

* Algorithm for institutions to use with INSTANCE record merged with STUDENT *

* ON MODULE and MODULE record *

* Example for use with 2014/15 HESA data *

***************************************************************************************************************

***************************************************************************************************************

* Please also refer to further guidance found on the HEFCW website * * http://www.hefcw.ac.uk/working_with_he_providers/data_collection/funding_calculations.aspx *

***************************************************************************************************************

*********************************************************************************************************

* 1. Extract eligible students *

* variables taken from HESA record are in upper case of the form ENTITY.FIELDNAME * * *

*********************************************************************************************************

**********************************

* Notes *

* ne means not equal to *

* proc means procedure *

* =: means begins with *

**********************************

data popn;

set hesa;

where ((INSTANCE.FUNDCODE ne ‘1’ and INSTANCE.INITIATIVES=’7’) or

INSTANCE.FUNDCODE = ‘1’ ) and

INSTANCE.EXCHANGE not in ('4','G') and

INSTANCE.MODE in (‘01’,’02’,’23’,’24’,’25’,’31’) and

COURSE.COURSEAIM in (all C codes, all D codes, all E codes, all H codes, all I codes, all J codes, all L codes, all M codes except where any code ends in 99);

**********************************************************************************************

* 2. Only include students active between 1 August 2014 and 31 July 2015 *

* and not in the final academic year of a non-standard academic year course *

**********************************************************************************************

if INSTANCE.TYPEYR = ‘1’ and

INSTANCE.COMDATE <=’31Jul2015’d and

(INSTANCE.ENDDATE >=’1Aug2014’d or INSTANCE.ENDDATE = ‘ ‘) then count=1;

if INSTANCE.TYPEYR=’2’ and

INSTANCE.ENDDATE <=’31Jul2015’d and

INSTANCE.ENDDATE ne ‘ ‘ and

INSTANCE.ENDDATE > (AVDATE+14) then count=1;

************************************************************************

*AVDATE is anniversary of INSTANCE.COMDATE in 2014/15*

************************************************************************

if INSTANCE.TYPEYR=’2’ and

INSTANCE.ENDDATE <= ‘31Jul2015’d and

INSTANCE.ENDDATE ne ‘ ‘ and

INSTANCE.ENDDATE <= (AVDATE+14) then do;

if INSTANCE.UNITLGTH =’3’ and INSTANCE.SPLENGTH in (‘01’,’02’) or

INSTANCE.UNITLGTH =’4’ and INSTANCE.SPLENGTH in (‘01’ to ‘14’) or

INSTANCE.UNITLGTH =’5’ and INSTANCE.SPLENGTH in (‘01’ to ’42’) then count=1;

if INSTANCE.TYPEYR=’2’ and

INSTANCE.COMDATE <=’31Jul2015’d and

INSTANCE.ENDDATE =’ ‘ then count=1;

if count ne 1 then delete;

********************************************************************************************

* For 2014/15 data full-time and sandwich undergraduate (and PGCE) and PGT * removed.

* Mod values of ‘FS’, ‘PT’ and heslev values of ‘UG’, ‘PGT’ derived using * INSTANCE.MODE and COURSE.COURSEAIM according to HESES definitions.

********************************************************************************************

if mod =’FS’ and heslev in (‘UG’,’PGT’) then delete;

***********************************************************************************************

* 3. Set number of credit points coded as ‘missing to 0 *

* If INSTANCE.STULOAD >= 8.3 for PGR students give dummy credit value *

* of 10 credits to meet eligibility criteria in algorithm *

***********************************************************************************************

if MODULE.CRDTPTS = . then MODULE.CRDTPTS=0;

if COURSE.COURSEAIM in (D codes, L codes) then do;

if INSTANCE.STULOAD>=8.3 then MODULE.CRDTPTS=10; else MODULE.CRDTPTS=0;

end;

************************************************************************************************************

* 4. Delete duplicate modules on courses by student *

* if student has multiple records, one with DSA=4 (in receipt) given priority *

* nodupkey means delete duplicates with same values of institution,

* INSTANCE.HUSID, *

* MODULE.MODID and Disability_order *

* note that UHOVI is treated as a separate institution for extraction purposes

************************************************************************************************************

proc sort nodupkey;

by institution INSTANCE.HUSID MODULE.MODID Disability_order;

**************************************************************************************************************

* 5. Sum credits by institution and INSTANCE.HUSID *

* Dataset ‘outcred’ is output and contains the total number of credits per student (totcred). *

**************************************************************************************************************

proc summary;

by institution INSTANCE.HUSID;

var MODULE.CRDTPTS;

output out=outcred sum=totcred;

****************************************************************************************

* 6. Merge total credit dataset back onto individual student dataset *

****************************************************************************************

data merged;

merge popn outcred;

by institution INSTANCE.HUSID;

*******************************************************************************************************

* 7. Delete duplicate students, keeping 1 entry with highest mode of study *

* Mod values of ‘FT, ‘PT’ derived using INSTANCE.MODE according to HESES definitions. FT being highest mode. *

*******************************************************************************************************

**********************************************************************************************

* Input data will be in the following form: *

* *

* Institution HUSID mod CRDTPTS totcred *

* 1 1 FT 60 140 *

* 1 1 FT 40 140 *

* 1 1 FT 20 140 *

* 1 1 PT 20 140 *

* 1 2 PT 10 60 *

* 1 2 PT 50 60 *

* *

* Output will be in the following form: *

* *

* Institution HUSID mod totcred *

* 1 1 FT 140 *

* 1 2 PT 60 *

**********************************************************************************************

proc sort;

by institution INSTANCE.HUSID mod;

if first.INSTANCE.HUSID=1 then keep;

*******************************************************************

* 8. Delete students studying less than 10 credit values. *

*******************************************************************

if totcred<10 then delete;

********************************************************************************************

* 9. Flag those students that are in receipt of DSA, and those not in receipt. *

********************************************************************************************

if INSTANCE.DISALL=’4’ then disprem=1;

else ndisprem=1;

****************************************************************************************

* 10. Count students who are eligible for DSA premium funding. *

* Dataset ‘outtot’ contains counts by mode of study and institution. *

****************************************************************************************

proc summary;

by institution mod;

var disprem ndisprem;

output out=outtot (keep=frequency) sum=disprem ndisprem;