title1 Postal code conversion file, STC May 1998 edition;
title2 UT/DLS ed. SAS control commands 03/2002;
options ls=80 ps=62 obs=max compress=yes;
libname lib 'sasdata';
libname library 'sasdata';
filename in pipe 'zcat pccf11.TXT.Z' lrecl=183; 
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';
value  rp2f
     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';
value  rp3f 
     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';
value  rp4f 
     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';
value sli 0='additional record' 1='best/only record' ;
value $cmatype 'A'='consolidated CMA' 
  'B'='regular CMA' 'C'='consolidated CA'
  'D'='regular CA' ;
value $pcmatyp '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.pccf9805;
infile in missover lrecl=183;
input
  postcod $ 1-6 
  rp 7-8
  fed87 9-11
  ea87 12-14
  lat 15-23 
  long 24-34
  sli 35
  rp2f 36-37
  rp3f 38-39
  cd 40-41
  csdcode 42-44
  csdname $ 45-101 
  csdtype $ 102-104 
  ccs 105-107
  cma 108-110
  cmatype $ 111
  pcma 112-114
  pcmatyp $ 115 
  ctname 116-122
  ercode 123-124
  dpl 125-127
  rp4f 128-129
  fed96 130-132
  rurban 133
  rpf 134
  pct 135
  commnam $ 136-165 
  dmt $ 166 
  hdmt $ 167 
  birth $ 168-175 
  retire $ 176-183 ;
label
  postcod="Postal code"
  rp="Region and province (1987 representation order)"
  rp2f="Region and province (1987 representation order)"
  rp3f="Region and province (1987 representation order)"
  fed87="Federal electoral district (1987 representation order)"
  ea87="Enumeration area (1987 representation order)"
  lat="Latitude"
  long="Longitude"
  sli="Single link indicator" 
  cd="Census division unique identifier"
  csdcode="Census subdivision code"
  csdname="Census subdivision name"
  csdtype="Census subdivision type"
  ccs="Census consolidated subdivision code"
  cma="Census metropolitan area/census agglomeration code"
  cmatype="Census metropolitan area/census agglomeration type"
  pcma="Primary census metropolitan area/census agglomeration code"
  pcmatyp="Primary census metropolitan area/census agglomeration type"
  ctname="Census tract name"
  ercode="Economic region code"
  dpl="Designated place code"
  rp4f ="Region and province (1996 representation order)"
  fed96="Federal electoral district (1996 representation order)"
  rurban="Enumeration area urban/rural type"
  rpf="Representative point flag"
  pct="Postal code type"
  commnam="Community name"
  dmt="Delivery mode type"
  hdmt="Historical delivery mode type"
  birth="Birth date"
  retire="Retired date";
run;
proc freq; tables rp; run;