title1 PCCF - 1996 census geography, 1 record per postal code;
title2 SAS commands by L Ruus, UT/DLS, 05/2003;
options ls=80 ps=62 obs=max compress=yes ;
libname lib '../sasdata';
libname library '../sasdata';
filename in pipe 'zcat ont.dat.Z' lrecl=190;

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 rp2 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 rp3 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 rp4 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  cmatype = 'A' = 'consolidated CMA' 
  'B' = 'regular CMA' 'C' = 'consolidated CA'
  'D' = 'regular CA' ; 
value  pcmatype 'E' = 'PCMA' 'F' = 'PCA' ; 
value  rurban 1 = 'urban core' 2 = 'urban fringe'
  3 = 'rural fringe' 4 = 'urban,outside CMA/CA' 
  5 = 'rural,outside CMA/CA' ; 
value  rpf 1 = 'bf rep point,SNF'
  2 = 'EA rep point,SNF' 3 = 'EA rep point,non-SNF'
  4 = 'historic bf rep point' ; 
value  pct 1 = 'street w carrier' 2 = 'street w route service'
  3 = 'post office box' 4 = 'route service' 5 = 'general delivery'
  0 = 'unknown' ; 
data lib.pccfnov01; 
infile in missover lrecl=190;
input
 POSTCODE   $  1 -     6   
 RP            7 -     8  
 FED87         9 -    11 
 EA87         12 -    14 
 LAT          15 -    23 .6 
 LONG         24 -    34 .6 
 SLI          35 -    35 
 RP2          36 -    37 
 RP3          38 -    39 
 CD           40 -    41 
 CSDCODE      42 -    44 
 CSDNAME   $  45 -   101  
 CSDTYPE   $ 102 -   104  
 CCS         105 -   107 
 CMA         108 -   110 
 CMATYPE   $ 111 -   111  
 PCMA        112 -   114 
 PCMATYPE  $ 115 -   115 
 CTNAME      116 -   122 
 ERCODE      123 -   124 
 DPL         125 -   127 
 RP4         128 -   129 
 FED96       130 -   132 
 RURBAN      133 -   133 
 RPF         134 -   134 
 PCT         135 -   135 
 COMMNAME  $ 136 -   165 
 DMT       $ 166 -   166  
 HDMT      $ 167 -   167  
 BIRTH     $ 168 -   175  
 RETIREYR    176 -   179 
 RETIREMO    180 -   181 
 RETIREDY    182 -   183 
 COUNT       184 -   190 ;
 
label  postcode = 'Postal code'; 
label  rp = 'Region and province (1987 representation order)';
label  fed87 = 'Federal electoral district (1987 representation order)';
label  ea87 = 'Enumeration area (1987 representation order)';
label  lat = 'Latitude';
label  long = 'Longitude';
label  sli = 'Single link indicator'; 
label  rp2 = 'Region and province (1987 representation order)';
label  rp3  = 'Region and province (1987 representation order)';
label  cd = 'Census division unique identifier';
label  csdcode = 'Census subdivision code';
label  csdname = 'Census subdivision name';
label  csdtype = 'Census subdivision type';
label  ccs = 'Census consolidated subdivision code';
label  cma = 'Census metropolitan area; census agglomeration code';
label  cmatype = 'Census metropolitan area; census agglomeration type';
label  pcma = 'Primary census metropolitan area; census agglomeration code';
label  pcmatype = 'Primary census metropolitan area; census agglomeration type';
label  ctname = 'Census tract name';
label  ercode = 'Economic region code';
label  dpl = 'Designated place code';
label  rp4  = 'Region and province (1996 representation order)';
label  fed96 = 'Federal electoral district (1996 representation order)';
label  rurban = 'Enumeration area urban/rural type';
label  rpf = 'Representative point flag';
label  pct = 'Postal code type';
label  commname = 'Community name';
label  dmt = 'Delivery mode type';
label  hdmt = 'Historical delivery mode type';
label  birth = 'Birth date';
label  retireyr = 'Retired date - year';
label  retiremo = 'Retired date - month';
label  retiredy = 'Retired date - day';
label  count = 'Count of postal code-enumeration area records';
run;