title1 PCCF - 2001 census geography, 1 record per postal code; title2 SAS commands by L Ruus, UT/DLS, rev. 2005/06; options ls=80 ps=62 obs=max compress=yes; libname lib 'c:\temp\pccf'; libname library 'c:\temp\pccf'; filename in 'c:\temp\pccf\ont_jul04.dat' lrecl=212; proc format library=library; value rp 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' ; value 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' ; value sli 0 = 'additional record' 1 = 'best/only record' ; value sac 0 = 'Territories' 001 = 'St. Johns' 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' 997 = 'moderately influenced' 998 = 'weakly influenced' 999 = 'not influenced' ; value sactype 1 = 'CMA' 2 = 'tracted CA' 3 = 'non-tracted CA' 4 = 'strongly influenced' 5 = 'moderately influenced' 6 = 'weakly influenced' 7 = 'not influenced' 8 = 'Territories' / value uaratype 1 = 'urban core' 2 = 'urban fringe' 3 = 'rural,in CMA/CA' 4 = 'urban,outside CMA/CA' 5 = 'rural,outside CMA/CA' 6 = 'secondary urban core' ; value reppoint 1 = 'block face rep point' 2 = 'block rep point' 3 = 'DA rep point' ; value pctype 1 = 'street w carrier' 2 = 'street w route service' 3 = 'post office box' 4 = 'route service' 5 = 'general delivery' 0 = 'unknown' ; value $dmt 'A' = 'block face address' 'B' = 'apartment building' 'E' = 'business building' 'G' = 'large vol receiver' 'H' = 'del via rural route' 'J' = 'general delivery' 'K' = 'del to PO box' 'M' = 'lge vol PO box' 'T' = 'via suburban service' 'W' = 'rural postal codes' 'X' = 'via mobile route' 'Z' = 'retired' ; value $hdmt 'A' = 'block face address' 'B' = 'apartment building' 'E' = 'business building' 'G' = 'large vol receiver' 'H' = 'del via rural route' 'J' = 'general delivery' 'K' = 'del to PO box' 'M' = 'lge vol PO box' 'T' = 'via suburban service' 'W' = 'rural postal codes' 'X' = 'via mobile route' 'Z' = 'retired' ; data lib.pccf04j; infile in missover; input postcode $ 1-6 dauid 7-14 rp 15-16 cd 17-18 da 19-22 block 23-24 lat 25-33 long 34-44 sli 45 pr 46-47 cduid 48-51 csd 52-54 csdname $ 55-124 csdtype $ 125-127 ccs 128-130 sac 131-133 sactype 134 ctname 135-141 ercode 142-143 dpl 144-147 fed96uid 148-152 uara 153-156 uaratype 157-157 reppoint 158 pctype 159 commname $ 160-189 dmt $ 190 hdmt $ 191 birthyr 192-195 birthmo 196-197 birthdy 198-199 retireyr 200-203 retiremo 204-205 retiredy 206-207 fed03uid 208-212; label postcode = 'Postal code'; label dauid = 'Dissemination area unique identifier'; label rp = 'Region/province/territory code'; label cd = 'Census division'; label da = 'Dissemination area'; label block = 'Block'; label lat = 'Latitude'; label long = 'Longitude'; label sli = 'Single link indicator'; label pr = 'Province/territory code'; label cduid = 'Census division unique identifier'; label csd = 'Census subdivision code'; label csdname = 'Census subdivision name'; label csdtype = 'Census subdivision type'; label ccs = 'Census consolidated subdivision'; label sac = 'Statistical area classification code (incl. CMA/CA)'; label sactype = 'Statistical area classification type (incl. CMA/CA)'; label ctname = 'Census tract name'; label ercode = 'Economic region (ER) code'; label dpl = 'Designated place (DPL) code'; label fed96uid = 'Federal electoral district (1996 Rep Order) identifier'; label uara = 'Urban areas rural areas code'; label uaratype = 'Urban areas rural areas type'; label reppoint = 'Representative point flag'; label pctype = 'Postal code type'; label commname = 'Community name'; label dmt = 'Delivery mode type (CMT)'; label hdmt = 'Historic delivery mode type (DMT)'; label birthyr = 'Birth date: year (YYYY)'; label birthmo = 'Birth date: month (MM)'; label birthdy = 'Birth date: day (DD)'; label retireyr = 'Retired date: year (YYYY)'; label retiremo = 'Retired date: month (MM)'; label retiredy = 'Retired date: day (DD)'; label fed03uid = 'Federal electoral district (2003 Rep Order) identifier'; run;