libname mysam "c:\data\london\ons"; options NOFMTERR FMTSEARCH=(mysam) linesize=200; proc contents data=mysam.uksam2001; run; proc format library = mysam; value COUNTRY 1 = 'England' 2 = 'Scotland' 3 = 'Wales' 4 = 'N.I.' ; value LACODE 1 = '00BK Westminster&City' 2 = '00AB Barking and Dagenham' 3 = '00AC Barnet' 4 = '00AD Bexley' 5 = '00AE Brent' 6 = '00AF Bromley' 7 = '00AG Camden' 8 = '00AH Croydon' 9 = '00AJ Ealing' 10 = '00AK Enfield' 11 = '00AL Greenwich' 12 = '00AM Hackney' 13 = '00AN Hammersmith and Fulham' 14 = '00AP Haringey' 15 = '00AQ Harrow' 16 = '00AR Havering' 17 = '00AS Hillingdon' 18 = '00AT Hounslow' 19 = '00AU Islington' 20 = '00AW Kensington and Chelsea' 21 = '00AX Kingston upon Thames' 22 = '00AY Lambeth' 23 = '00AZ Lewisham' 24 = '00BA Merton' 25 = '00BB Newham' 26 = '00BC Redbridge' 27 = '00BD Richmond upon Thames' 28 = '00BE Southwark' 29 = '00BF Sutton' 30 = '00BG Tower Hamlets' 31 = '00BH Waltham Forest' 32 = '00BJ Wandsworth' 33 = '00BL Bolton' 34 = '00BM Bury' 35 = '00BN Manchester' 36 = '00BP Oldham' 37 = '00BQ Rochdale' 38 = '00BR Salford' 39 = '00BS Stockport' 40 = '00BT Tameside' 41 = '00BU Trafford' 42 = '00BW Wigan' 43 = '00BX Knowsley' 44 = '00BY Liverpool' 45 = '00BZ St. Helens' 46 = '00CA Sefton' 47 = '00CB Wirral' 48 = '00CC Barnsley' 49 = '00CE Doncaster' 50 = '00CF Rotherham' 51 = '00CG Sheffield' 52 = '00CH Gateshead' 53 = '00CJ Newcastle upon Tyne' 54 = '00CK North Tyneside' 55 = '00CL South Tyneside' 56 = '00CM Sunderland' 57 = '00CN Birmingham' 58 = '00CQ Coventry' 59 = '00CR Dudley' 60 = '00CS Sandwell' 61 = '00CT Solihull' 62 = '00CU Walsall' 63 = '00CW Wolverhampton' 64 = '00CX Bradford' 65 = '00CY Calderdale' 66 = '00CZ Kirklees' 67 = '00DA Leeds' 68 = '00DB Wakefield' 69 = '00EB Hartlepool' 70 = '00EC Middlesbrough' 71 = '00EE Redcar and Cleveland' 72 = '00EF Stockton-on-Tees' 73 = '00EH Darlington' 74 = '00ET Halton' 75 = '00EU Warrington' 76 = '00EX Blackburn with Darwen' 77 = '00EY Blackpool' 78 = '00FA Kingston upon Hull City of' 79 = '00FB East Riding of Yorkshire' 80 = '00FC North East Lincolnshire' 81 = '00FD North Lincolnshire' 82 = '00FF York' 83 = '00FK Derby' 84 = '00FN Leicester' 85 = '00FP Rutland' 86 = '00FY Nottingham' 87 = '00GA Herefordshire County of' 88 = '00GF Telford and Wrekin' 89 = '00GL Stoke-on-Trent' 90 = '00HA Bath and North East Somerset' 91 = '00HB Bristol City of' 92 = '00HC North Somerset' 93 = '00HD South Gloucestershire' 94 = '00HG Plymouth' 95 = '00HH Torbay' 96 = '00HN Bournemouth' 97 = '00HP Poole' 98 = '00HX Swindon' 99 = '00JA Peterborough' 100 = '00KA Luton' 101 = '00KF Southend-on-Sea' 102 = '00KG Thurrock' 103 = '00LC Medway' 104 = '00MA Bracknell Forest' 105 = '00MB West Berkshire' 106 = '00MC Reading' 107 = '00MD Slough' 108 = '00ME Windsor and Maidenhead' 109 = '00MF Wokingham' 110 = '00MG Milton Keynes' 111 = '00ML Brighton and Hove' 112 = '00MR Portsmouth' 113 = '00MS Southampton' 114 = '00MW Isle of Wight' 115 = '09UC Mid Bedfordshire' 116 = '09UD Bedford' 117 = '09UE South Bedfordshire' 118 = '11UB Aylesbury Vale' 119 = '11UC Chiltern' 120 = '11UE South Bucks' 121 = '11UF Wycombe' 122 = '12UB Cambridge' 123 = '12UC East Cambridgeshire' 124 = '12UD Fenland' 125 = '12UE Huntingdonshire' 126 = '12UG South Cambridgeshire' 127 = '13UB Chester' 128 = '13UC Congleton' 129 = '13UD Crewe and Nantwich' 130 = '13UE Ellesmere Port & Neston' 131 = '13UG Macclesfield' 132 = '13UH Vale Royal' 133 = '15UB Caradon' 134 = '15UC Carrick' 135 = '15UD Kerrier' 136 = '15UE North Cornwall' 137 = '15UH Isles of Scilly & Penwith' 138 = '15UG Restormel' 139 = '16UB Allerdale' 140 = '16UC Barrow-in-Furness' 141 = '16UD Carlisle' 142 = '16UE Copeland' 143 = '16UF Eden' 144 = '16UG South Lakeland' 145 = '17UB Amber Valley' 146 = '17UC Bolsover' 147 = '17UD Chesterfield' 148 = '17UF Derbyshire Dales' 149 = '17UG Erewash' 150 = '17UH High Peak' 151 = '17UJ North East Derbyshire' 152 = '17UK South Derbyshire' 153 = '18UB East Devon' 154 = '18UC Exeter' 155 = '18UD Mid Devon' 156 = '18UE North Devon' 157 = '18UG South Hams' 158 = '18UH Teignbridge' 159 = '18UK Torridge' 160 = '18UL West Devon' 161 = '19UC Christchurch' 162 = '19UD East Dorset' 163 = '19UE North Dorset' 164 = '19UG Purbeck' 165 = '19UH West Dorset' 166 = '19UJ Weymouth and Portland' 167 = '20UB Chester-le-Street' 168 = '20UD Derwentside' 169 = '20UE Durham' 170 = '20UF Easington' 171 = '20UG Sedgefield' 172 = '20UH Teesdale' 173 = '20UJ Wear Valley' 174 = '21UC Eastbourne' 175 = '21UD Hastings' 176 = '21UF Lewes' 177 = '21UG Rother' 178 = '21UH Wealden' 179 = '22UB Basildon' 180 = '22UC Braintree' 181 = '22UD Brentwood' 182 = '22UE Castle Point' 183 = '22UF Chelmsford' 184 = '22UG Colchester' 185 = '22UH Epping Forest' 186 = '22UJ Harlow' 187 = '22UK Maldon' 188 = '22UL Rochford' 189 = '22UN Tendring' 190 = '22UQ Uttlesford' 191 = '23UB Cheltenham' 192 = '23UC Cotswold' 193 = '23UD Forest of Dean' 194 = '23UE Gloucester' 195 = '23UF Stroud' 196 = '23UG Tewkesbury' 197 = '24UB Basingstoke and Deane' 198 = '24UC East Hampshire' 199 = '24UD Eastleigh' 200 = '24UE Fareham' 201 = '24UF Gosport' 202 = '24UG Hart' 203 = '24UH Havant' 204 = '24UJ New Forest' 205 = '24UL Rushmoor' 206 = '24UN Test Valley' 207 = '24UP Winchester' 208 = '26UB Broxbourne' 209 = '26UC Dacorum' 210 = '26UD East Hertfordshire' 211 = '26UE Hertsmere' 212 = '26UF North Hertfordshire' 213 = '26UG St Albans' 214 = '26UH Stevenage' 215 = '26UJ Three Rivers' 216 = '26UK Watford' 217 = '26UL Welwyn Hatfield' 218 = '29UB Ashford' 219 = '29UC Canterbury' 220 = '29UD Dartford' 221 = '29UE Dover' 222 = '29UG Gravesham' 223 = '29UH Maidstone' 224 = '29UK Sevenoaks' 225 = '29UL Shepway' 226 = '29UM Swale' 227 = '29UN Thanet' 228 = '29UP Tonbridge and Malling' 229 = '29UQ Tunbridge Wells' 230 = '30UD Burnley' 231 = '30UE Chorley' 232 = '30UF Fylde' 233 = '30UG Hyndburn' 234 = '30UH Lancaster' 235 = '30UJ Pendle' 236 = '30UK Preston' 237 = '30UL Ribble Valley' 238 = '30UM Rossendale' 239 = '30UN South Ribble' 240 = '30UP West Lancashire' 241 = '30UQ Wyre' 242 = '31UB Blaby' 243 = '31UC Charnwood' 244 = '31UD Harborough' 245 = '31UE Hinckley and Bosworth' 246 = '31UG Melton' 247 = '31UH North West Leicestershire' 248 = '31UJ Oadby and Wigston' 249 = '32UB Boston' 250 = '32UC East Lindsey' 251 = '32UD Lincoln' 252 = '32UE North Kesteven' 253 = '32UF South Holland' 254 = '32UG South Kesteven' 255 = '32UH West Lindsey' 256 = '33UB Breckland' 257 = '33UC Broadland' 258 = '33UD Great Yarmouth' 259 = '33UE King''s Lynn and West Norfolk' 260 = '33UF North Norfolk' 261 = '33UG Norwich' 262 = '33UH South Norfolk' 263 = '34UB Corby' 264 = '34UC Daventry' 265 = '34UD East Northamptonshire' 266 = '34UE Kettering' 267 = '34UF Northampton' 268 = '34UG South Northamptonshire' 269 = '34UH Wellingborough' 270 = '35UB Alnwick' 271 = '35UC Berwick-upon-Tweed' 272 = '35UD Blyth Valley' 273 = '35UE Castle Morpeth' 274 = '35UF Tynedale' 275 = '35UG Wansbeck' 276 = '36UB Craven' 277 = '36UC Hambleton' 278 = '36UD Harrogate' 279 = '36UE Richmondshire' 280 = '36UF Ryedale' 281 = '36UG Scarborough' 282 = '36UH Selby' 283 = '37UB Ashfield' 284 = '37UC Bassetlaw' 285 = '37UD Broxtowe' 286 = '37UE Gedling' 287 = '37UF Mansfield' 288 = '37UG Newark and Sherwood' 289 = '37UJ Rushcliffe' 290 = '38UB Cherwell' 291 = '38UC Oxford' 292 = '38UD South Oxfordshire' 293 = '38UE Vale of White Horse' 294 = '38UF West Oxfordshire' 295 = '39UB Bridgnorth' 296 = '39UC North Shropshire' 297 = '39UD Oswestry' 298 = '39UE Shrewsbury and Atcham' 299 = '39UF South Shropshire' 300 = '40UB Mendip' 301 = '40UC Sedgemoor' 302 = '40UD South Somerset' 303 = '40UE Taunton Deane' 304 = '40UF West Somerset' 305 = '41UB Cannock Chase' 306 = '41UC East Staffordshire' 307 = '41UD Lichfield' 308 = '41UE Newcastle-under-Lyme' 309 = '41UF South Staffordshire' 310 = '41UG Stafford' 311 = '41UH Staffordshire Moorlands' 312 = '41UK Tamworth' 313 = '42UB Babergh' 314 = '42UC Forest Heath' 315 = '42UD Ipswich' 316 = '42UE Mid Suffolk' 317 = '42UF St Edmundsbury' 318 = '42UG Suffolk Coastal' 319 = '42UH Waveney' 320 = '43UB Elmbridge' 321 = '43UC Epsom and Ewell' 322 = '43UD Guildford' 323 = '43UE Mole Valley' 324 = '43UF Reigate and Banstead' 325 = '43UG Runnymede' 326 = '43UH Spelthorne' 327 = '43UJ Surrey Heath' 328 = '43UK Tandridge' 329 = '43UL Waverley' 330 = '43UM Woking' 331 = '44UB North Warwickshire' 332 = '44UC Nuneaton and Bedworth' 333 = '44UD Rugby' 334 = '44UE Stratford-on-Avon' 335 = '44UF Warwick' 336 = '45UB Adur' 337 = '45UC Arun' 338 = '45UD Chichester' 339 = '45UE Crawley' 340 = '45UF Horsham' 341 = '45UG Mid Sussex' 342 = '45UH Worthing' 343 = '46UB Kennet' 344 = '46UC North Wiltshire' 345 = '46UD Salisbury' 346 = '46UF West Wiltshire' 347 = '47UB Bromsgrove' 348 = '47UC Malvern Hills' 349 = '47UD Redditch' 350 = '47UE Worcester' 351 = '47UF Wychavon' 352 = '47UG Wyre Forest' 353 = '00NA Isle of Anglesey' 354 = '00NC Gwynedd' 355 = '00NE Conwy' 356 = '00NG Denbighshire' 357 = '00NJ Flintshire' 358 = '00NL Wrexham' 359 = '00NN Powys' 360 = '00NQ Ceredigion' 361 = '00NS Pembrokeshire' 362 = '00NU Carmarthenshire' 363 = '00NX Swansea' 364 = '00NZ Neath Port Talbot' 365 = '00PB Bridgend' 366 = '00PD The Vale of Glamorgan' 367 = '00PF Rhondda Cynon Taff' 368 = '00PH Merthyr Tydfil' 369 = '00PK Caerphilly' 370 = '00PL Blaenau Gwent' 371 = '00PM Torfaen' 372 = '00PP Monmouthshire' 373 = '00PR Newport' 374 = '00PT Cardiff' 375 = 'Aberdeen City' 376 = 'Aberdeenshire' 377 = 'Angus' 378 = 'Argyll & Bute' 379 = 'Scottish Borders' 380 = 'Clackmannanshire' 381 = 'West Dunbartonshire' 382 = 'Dumfries & Galloway' 383 = 'Dundee City' 384 = 'East Ayrshire' 385 = 'East Dunbartonshire' 386 = 'East Lothian' 387 = 'East Renfrewshire' 388 = 'Edinburgh City of' 389 = 'Falkirk' 390 = 'Fife' 391 = 'Glasgow City' 392 = 'Highland' 393 = 'Inverclyde' 394 = 'Midlothian' 395 = 'Moray' 396 = 'North Ayrshire' 397 = 'North Lanarkshire' 398 = 'Perth & Kinross' 399 = 'Renfrewshire' 400 = 'South Ayrshire' 401 = 'South Lanarkshire' 402 = 'Stirling' 403 = 'West Lothian' 404 = 'Orkney & Shetland' 405 = 'Eilean Siar' 406 = '9501 Belfast East' 407 = '9502 Belfast North' 408 = '9503 Belfast South' 409 = '9504 Belfast West' 410 = '9505 East Antrim' 411 = '9506 East Londonderry' 412 = '9507 Fermanagh and South Tyrone' 413 = '9508 Foyle' 414 = '9509 Lagan Valley' 415 = '9510 Mid Ulster' 416 = '9511 Newry and Armagh' 417 = '9512 North Antrim' 418 = '9513 North Down' 419 = '9514 South Antrim' 420 = '9515 South Down' 421 = '9516 Strangford' 422 = '9517 Upper Bann' 423 = '9518 West Tyrone' ; value POPBASEA 0 = 'resident in hhd' 1 = 'stud away from hhd' 2 = 'communal est' 3 = 'stud away from ce' ; value ACCTYPA -9 = 'n/a - communal establishment' 1 = 'Detached or Semi-detached' 2 = 'Terraced house' 3 = 'Purpose-built flats, Flat-converted or shared house (including bedsits), Flat, M' ; value AGEA 0 = '0-4' 5 = '5-9' 10 = '10-15' 16 = '16-19' 20 = '20-24' 25 = '25-29' 30 = '30-39' 40 = '40-49' 50 = '50-59' 60 = '60-64' 65 = '65-74' 75 = '75-84' 85 = '85+' ; value BATHWC -9 = 'n/a communal est' 1 = 'Sole use' 2 = 'Shared use/None' ; value CARSH -9 = 'n/a communal est' 0 = 'No car' 1 = '1 car' 2 = '2 or more' ; value CEMTYP -9 = 'No code req''d' 1 = 'NHS' 2 = 'LA/HA/Vol/Private Co. etc' ; value CENHEAT0F -9 = 'n/a communal establishment' 1 = 'Yes, in some or all rooms' 2 = 'No' ; value CESTSTAT -9 = 'not applicable, not in c. est' 1 = 'staff or relative of staff' 2 = 'resident non-staff' ; value COBIRTA -9 = 'not usual resident' 1 = 'England' 2 = 'Scotland' 3 = 'Wales' 4 = 'Northern Ireland / UK part not specified (England, Wales and Scotland) /Ireland ' 5 = 'All other Countries of Birth' ; value COMBGN -9 = 'not usual resident or not in ni' 1 = 'Catholic' 2 = 'Protestant and other Christian (Including Christian related)' 3 = 'Other religions and philosophies' 4 = 'None' ; value DENSITYA -9 = 'Not in hhd' 1 = 'Up to and incl. 0.75' 2 = 'Over 0.75 and up to 1' 3 = 'Over 1' ; value DISTMOVA -9 = 'n/a - not a migrant' 1 = '0-4' 2 = '5-19' 3 = '20-99' 4 = '100 +' 5 = 'Outside UK' ; value DISTWRKA -9 = 'n/a not in work last week, not usual resident' 1 = 'Less than 5km' 2 = '5 and less than 20' 3 = '20 and over' 4 = 'At home' 5 = 'No fixed place' ; value ECONACH -9 = 'not applicable' 1 = 'In employment (employee or self-employed)' 2 = 'Unemployed' 3 = 'Student not economically active' 4 = 'Other Economically inactive' ; value EDISDONO 0 = 'not used as donor' 1 = 'used as donor once' 2 = 'used as donor twice' 3 = 'used as donor 3+ times' ; value ETHEWA -9 = 'n/a: not resident/ not in EW' 1 = 'White British' 2 = 'White Irish' 3 = 'Other White' 4 = 'Mixed:White&Black Carib/Black African/Black Other' 5 = 'Mixed:White and Asian/Other Mixed/Other' 6 = 'Indian (Asian/Asian British)' 7 = 'Pakistani (Asian/Asian British)' 8 = 'Bangladeshi (Asian/Asian British)' 9 = 'Other Asian (Asian/Asian British)' 10 = 'Caribbean (Black/Black British)' 11 = 'African (Black/Black British)' 12 = 'Chinese' 13 = 'Other' ; value ETHN -9 = 'not usual resident/ not in ni' 1 = 'White' 2 = 'Other Ethnic group' ; value ETHSA -9 = 'n/a: not usual resident/not in Scotland' 1 = 'White Scottish' 2 = 'Other white British' 3 = 'White Irish' 4 = 'Other white' 5 = 'Other: Caribbean, African, Black Scottish, other Black, any Mixed or other' 6 = 'Indian' 7 = 'Pakistani & other S. Asian' 8 = 'Chinese' ; value EVERWORK -9 = 'n/a in work,out of range, not resident' 1 = 'Yes' 2 = 'No' ; value FAMTYPA -9 = 'not usual residents or in c. est' 1 = 'Lone parent' 2 = 'Married /cohabiting couple - no children' 3 = 'Married/ cohabiting couple -children' 4 = 'Ungrouped individual (not in a family)' ; value FNDEPCHA -9 = 'n/a - not in family, not resident, communal establishment' 0 = 'No dependent children in family' 1 = 'Dependent children in family' ; value FRECONAC -9 = 'n/a: not resident in a family' 1 = 'In employment' 2 = 'Unemployed' 3 = 'Econ inactive' ; value FRNSSEC8F -9 = 'n/a ungrouped individual or no occupation recorded in fu' 1 = 'Class 1 (Higher managerial and Professional Occupations)' 2 = 'Class 2 (Lower managerial and professional occupations)' 3 = 'Class 3 (Intermediate occupations)' 4 = 'Class 4 (Small employers and Own Account workers)' 5 = 'Class 5 (Lower supervisory and technical occupations)' 6 = 'Class 6 (Semi-routine Occupations)' 7 = 'Class 7 (Routine Occupations)' 8 = 'Class 8 (Never worked and long-term unemployed)' 9 = 'Full-time students' 10 = 'Other (Not classified)' ; value FRSEX -9 = 'ungrouped individual' 1 = 'Male' 2 = 'Female' ; value FURN -9 = 'not in Scot, not renting, in c. est' 1 = 'Furnished' 2 = 'Unfurnished' ; value GENIND -9 = 'n/a comm est' 1 = 'Ungrouped individual' 2 = 'Upper generation - member of couple or lone parent' 3 = 'Lower generation - child in family' ; value HEALTH -9 = 'Not usually resident' 1 = 'Good' 2 = 'Fairly good' 3 = 'Not good' ; value HEDIND -9 = 'Not in hhd' 0 = 'Hhd has ed attainment' 1 = 'lev 2 or euiv/current FE not achieved by 16-64yo' ; value HEMPIND -9 = 'Not in hhd' 0 = 'No non-student 16-74 sick or unemployed' 1 = 'Non-student in hhd 16-74, sick or uneployed' ; value HHSGIND -9 = 'Not in hhd' 0 = 'Not overcrowded or lacking amenities' 1 = 'Overcrowded/lacks bath/shower,wc or heating' ; value HHTLHIND -9 = 'Not in hhd' 0 = 'Noone in hhd lt-ill or in poor health' 1 = 'Hhd member is lt-ill or in poor health' ; value HMPTPUK -9 = 'not usual resident, c. est' 1 = 'household representative' 2 = 'concealed family representative' 3 = 'Other' ; value HNCARERS -9 = 'not in hhd with residents' 0 = '0' 1 = '1' 2 = '2+' ; value HNEARNRA -9 = 'not in hhd/away from empty hhd' 0 = 'No earners' 1 = '1 earner' 2 = '2 + earners' ; value HNLLTI -9 = 'not in hhd, or empty hhd' 0 = 'None' 1 = '1' 2 = '2 or more' ; value HNPRHLTH -9 = 'not in hhd with residents' 0 = '0' 1 = '1' 2 = '2+' ; value HNRESIDA -9 = 'n/a: in communal est.' 1 = '0-1' 2 = '2-4' 3 = '5 and over' ; value HOURSPWG -9 = 'no employment record, c. est' 1 = '1-15' 2 = '16-30' 3 = '31-37' 4 = '38-48' 5 = '49 +' ; value HRSOCGRD -9 = ' n/a not in hhd or no employment record in hhd' 1 = 'A Professional and B Middle managers' 2 = 'C1 All other non-manual workers' 3 = 'C2 All skilled manual workers' 4 = 'D All semi-skilled and unskilled manual workers' 5 = 'E On benefit/unemployed' ; value LASTWRKA -9 = 'out of age range, not usual resident' 1 = 'In employment' 2 = 'Never worked' 3 = '2000-1' 4 = '1996-9' 5 = 'Before 1996' ; value LLTI -9 = 'not usual residents' 1 = 'Yes' 2 = 'No' ; value LOWFLORA -9 = 'communal est' 1 = 'Basement' 2 = 'Ground floor' 3 = 'First floor' 4 = 'Above first floor' ; value MARSTATA 1 = 'Single (never married)' 2 = 'Married/re-married' 3 = 'Separated (but still legally married)/divorced/widowed' ; value MIGINDA -9 = 'n/a' 0 = 'Same address' 1 = 'No usual address one year ago' 2 = 'Move within LAD area (England, Wales & Scotland) or LGD area (Northern Ireland)' 3 = 'Move from outside LAD/LGD but in UK' 4 = 'Move from outside UK' ; value MIGORGN -9 = 'n/a: stud living away' 1 = 'Same address as now' 2 = 'No usual address' 3 = 'Migrant from outside UK' 101 = 'A North East' 102 = 'B North West' 103 = 'D Yorkshire and the Humber' 104 = 'E East Midlands' 105 = 'F West Midlands' 106 = 'G East of England' 107 = 'J South East' 108 = 'K South West' 109 = 'I Inner London' 110 = 'O Outer London' 111 = 'S Scotland' 112 = 'W Wales' 113 = 'N Northern Ireland' ; value OCCUPNCY -9 = 'not in hhd with residents' 1 = 'At least two rooms more than required' 2 = 'One room more than required' 3 = 'Number of rooms equals number required' 4 = 'Number of rooms is lower than those required' ; value ONCPERIM 1 = 'Hhd AND person counted in census' 2 = 'Hhd counted BUT person imputed' 3 = 'Person in wholly imputed hhd' 4 = 'Person in hhd where other person imputed' ; value PROFQUAL -9 = 'n/a ni/scot' 0 = 'Does not have professional qualification' 1 = 'Has professional qualification' ; value PROVCARE -9 = ' not usual resident' 1 = 'Provides no care' 2 = 'Proves 1-19 hours care' 3 = 'Provides 20-49 hours care' 4 = 'Provides 50 or more hours care' ; value QUALVEWN -9 = '-9 n/a: out of age range, scotland or student living away' 1 = 'No qualifications' 2 = 'Level 1' 3 = 'Level 2' 4 = 'Level 3' 5 = 'Level 4/5' 6 = 'Other qualifications/level unknown (England and Wales only)' ; value QUALVS -9 = 'not 16-74, in scotland or usual resident' 1 = 'No qualifications' 2 = 'Group 1' 3 = 'Group 2' 4 = 'Group 3' 5 = 'Group 4' ; value REGIONA 1 = 'A North East' 2 = 'B North West' 3 = 'D Yorkshire and the Humber' 4 = 'E East Midlands' 5 = 'F West Midlands' 6 = 'G East of England' 7 = 'H London' 8 = 'J South East' 9 = 'K South West' 10 = 'S Scotland' 11 = 'W Wales' 12 = 'N Northern Ireland' ; value RELGEW -9 = 'not in E/W not resident' 1 = 'Christian' 2 = 'Buddhist' 3 = 'Hindu' 4 = 'Jewish' 5 = 'Muslim' 6 = 'Sikh' 7 = 'Other' 8 = 'No religion' 9 = 'Religion not stated' ; value RELGN -9 = 'n/a: not in ni/stud living away' 1 = 'Catholic' 2 = 'Presbyterian Church in Ireland' 3 = 'Church of Ireland' 4 = 'Methodist Church in Ireland' 5 = 'Other Christian (including Christian related)' 6 = 'Other Religions and Philosophies' 7 = 'No Religion/Religion not stated' ; value RELGS1F -9 = 'n/a: not in scot/stud living away' 1 = 'None' 2 = 'Church of Scotland' 3 = 'Roman Catholic' 4 = 'Other Christian' 5 = 'Buddhist' 6 = 'Hindu' 7 = 'Jewish' 8 = 'Muslim' 9 = 'Sikh' 10 = 'Other' 11 = 'Religion not stated' ; value RELTOHRA -9 = 'Not in hhd with usual residents' 1 = 'Household reference person' 2 = 'Husband or wife' 3 = 'Partner' 4 = 'Son or daughter/ Step-child' 5 = 'Other related' 6 = 'Unrelated' 7 = 'Not known' ; value ROOMSFLR -9 = 'n/a: not in NI, in comm. est.' 1 = 'More than one floor' 2 = 'One floor' ; value ROOMSNUM -9 = 'n/a: in comm. est' 1 = '1-2' 2 = '3-4' 3 = '5-6' 4 = '7+' ; value SELFCONT -9 = 'n/a' 1 = 'Yes' 2 = 'No' ; value SEX 1 = 'Male' 2 = 'Female' ; value STAHUKA -9 = 'not in hhd' 1 = 'None away' 2 = '1+ away' ; value STUDENT 1 = 'Yes' 2 = 'No' ; value SUPERVSR -9 = 'never worked, not resident, out of age range' 1 = 'Yes, supervisor, foreman' 2 = 'Not supervisor, foreman' ; value TENUREWA -9 = 'not usual resident, c.est, not in EW' 1 = 'Owns outright/with mortgage/shared ownership' 2 = 'Rents LA Scot Homes NI Hsing Exec Hsing Assoc Co-op etc' 3 = 'Private rented or lives rent free' ; value TENURSNA -9 = 'n/a c.est, not resident, not ni/scot' 1 = 'Owns outright/with mortgage/shared ownership' 2 = 'Rents from Council (Local Authority) Scottish Homes/NI Housing Executive or Rent' 3 = 'Private rented' ; value TERMTIMA -9 = 'n/a: not resident student' 1 = 'Living with parent(s)' 2 = 'not living with parents' ; value TRANWRKA -9 = ' not in work, nnot in ew' 1 = 'Work mainly at or from home' 2 = 'Train, inc. Underground, metro, light rail, tram etc' 3 = 'Bus, minibus, coach' 4 = 'Motor cycle, scooter or moped//taxi' 5 = 'Car/(car pool NI)' 6 = 'Bicycle' 7 = 'On foot/other' ; value WORKFORC -9 = 'n/a not resident, out of age range, never worked' 1 = '1-9' 2 = '10-24' 3 = '25-499' 4 = '500 or more' ; value WRKPLCEA -9 = 'na no employment record' 1 = 'No fixed place' 2 = 'Work (or study) mainly at home' 3 = 'Inside LAD/LGD area of residence' 4 = 'Outside LAD area but inside GB' 5 = 'Northern Ireland' 6 = 'Outside LGD, but within NI (NI only)' 7 = 'Outside NI, but within UK (NI only)' 8 = 'Outside UK (GB only)' 9 = 'Outside UK (NI only)' ; value NSSEC8F -9 = 'not applicable/not defined' 1 = '1.1 Large employers & higher managerial occupations' 2 = '1.2 Higher professonal occupations' 3 = '2 Lower managerial and professional occupations' 4 = '3 Intermediate occupations' 5 = '4 Small employers and own account workers' 6 = '5 Lower supervisory and technical occupations' 7 = '6 Semi-routine' 8 = '7 Routine occupations' 9 = '8 Never workerd and long-term unemployed' ; value DFTOTAL -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFMJURB -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFLGURB -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFOTHURB -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFTOTURB -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFLGMTWN -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFRUTNP1F -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFRUTNP2F -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFVILP -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFDISP -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFTOTRUPA -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DFTOTRUPB -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' ; value DEFRA -99 = 'NA: Penwith/Scilly' -98 = 'NA: Westmin/City' -9 = 'NA: Scot/Wales/NI' 1 = 'MU' 2 = 'LU' 3 = 'OU' 4 = 'SR' 5 = 'R50' 6 = 'R80' ; proc datasets library = mysam ; modify uksam2001; format COUNTRY COUNTRY.; format LACODE LACODE.; format POPBASEA POPBASEA.; format ACCTYPA ACCTYPA.; format AGEA AGEA.; format BATHWC BATHWC.; format CARSH CARSH.; format CEMTYP CEMTYP.; format CENHEAT0 CENHEAT0F.; format CESTSTAT CESTSTAT.; format COBIRTA COBIRTA.; format COMBGN COMBGN.; format DENSITYA DENSITYA.; format DISTMOVA DISTMOVA.; format DISTWRKA DISTWRKA.; format ECONACH ECONACH.; format EDISDONO EDISDONO.; format ETHEWA ETHEWA.; format ETHN ETHN.; format ETHSA ETHSA.; format EVERWORK EVERWORK.; format FAMTYPA FAMTYPA.; format FNDEPCHA FNDEPCHA.; format FRECONAC FRECONAC.; format FRNSSEC8 FRNSSEC8F.; format FRSEX FRSEX.; format FURN FURN.; format GENIND GENIND.; format HEALTH HEALTH.; format HEDIND HEDIND.; format HEMPIND HEMPIND.; format HHSGIND HHSGIND.; format HHTLHIND HHTLHIND.; format HMPTPUK HMPTPUK.; format HNCARERS HNCARERS.; format HNEARNRA HNEARNRA.; format HNLLTI HNLLTI.; format HNPRHLTH HNPRHLTH.; format HNRESIDA HNRESIDA.; format HOURSPWG HOURSPWG.; format HRSOCGRD HRSOCGRD.; format LASTWRKA LASTWRKA.; format LLTI LLTI.; format LOWFLORA LOWFLORA.; format MARSTATA MARSTATA.; format MIGINDA MIGINDA.; format MIGORGN MIGORGN.; format OCCUPNCY OCCUPNCY.; format ONCPERIM ONCPERIM.; format PROFQUAL PROFQUAL.; format PROVCARE PROVCARE.; format QUALVEWN QUALVEWN.; format QUALVS QUALVS.; format REGIONA REGIONA.; format RELGEW RELGEW.; format RELGN RELGN.; format RELGS1 RELGS1F.; format RELTOHRA RELTOHRA.; format ROOMSFLR ROOMSFLR.; format ROOMSNUM ROOMSNUM.; format SELFCONT SELFCONT.; format SEX SEX.; format STAHUKA STAHUKA.; format STUDENT STUDENT.; format SUPERVSR SUPERVSR.; format TENUREWA TENUREWA.; format TENURSNA TENURSNA.; format TERMTIMA TERMTIMA.; format TRANWRKA TRANWRKA.; format WORKFORC WORKFORC.; format WRKPLCEA WRKPLCEA.; format NSSEC8 NSSEC8F.; format DFTOTAL DFTOTAL.; format DFMJURB DFMJURB.; format DFLGURB DFLGURB.; format DFOTHURB DFOTHURB.; format DFTOTURB DFTOTURB.; format DFLGMTWN DFLGMTWN.; format DFRUTNP1 DFRUTNP1F.; format DFRUTNP2 DFRUTNP2F.; format DFVILP DFVILP.; format DFDISP DFDISP.; format DFTOTRUPA DFTOTRUPA.; format DFTOTRUPB DFTOTRUPB.; format DEFRA DEFRA.; quit; proc freq data=mysam.uksam2001; tables wrkplcea; run; data mysam.mysam2001(compress=yes); set mysam.uksam2001; *in greater london, age 20 to 64, not in communal establishment or non-usual residents; *note sec defined only for family reference persons; where (lacode<33) and (agea>16 and agea<65) and (famtypa ne -9) and (frnssec8 ne -9) and (frnssec8 ne 9) and (frnssec8 ne 10); rev_own=1; if tenurewa=1 then rev_own=0; label rev_own="rev dummy for home ownership"; rev_mov=1; if miginda ne 0 then rev_mov=0; label rev_mov="rev dummy for moved"; run; proc sort data=mysam.mysam2001; by lacode; run; ***Ownership Models for Household Reference Persons; proc logistic data=mysam.mysam2001 simple; class frsex hourspwg hnearnra famtypa miginda frnssec8; model rev_own=frsex hourspwg hnearnra famtypa miginda frnssec8 / expb rsquare; title "London Home Ownership Models for Greater London Region"; run; proc logistic data=mysam.mysam2001 outest=mysam.ownmods noprint; class frsex hourspwg hnearnra famtypa miginda frnssec8; model rev_own=frsex hourspwg hnearnra famtypa miginda frnssec8 / expb rsquare; title "London Home Ownership Models by LA"; by lacode; run; ***Ownership Models for those who just moved in within the last year; proc logistic data=mysam.mysam2001 simple; where miginda ne 0; class frsex hourspwg hnearnra famtypa frnssec8; model rev_own=frsex hourspwg hnearnra famtypa frnssec8 / expb rsquare; title "Ownership Model for Recent Movers for Greater London Region"; run; proc logistic data=mysam.mysam2001 outest=mysam.ownmov noprint; where miginda ne 0; class frsex hourspwg hnearnra famtypa frnssec8; model rev_own=frsex hourspwg hnearnra famtypa frnssec8 / expb rsquare; title "Ownership Model for Recent Movers by LA"; by lacode; run; ***Models predicting who moved into their homes in the last year; proc logistic data=mysam.mysam2001 simple; class frsex hourspwg hnearnra famtypa frnssec8; model rev_mov=frsex hourspwg hnearnra famtypa rev_own frnssec8 / expb rsquare; title "Mobility Model for Greater London Region"; run; proc logistic data=mysam.mysam2001 outest=mysam.movmods noprint; class frsex hourspwg hnearnra famtypa frnssec8; model rev_mov=frsex hourspwg hnearnra famtypa rev_own frnssec8 / expb rsquare; title "Mobility Model by LA"; by lacode; run;