** This is SAS code for defining Regional Health Authorities (RHAs) ; ** in Manitoba ; If both postal code and municipal code are available on the data that you are using, then the _rha macro can be used to define RHAs. There have been two updates to this macro that represent changes to the boundaries for 2003 and 2004. Unless there is a good reason then the current macro should be used (_rha05). This macro uses a format for municipal areas since 1989/90. If you want to define RHA like areas prior to 1989/90, then see the second note below. **** The following is example code - use the appropriate SAS macro instead ; if substr(muncode,1,1) ^='A' then region = put(muncode,$rhaf.) ; else if substr(muncode,1,1) = 'A' ; put(&muncode||postal,$apostf.) = '1' then ®ion = put(muncode,$rhaf.) ; else ®ion = put(put(postal,$postmun.),$rhaf.) ; if postal = 'R0E0N0' then region='BS' ; if region='K' & postal in('R0H0A0','R0H0L0','R0H0N0','R0H1M0','R0J1B0') then region='E' ; if region='A' & postal ='R0B0J0' then region='A' ; Formats used: $rhaf - 2002/3 RHA definition $rha05f - 2003/04 RHA definition (at the RHA level there is no difference between 2003 and 2005) $assocf - 1989/90-2001/2002 $asso89f pre-1989 uncial codes $postmun. Postmun is the default, but it may be year specific see format pmunXXf (where XX is a given year). This format represents the primary municipal code for known postal codes and is developed from the Manitoba Health Postmun file. $apostf. This format associates each A-code type municipal code with the appropriate postal code(s). $rhal Labels for all years of RHA formats. Notes: In 1989/90 there was a change of municipal codes. Some area definitions from before this time (Norman, Parkland and Burntwood) do not match current RHA boundaries. Even after 1989/90, there have been several changes to the RHA boundaries, and users should know which set of boundaries they want. If you are using data prior to 1989, please see the SAS code file: RHA_1989_fix.sas.txt Postal code 'R0E0N0' should be placed in South Eastman if municipal area 290 exists. After 1995/96 the municipal areas 288 and 289 divide North and South Eastman. In 1997 the postal code for Buffalo Point (R0A2W0) was put in North Eastman by municipal code it should be assigned to South Eastman with muncode 289. Typically this is not a problem since most most of the individuals living there are assigned by postal code not municipal code. There are RHA codes already on both the Medical and Hospital data since 1997/98. These represent the boundaries of the RHAs at that time, remember that boundaries may change over time. Two variables are also recorded: RHAPOST, the RHA as defined by the postal code, and RHAMUN, RHA as defined by uncial code. The RHA for individuals with an 'A-code' municipal code should use a combination of postal/municipal code to define location of residence. See the concept titled Manitoba Health Registration System for more information on how mun-of-post is assigned. Each RHA has been further divided into subregions or districts at various times. See concepts on Physician Service Areas and RHA Distrticts. Unless comparisons with earlier work are needed users should be using the RHA districts. Headingley In May 1993, Headingley seceded from Winnipeg to become its own independent municipality. The Headingley Chamber of Commerce website explains that Winnipeg 'consistently under-serviced the community despite the substantial amount of tax the residents paid, prompting their decision to split off. Prior to 1993 it was part of Winnipeg (in muncode 320), and its residents were grouped into Winnipeg RHA. 1993 and later they are grouped with Central RHA (muncode 321). For longitudinal studies spanning 92/93 it is probably best to assign Headingley to either Winnipeg or Central for the duration of the study. This avoids changes in the denominator which may interfere with the analysis. This can be done using the postal code R0H0J0. * move postal=R0H0J0 rha='K' into Central; if rha='K' and postal='R0H0J0' then do; rha='A'; district='A4'; end; Alonsa The boundary between Parkland and Central was changed October 4, 2002 - this change has been reflected in the MH data since April 2003. If you want to create current RHA boundaries for longitudinal projects prior to this data the following postal codes should be put into Parkland. The number of individuals is very small so this change could probably also be ignored when rates based analyses are run. * move postal R0H0A0, R0H1M0 into Parkland ; if rha='A' and postal in('R0H0A0','R0H0L0','R0H0N,'R0H1M0','R0J1B0') then do ; rha='E' ; district='E2' ; end ;