SEFI SAS Programs
Date: October, 2001
Several SAS programs available on the MCHP data analysis host (healthsys)
were used to develop the SEFI scores. The programs include comparisons
to the original SERI scores and a substantial number of data checks.
-
Conversion from Beyond 20/20 Statistics Canada format files to SAS files.
This was done primarily by saving the Beyond 20/20 files in DB2 format
and reading the files directly into SAS (there are no SAS programs for
this step). Data is located in /project/ses/prog/dfriesn/census96.tar.
-
Creation of socio-economic variables was done using the program socecvar.sas
which is available in: /project/ses/prog/dfriesn/socec.tar
-
SEFI was calculated using the following steps and programs. Except
where noted, all of the programs are found in /home/sderksn/ses_factor.
Some modifications were made when adding the Winnipeg NRNs.
i. Aggregation to municipality code level using the SAS
program
muncode96.sas.
This program assigns municipal numbers to each enumeration area and imputes
data for missing variables. Winnipeg areas were defined as part of
the municipal variable in the range of 501-525 using the format
/home/burchil/ses_factor/ea_nrnf.
The NRN were given 3 character municipal values as listed below:
value $cvertn
"W002"="501"
"W006"="502"
"W01A"="503"
"W01B"="504"
"W03A"="505"
"W03B"="506"
"W04A"="507"
"W05A"="509"
"W05B"="510"
"W07A"="511"
"W07B"="512"
"W07C"="513"
"W07D"="514"
"W08A"="515"
"W08B"="516"
"W08C"="517"
"W09A"="518"
"W09B"="519"
"W10A"="520"
"W10B"="521"
"W11A"="522"
"W11B"="523"
"W12A"="524"
"W12B"="525" ;
ii.Derive the unemployment factor at the municipal level using unmr_96.sas
iii.Derive the education factor at the municipal level using
edhp_96.sas
iv.Calculate the SEFI score at the municipal level using principal
component analysis using the program sesind_munc96.sas.
v.Obtain the provincial population for each municipal area
and define the larger areas using sesind_muncode.sas.
The population is used to weight the mean SEFI score for the aggregated
areas.
vi. Calculate the mean population weighted SEFI at larger aggregated areas using
sesind_rha96_2.sas.
Contact: