SASPAC Commands for Creating the Classification Variables

Numerators, England & Wales
COMPUTE V01 = S020008
COMPUTE V02 = S020015 + S020022
COMPUTE V03 = S020029 + S020026 + S020043 + S020050
COMPUTE V04 = S020057 + S020064 + S020071 + S020078
COMPUTE V05 = S020085 + S020092 + S020099 + S020106
COMPUTE V06 = S020113 + S020120
COMPUTE V07 = S020127 + S020134
COMPUTE V08 = S020141 + S020148
COMPUTE V09 = S020004 + S020007
COMPUTE V10 = S020003 + S020006
COMPUTE V11 = S080133 + S080287
COMPUTE V12 = S080177 + S080188 + S080199 + S080210
COMPUTE V13 = S400001
COMPUTE V14 = S080089 + S080111 + S080243 + S080265
COMPUTE V15 = S060002
COMPUTE V16 = S060003 + S060004 + S060005
COMPUTE V17 = S060006
COMPUTE V18 = S060007
COMPUTE V19 = S060008
COMPUTE V20 = S060009 + S060011 + S060012
COMPUTE V21 = S490024 + S490031
COMPUTE V22 = S490025 + S490032
COMPUTE V23 = S490026 + S490033
COMPUTE V24 = S490038 + S490045
COMPUTE V25 = S490039 + S490046
COMPUTE V26 = S490040 + S490047
COMPUTE V27 = S150001
COMPUTE V28 = S150046
COMPUTE V29 = S200002
COMPUTE V30 = S200003
COMPUTE V31 = S200004 + S200005 + S200006
COMPUTE V32 = S200007 + S200008
COMPUTE V33 = S560002
COMPUTE V34 = S560003
COMPUTE V35 = S560004
COMPUTE V36 = S560005 + S560006 + S560007 + S560008 + S560009 + S560012
COMPUTE V37 = S560011 + S560014
COMPUTE V38 = S200031 + S200061
COMPUTE V39 = S200041
COMPUTE V40 = S210003
COMPUTE V41 = S210005 + S210006
COMPUTE V42 = S230004
COMPUTE V43 = S570057
COMPUTE V44 = S530001
COMPUTE V45 = S530005
COMPUTE V46 = S530009
COMPUTE V47 = S530013 + S530017 + S530021
COMPUTE V48 = S530025
COMPUTE V49 = S530029 + S530033 + S530037
COMPUTE V50 = S530041 + S530045 + S530049 + S530053
COMPUTE V51 = S870012 + S870013
COMPUTE V52 = S870014 + S870015
COMPUTE V53 = S870062 + S870063 + S870102 + S870103
COMPUTE V54 = S870064 + S870065 + S870104 + S870105
COMPUTE V55 = S870072 + S870073 + S870112 + S870113
COMPUTE V56 = S870074 + S870075 + S870114 + S870115
COMPUTE V57 = S870162 + S870163
COMPUTE V58 = S870164 + S870165
COMPUTE V59 = S280031 + S280046 + S280061 + S280076 + S280091 + S280106 + S280121 + S280136 + S280151
COMPUTE V60 = S080012 + S080166
COMPUTE V61 = S080045 + S080056 + S080199 + S080210
COMPUTE V62 = S080078 + S080232
COMPUTE V63 = S730002
COMPUTE V64 = S730003 + S730004
COMPUTE V65 = S730005 + S730006
COMPUTE V66 = S730007
COMPUTE V67 = S730008
COMPUTE V68 = S730009
COMPUTE V69 = S730010
COMPUTE V70 = S860021 + S860034 + S860047 + S860060
COMPUTE V71 = S860073 + S860086 + S860099
COMPUTE V72 = S860112 + S860125 + S860138 + S860151 + S860164 + S860177
COMPUTE V73 = S860190 + S860203 + S860216
COMPUTE V74 = S860229
COMPUTE V75 = S840007
COMPUTE V76 = S840010 + S840013
COMPUTE V77 = S120001
COMPUTE V78 = S820002 + S820003 + S820004
COMPUTE V79 = S820005 + S820006
COMPUTE V80 = S820011
COMPUTE V81 = S010022
COMPUTE V82 = S040001
COMPUTE V83 = S050013 + S050019
COMPUTE V84 = S050025
COMPUTE V85 = S050031 + S050037

VARIABLE LABELS V01 "0 - 4"
VARIABLE LABELS V02 "5 - 14"
VARIABLE LABELS V03 "15 - 24"
VARIABLE LABELS V04 "25 - 44"
VARIABLE LABELS V05 "45 - 64"
VARIABLE LABELS V06 "65 - 74"
VARIABLE LABELS V07 "75 - 84"
VARIABLE LABELS V08 "85+"
VARIABLE LABELS V09 "Total marr'd population"
VARIABLE LABELS V10 "Single population"
VARIABLE LABELS V11 "Total retired (pensioners)"
VARIABLE LABELS V12 "Working Women (excluding Govt Sch.) (S08)"
VARIABLE LABELS V13 "Total 'Lone' Parents"
VARIABLE LABELS V14 "Students (16+) in term-time addresses"
VARIABLE LABELS V15 "White"
VARIABLE LABELS V16 "Black"
VARIABLE LABELS V17 "Indian"
VARIABLE LABELS V18 "Pakistani"
VARIABLE LABELS V19 "Bangladeshi"
VARIABLE LABELS V20 "Chinese + Other"
VARIABLE LABELS V21 "Black (grps) and Owner & privately rented"
VARIABLE LABELS V22 "Indian, Pakistani, Ban'deshi and Owner & privately rented"
VARIABLE LABELS V23 "Chinese & others and Owner & privately rented"
VARIABLE LABELS V24 "Black (grps) and council rented"
VARIABLE LABELS V25 "Indian, Pakistani, Ban'deshi and council rented"
VARIABLE LABELS V26 "Chinese & others and council rented"
VARIABLE LABELS V27 "Movers last year"
VARIABLE LABELS V28 "Pensioner migrants"
VARIABLE LABELS V29 "Owned Outright"
VARIABLE LABELS V30 "Mortgaged"
VARIABLE LABELS V31 "Private Rented"
VARIABLE LABELS V32 "Rented from HA, LA, NT"
VARIABLE LABELS V33 "Detached"
VARIABLE LABELS V34 "Semi-detached"
VARIABLE LABELS V35 "Terraced"
VARIABLE LABELS V36 "Flats"
VARIABLE LABELS V37 "Bedsits"
VARIABLE LABELS V38 "No central heating"
VARIABLE LABELS V39 "Lacking bath and shower"
VARIABLE LABELS V40 "No car"
VARIABLE LABELS V41 "2+ cars"
VARIABLE LABELS V42 "Hhlds with more than 1.5 ppr"
VARIABLE LABELS V43 "Number of Hhlds with 7+ rooms"
VARIABLE LABELS V44 "Couple hhld, aged 16-24 without child(ren)"
VARIABLE LABELS V45 "Couple hhld, aged 16-24 with child(ren)"
VARIABLE LABELS V46 "Couple hhld, aged 25-34 without child(ren)"
VARIABLE LABELS V47 "Couple hhld, aged 25-34 with child(ren)"
VARIABLE LABELS V48 "Couple hhld, aged 35-54 without child(ren)"
VARIABLE LABELS V49 "Couple hhld, aged 35-54 with child(ren)"
VARIABLE LABELS V50 "Couple hhld, aged 55-75 plus"
VARIABLE LABELS V51 "No Family Hhlds / Owner"
VARIABLE LABELS V52 "No Family Hhlds / Council"
VARIABLE LABELS V53 "Marr'd + cohabiting Couple no children / Owner"
VARIABLE LABELS V54 "Marr'd + cohabiting Couple no children / Council"
VARIABLE LABELS V55 "Marr'd + cohabiting Couple + dependent children / Owner"
VARIABLE LABELS V56 "Marr'd + cohabiting Couple + dependent children / Council"
VARIABLE LABELS V57 "2+ Family Hhlds / Owner"
VARIABLE LABELS V58 "2+ Family Hhlds / Council"
VARIABLE LABELS V59 "Hhlds with dependants"
VARIABLE LABELS V60 "Economically active residents 16+"
VARIABLE LABELS V61 "self-employed"
VARIABLE LABELS V62 "Total e.a. unemployed"
VARIABLE LABELS V63 "Agric./Forestry/Fishing"
VARIABLE LABELS V64 "Energy, Water & Mining"
VARIABLE LABELS V65 "Manufacturing"
VARIABLE LABELS V66 "Construction"
VARIABLE LABELS V67 "Distribution & Catering"
VARIABLE LABELS V68 "Transport"
VARIABLE LABELS V69 "Banking & Finance"
VARIABLE LABELS V70 "Professional (1,2,3,4)"
VARIABLE LABELS V71 "Intermediate & Junior Non-manual (5,6)"
VARIABLE LABELS V72 "Manual (8,9,12; 7,10; 11)"
VARIABLE LABELS V73 "Agricultural (13, 14, 15)"
VARIABLE LABELS V74 "Armed Forces (16)"
VARIABLE LABELS V75 "Workers with higher degrees"
VARIABLE LABELS V76 "Workers with other qualifications"
VARIABLE LABELS V77 "Total persons with LLI (S12)"
VARIABLE LABELS V78 "Train & Bus"
VARIABLE LABELS V79 "Car"
VARIABLE LABELS V80 "Work at home"
VARIABLE LABELS V81 "Total Imputed Residents"
VARIABLE LABELS V82 "Medical & Care Ests."
VARIABLE LABELS V83 "Detention centres & Defence Est."
VARIABLE LABELS V84 "Education Ests."
VARIABLE LABELS V85 "Hotels & Other Ests."

Denominators, England & Wales
COMPUTE V101 = S020001
COMPUTE V102 = S080001 + S080155
COMPUTE V103 = S060001
COMPUTE V104 = S490001
COMPUTE V105 = S200001
COMPUTE V106 = S560001
COMPUTE V107 = S570001
COMPUTE V108 = S210002
COMPUTE V109 = S870001
COMPUTE V110 = S280001
COMPUTE V111 = S730001
COMPUTE V112 = S860008
COMPUTE V113 = S840001
COMPUTE V114 = S820001
COMPUTE V115 = S040001
COMPUTE V116 = S050001

VARIABLE LABELS V101 "Total Persons S02"
VARIABLE LABELS V102 "Residents age 16 and over S08"
VARIABLE LABELS V103 "Total persons present S06"
VARIABLE LABELS V104 "Total hhlds with residents S49"
VARIABLE LABELS V105 "Total permenant accommodation S20"
VARIABLE LABELS V106 "Total Hhld spaces (All types of occupancy) S56"
VARIABLE LABELS V107 "Total hhlds S57"
VARIABLE LABELS V108 "Total Households with residents (car availability) S21"
VARIABLE LABELS V109 "Total hhlds with residents S87"
VARIABLE LABELS V110 "Total Hhlds S28"
VARIABLE LABELS V111 "Total residents aged 16 and over S73"
VARIABLE LABELS V112 "Total Residents S86"
VARIABLE LABELS V113 "Total persons 18+ S84"
VARIABLE LABELS V114 "Residents aged 16+ and over (employed & self-employed) S82"
VARIABLE LABELS V115 "Total residents not in hhlds (non-staff) S04"
VARIABLE LABELS V116 "Total residents not in hhlds (non-staff) S05"

Scottish Numerators
COMPUTE V21 = SS490024 + SS490031
COMPUTE V22 = SS490025 + SS490032
COMPUTE V23 = SS490026 + SS490033
COMPUTE V24 = SS490038 + SS490045 + SS490052
COMPUTE V25 = SS490039 + SS490046 + SS490053
COMPUTE V26 = SS490040 + SS490047 + SS490054
COMPUTE V27 = SS150001
COMPUTE V28 = SS150046
COMPUTE V29 = SS200002
COMPUTE V30 = SS200003
COMPUTE V31 = SS200004 + SS200005 + SS200006
COMPUTE V32 = SS200007 + SS200008 + SS200009
COMPUTE V38 = SS200034 + SS200067
COMPUTE V39 = SS200045
COMPUTE V42 = SS230004
COMPUTE V51 = SS870013 + SS870014
COMPUTE V52 = SS870015 + SS870016 + SS870017
COMPUTE V53 = SS870068 + SS870069 + SS870112 + SS870113
COMPUTE V54 = SS870070 + SS870071 + SS870072 + SS870114 + SS870115 + SS870116
COMPUTE V55 = SS870079 + SS870080 + SS870123 + SS870124
COMPUTE V56 = SS870081 + SS870082 + SS870083 + SS870125 + SS870126 + SS870127
COMPUTE V57 = SS870178 + SS870179
COMPUTE V58 = SS870180 + SS870181 + SS870182
COMPUTE V70 = SS860023 + SS860037 + SS860051 + SS860065
COMPUTE V71 = SS860079 + SS860093 + SS860107
COMPUTE V72 = SS860121 + SS860135 + SS860149 + SS860163 + SS860177 + SS860191
COMPUTE V73 = SS860205 + SS860219 + SS860233
COMPUTE V74 = SS860247

VARIABLE LABELS V21 "Black (grps) and Owner & privately rented"
VARIABLE LABELS V22 "Indian, Pakistani, Ban'deshi and Owner & privately rented"
VARIABLE LABELS V23 "Chinese & others and Owner & privately rented"
VARIABLE LABELS V24 "Black (grps) and Council rented"
VARIABLE LABELS V25 "Indian, Pakistani, Ban'deshi and Council rented"
VARIABLE LABELS V26 "Chinese & others and Council rented"
VARIABLE LABELS V27 "Movers last year"
VARIABLE LABELS V28 "Pensioner migrants"
VARIABLE LABELS V29 "Owned Outright"
VARIABLE LABELS V30 "Mortgaged"
VARIABLE LABELS V31 "Private Rented"
VARIABLE LABELS V32 "Rented from HA, LA, NT or SH"
VARIABLE LABELS V38 "No central heating"
VARIABLE LABELS V39 "Lacking bath and shower"
VARIABLE LABELS V42 "Hhlds with more than 1.5 ppr"
VARIABLE LABELS V51 "No Family Hhlds / Owner"
VARIABLE LABELS V52 "No Family Hhlds / Council"
VARIABLE LABELS V53 "Marr'd + cohabiting Couple no children / Owner"
VARIABLE LABELS V54 "Marr'd + cohabiting Couple no children / Council"
VARIABLE LABELS V55 "Marr'd + cohabiting Couple + dependent children / Owner"
VARIABLE LABELS V56 "Marr'd + cohabiting Couple + dependent children / Council"
VARIABLE LABELS V57 "2+ Family Hhlds / Owner"
VARIABLE LABELS V58 "2+ Family Hhlds / Council"
VARIABLE LABELS V70 "Professional (1,2,3,4) "
VARIABLE LABELS V71 "Intermediate & Junior Non-manual (5,6)"
VARIABLE LABELS V72 "Manual (8,9,12; 7,10; 11)"
VARIABLE LABELS V73 "Agricultural (13, 14, 15)"
VARIABLE LABELS V74 "Armed Forces (16)"

Scottish Denominators
COMPUTE V104 = SS490001
COMPUTE V105 = SS200001
COMPUTE V109 = SS870001
COMPUTE V112 = SS860009

VARIABLE LABELS V104 "Total hhlds with residents SS49 (Scotland)"
VARIABLE LABELS V105 "Total permenant accommodation SS20 (Scotland)"
VARIABLE LABELS V109 "Total hhlds with residents SS87(Scotland)"
VARIABLE LABELS V112 "Total Residents SS86 (Scotland)"


Return to: Help Topics  LGAS homepage