title Postal code convervion file (2006 census geography).
subtitle SPSS syntax L Ruus, UT/DLS 2007/10, rev 2009-04.
file handle in 
 / inpipe 'zcat /cstdli/pccf_apr07/national/pccf_nat_apr07.txt.Z' 
 / lrecl=215.
data list file=in / 
  postcode 1-6 (a)
  fsa 7-9 (a)
  pr 10-11
  cduid 12-15
  cd 14-15
  csduid 16-22
  csd 20-22
  csdname 23-92 (a)
  csdtype 93-95 (a)
  ccscode 96-98
  sac 99-101
  sactype 102-102
  ctname 103-109
  er 110-111
  dpl 112-115
  fed03uid 116-120
  fed03 118-120
  uara 121-124
  uaratype 125-125
  dauid 126-133
  da 130-133
  block 134-135
  rptype 136-136
  lat 137-147
  long 148-160
  sli 161-161
  pctype 162-162
  commname 163-192 (a)
  dmt 193-193 (a)
  hdmt 194-194 (a)
  birthyr 195-198
  birthmo 199-200
  birthdy 201-202
  retireyr 203-206
  retiremo 207-208
  retiredy 209-210
  po 211-211 
  qi1 212 (a)
  qi2 213 (a)
  qi3 214 (a)
  source 215-215.
format ctname (f7.2).
variable labels
  postcode 'Postal code'
  fsa 'Forward sortation area'
  pr 'Region/province/territory code'
  cduid 'Census division unique identifier (pr(2)+cd(2))'
  cd 'Census division code'
  cxduid 'Census subdivision unique identifier (pr(2)+cd(2)_csd(3))'
  csd 'Census subdivision code'
  csdname 'Census subdivision name'
  csdtype 'Census subdivision type'
  ccscode 'Census consolidated subdivision'
  sac 'Statistical area classification code (incl. CMA/CA)'
  sactype 'Statistical area classification type (incl. CMA/CA)'
  ctname 'Census tract name'
  er 'Economic region (ER) code'
  dpl 'Designated place (DPL) code'
  fed03uid 'Federal electoral district (2003 RO) unique identifier (pr(2)+fed03(3))'
  fed03 'Federal electoral district (2003 Rep Order) code'
  uara 'Urban areas rural areas code'
  uaratype 'Urban areas rural areas type'
  dauid 'Dissemination area unique identifier (pr(2)+cd(2)_da(4))'
  da 'Dissemination area code'
  block 'Dissemination block'
  rptype 'Representative point type'
  lat 'Latitude of representative point'
  long 'Longitude of representative point'
  sli 'Single link indicator'
  pctype 'Postal code type'
  commname 'Community name'
  dmt 'Delivery mode type (CMT)'
  hdmt 'Historic delivery mode type (DMT)'
  birthyr 'Birth date: year (YYYY)'
  birthmo 'Birth date: month (MM)'
  birthdy 'Birth date: day (DD)'
  retireyr 'Retired date: year (YYYY)'
  retiremo 'Retired date: month (MM)'
  retiredy 'Retired date: day (DD)'
  po 'Delivery installation'
  qi1 'Quality of geocoding to CSD' 
  qi2 'Quality of geocoding to street' 
  qi3 'Quality of geocoding to address range' 
  source 'Source of geocoding'.
value labels
  pr 10 'Newfoundland'
     11 'Prince Edward Island'
     12 'Nova Scotia'
     13 'New Brunswick'
     24 'Quebec'
     35 'Ontario'
     46 'Manitoba'
     47 'Saskatchewan'
     48 'Alberta'
     59 'British Columbia'
     60 'Yukon Territory'
     61 'NWT' 62 'Nunavut' /
 sli 0 'additional record' 1 'best/only record' /
 sac 
     0 'Territories' 
   001 'St. Johns'
   005 'Bay Roberts' 
   010 'Grand Falls-Windsor' 
   011 'Gander' 
   015 'Corner Brook' 
   025 'Labrador City' 
   105 'Charlottetown' 
   110 'Summerside' 
   205 'Halifax' 
   210 'Kentville' 
   215 'Truro' 
   220 'New Glasgow' 
   225 'Cape Breton' 
   305 'Moncton' 
   310 'Saint John' 
   320 'Fredericton' 
   328 'Bathurst' 
   330 'Campbellton' 
   335 'Edmundston' 
   403 'Matane' 
   404 'Rimouski' 
   405 'Rivière-du-Loup' 
   406 'Baie-Comeau' 
   408 'Chicoutimi - Jonquière' 
   410 'Alma' 
   411 'Dolbeau-Mistassini' 
   412 'Sept-Îles' 
   421 'Québec' 
   428 'Saint-Georges' 
   430 'Thetford Mines' 
   433 'Sherbrooke' 
   435 'Magog' 
   437 'Cowansville' 
   440 'Victoriaville' 
   442 'Trois-Rivières' 
   444 'Shawinigan' 
   446 'La Tuque' 
   447 'Drummondville' 
   450 'Granby' 
   452 'Saint-Hyacinthe' 
   454 'Sorel-Tracy' 
   456 'Joliette' 
   459 'Saint-Jean-sur-Richelieu' 
   462 'Montréal' 
   465 'Salaberry-de-Valleyfield' 
   468 'Lachute' 
   480 'Val-dOr' 
   481 'Amos' 
   485 'Rouyn-Noranda' 
   501 'Cornwall' 
   502 'Hawkesbury' 
   505 'Ottawa - Hull' 
   512 'Brockville' 
   515 'Pembroke' 
   516 'Petawawa' 
   521 'Kingston' 
   522 'Belleville' 
   527 'Cobourg' 
   528 'Port Hope and Hope' 
   529 'Peterborough' 
   530 'Kawartha Lakes' 
   532 'Oshawa' 
   535 'Toronto' 
   537 'Hamilton' 
   539 'St. Catharines - Niagara' 
   541 'Kitchener' 
   543 'Brantford' 
   544 'Woodstock' 
   546 'Tillsonburg' 
   547 'Norfolk' 
   550 'Guelph' 
   553 'Stratford' 
   555 'London' 
   556 'Chatham-Kent' 
   557 'Leamington' 
   559 'Windsor' 
   562 'Sarnia' 
   566 'Owen Sound' 
   567 'Collingwood' 
   568 'Barrie' 
   569 'Orillia' 
   571 'Midland' 
   575 'North Bay' 
   580 'Greater Sudbury' 
   582 'Elliot Lake' 
   584 'Haileybury' 
   586 'Timmins' 
   590 'Sault Ste. Marie' 
   595 'Thunder Bay' 
   598 'Kenora' 
   602 'Winnipeg' 
   607 'Portage la Prairie' 
   610 'Brandon' 
   640 'Thompson' 
   705 'Regina' 
   710 'Yorkton' 
   715 'Moose Jaw' 
   720 'Swift Current' 
   725 'Saskatoon' 
   735 'North Battleford' 
   745 'Prince Albert' 
   750 'Estevan' 
   805 'Medicine Hat' 
   806 'Brooks' 
   810 'Lethbridge' 
   825 'Calgary' 
   830 'Red Deer' 
   833 'Camrose' 
   835 'Edmonton' 
   840 'Lloydminster' 
   845 'Cold Lake' 
   850 'Grande Prairie' 
   860 'Wood Buffalo' 
   865 'Wetaskiwin' 
   905 'Cranbrook' 
   913 'Penticton' 
   915 'Kelowna' 
   918 'Vernon' 
   925 'Kamloops' 
   930 'Chilliwack' 
   932 'Abbotsford' 
   933 'Vancouver' 
   934 'Squamish' 
   935 'Victoria' 
   937 'Duncan' 
   938 'Nanaimo' 
   939 'Parksville' 
   940 'Port Alberni' 
   943 'Courtenay' 
   944 'Campbell River' 
   945 'Powell River' 
   950 'Williams Lake' 
   952 'Quesnel' 
   955 'Prince Rupert' 
   960 'Kitimat' 
   965 'Terrace' 
   970 'Prince George' 
   975 'Dawson Creek' 
   977 'Fort St. John' 
   990 'Whitehorse' 
   995 'Yellowknife' 
   996 'strongly influenced zone' 
   997 'moderately influenced zone'  
   998 'weakly influenced zone' 
   999 'no influence zone' /
 sactype
  1 'CMA' 2 'tracted CA' 3 'non-tracted CA' 4 'strongly influenced zone' 
  5 'moderately influenced zone' 6 'weakly influenced zone' 
  7 'no influence zone' 8 'Territories' /
 uaratype 0 'rural area' 1 'urban core' 2 'urban fringe'
  4 'urban,outside CMA/CA' 6 'secondary urban core' /
 rptype 1 'block face' 2 'dissemination block' 
  3 'dissemination area' /
 sli 1 'active postal code' 0 'additional records' /
 pctype 1 'street w carrier service' 2 'street w route service'
  3 'post office box' 4 'route service' 5 'general delivery'
  0 'unknown' /
 dmt hdmt 'A' 'block face address'
     'B' 'apartment building'
     'E' 'business building'
     'G' 'large vol receiver'
     'H' 'del via rural route'
     'J' 'general delivery'
     'K' 'delivery to PO box'
     'M' 'del to large vol receiver'
     'T' 'via suburban service'
     'W' 'rural postal codes'
     'X' 'delivery via mobile route'
     'Z' 'retired' / 
  po 1 'post office/other' 2 'unknown' 
     3 'accessed at post office' 
     5 'accessed at post office'  /
  qi1 
     'A' 'good, verifiable geocoding'
     'B' 'good, search area cc06 based'
     'C' 'satisfactory approximation' 
     'N' 'unknown' /
  qi2 
     'A' 'good, matched'
     'B' 'good, matched street name & type only'
     'C' 'satisfactory matched street name' 
     'N' 'unknown' /
  qi3 
     'A' 'good, matched on both addresses'
     'B' 'good, matched on one address'
     'C' 'satisfactory' 
     'N' 'no match' /
  source 1 'automated geocoding' 
     2 'geocoded using 2006 census response'
     3 'converted from 2001 geocoding' 
     4 'manually geocoded' .
execute.
finish.