User's Guide for Cross-Sectional Public-Use
Contents
1. Confidentiality of the Public Use Microdata The production of a public use microdata file includes many safeguards to prevent the identification of any one person Longitudinal surveys are faced with an extra challenge when it comes to ensuring confidentiality because data are collected for the same people for several years For this reason Statistics Canada plans to release only cross sectional files from SLID The number of topics covered in SLID also contributes to the amount of processing required specifically to ensure confidentiality Confidentiality of the public use file is ensured mainly by reducing information i e deleting whole variables or suppressing or collapsing some of their detail SLID uses a number of techniques to ensure confidentiality The SLID public use file is comprised of a sample of the households randomly selected from the full SLID sample e All the variables which would permit direct identification of individuals are of course deleted from the file This includes name telephone number and other data used for collection purposes e Collapsing categories This is applied to categorical i e qualitative variables such as the variable size of area of residence e Top and bottom coding Very high and very low values usually are rare or unique in the population Such extreme values are replaced with the value of an upper or lower limit Statistics Canada 12 Catalogue no 75F0002M e Rounding Som2. Introduction The guidelines for release and publication make use of the concept of sampling variability to determine whether the estimates obtained from the microdata are reliable Sampling variability is the error in the estimates caused by the fact that we survey a sample rather than the entire population The concept of standard error and the related concept of coefficient of variation and confidence interval provide an indication of the magnitude of the sampling variability The standard error and coefficient of variation do not measure any systematic biases in the survey data which might affect the estimate Rather they are based on the assumption that the sampling errors follow a normal probability distribution Subject to this assumption it is possible to estimate the extent to which different samples that have the same design and the same number of observations would give different results This indicates the margin of error that is likely to be included in the estimates derived from our single sample For a more complete description of the measures of sampling variability see A Satin and W Shastry Survey Sampling A Non Mathematical Guide Statistics Canada Catalogue 12 602E Minimum sizes of estimates for release Suppression rules or data reliability cut offs are currently established based on the sample size that underlies the estimate In general a sample size of 25 observations is required for the estimate to be publish
3. Working Income Supplement WIS National Child Benefit Supplement NCBS chprv42 Numeric 8 0 75 200 Total provincial child benefits chtxb42 Numeric 8 0 76 208 Total federal amp provincial child benefits cpqpp42 Numeric 8 0 77 216 Canada Pension Plan and Quebec Pension Plan benefits cqpc42 Numeric 8 0 78 224 Canada and Quebec Pension Plan contributions earng42 Numeric 8 0 79 232 Earnings eipr42 Numeric 8 0 80 240 Employment Insurance contributions fditx42 Numeric 8 0 81 248 Federal income tax fmse42 Numeric 8 0 82 256 Farm self employment net income including farm program gstxc42 Numeric 8 0 83 264 Federal Goods and Services Tax Harmonized Sales Tax Credit excludes provincial sales tax credit gtr42 Numeric 8 0 84 272 Government transfers federal and provincial inctx42 Numeric 8 0 85 280 Income tax federal plus provincial inva42 Numeric 8 0 86 288 Investment income majri42 Character 2 87 296 Major source of income mbinc42 Numeric 8 0 88 298 Disposable income for Market basket measure of poverty medx42 Numeric 8 0 89 306 Direct medical expenses mtinc42 Numeric 8 0 90 314 Market income nfmse42 Numeric 8 0 91 322 Non farm self employment net income oasgi42 Numeric 8 0 92 330 Total of Old Age Security benefits ottxm42 Numeric 8 0 93 338 Other other income pen42 Numeric 8 0 94 346 Private retirement pensions phpr42 Numeric 8 0 95 354 Public health insurance premiums pvitx42 Numeric 8 0 96 362 Provincial income tax pvt
4. puchid25 Character 7 1 1 Cross sectional random household identifier 01110 Sample control Identifiers Year year99 Numeric 4 0 2 8 Reference year 01120 Sample control Identifiers Economic Family d31fam26 Character 2 3 12 Economic family identifier 01200 Sample control Weights icswt26 Decimal 10 4 4 14 Regular cross sectional weight 03140 Personal characteristics Demographics Family situation mjieh27 Character 1 5 24 Flag Economic family includes major income earner of household reference year 03510 Personal characteristics Geography Geographic area pvreg25 Character 2 6 25 Province of residence group household December 31 reference year uszga25 Character 1 7 27 Adjusted size of area of residence 03630 Personal characteristics Family and household characteristics Economic family size and type agofm27 Numeric 3 0 8 28 Age of oldest person in economic family agofmg27 Character 2 9 31 Age group of oldest person in economic family agyfm27 Numeric 3 0 10 33 Age of youngest person in economic family agyfmg27 Character 2 11 36 Age group of youngest person in econmic family fmcomp27 Character 2 12 38 Economic family composition fmsz27 Numeric 2 0 13 40 Number of family members Statistics Canada 14 Catalogue no 75F0002M Start Variable name Type Size Field re Long name position fmtyp27 Character 2 14 42 Economic family type reference person 03640 Personal characteris
5. Although the end solution may be to exclude the records with missing values from the analysis a review should first be carried out to assess the impact of missing values on the overall representativeness of the data Is it possible that a bias results from the missing data For example are the other characteristics of the people with missing values different from those of the observed part of the sample It may be necessary to take into account the possible impact in some way In all cases analysts should note exclusions of records with missing values in their published results Statistics Canada 8 Catalogue no 75F0002M 4 Guidelines for Applying Weights The microdata on the public use files are unweighted It is the responsibility of data users to apply the appropriate weights in any estimates they wish to produce If proper weights are not used the results derived from the microdata cannot be considered to be representative of the survey population and will not correspond to those that would be produced by Statistics Canada The weights are provided as variables under Sample control On the SLID PUMF the weight variable is named ICSWT26 5 Guidelines for Release Data Quality and Rounding Microdata users should apply the rules for assessing data quality see below to all estimates they produce and retain only those that satisfy the release criteria Estimates that do not satisfy the release criteria are not reliable
6. Person has ever enrolled in university Highest level of education of person 1st grouping Number of Years completed at a community college technical institute trade or vocational school or CEGEP general and vocational college Number of years completed at elementary amp high school Number of years of postsecondary schooling completed Year received recent non university postsecondary diploma 5 year intervals group Year received highest university degree 5 year intervals group Number of years of schooling completed by person elementary high school post secondary Number of years of university person has completed Statistics Canada 28 Catalogue no 75F0002M
7. any other type of release correspond to estimates that would be obtained by Statistics Canada we Statistics Canada 10 Catalogue no 75F0002M strongly recommend that users comply with the following guidelines for rounding estimates a Estimates in the body of a statistical table must be rounded to the nearest hundredth using the traditional rounding technique 1 e if the first or only number to be eliminated is between 0 and 4 the preceding number does not change If the first or only number to be eliminated is between 5 and 9 the value of the last number to be retained increases by 1 For example when using the traditional technique of rounding to the nearest hundredth if the last two numbers are between 00 and 49 they are replaced by 00 and the preceding number denoting hundredths stays as is If the last two numbers are between 50 and 99 they are replaced with 00 and the preceding number increased by 1 b Total partial sub totals and total sub totals in statistical tables must be calculated using their unrounded corresponding components then rounded in turn to the closest hundredth using the traditional rounding technique c Means ratios rates and percentages must be calculated using unrounded components i e numerators and or denominators and then rounded to a decimal using the traditional rounding technique d Totals and differences in aggregates or ratios must be calculated using their corresponding unrounded compo
8. jobs are not included on the SLID PUMFs The person file does contain identifiers that allow a researcher to group persons into households economic families and census families The key file contains one record per person in the sample including children under the age of 16 Basic demographic information is available on this file and the necessary identifiers in order to match to the files for person economic and census families The economic and census family files contain one record per family Both files include a demographic summary income information and labour characteristics In 2006 there was no change to PUMF files structure from the previous reference year The sizes of the 2006 public use files are Files Number of Number of Record length Records Variables Person file 54 262 130 491 Economic family file 28 524 67 371 Census family file 31 843 64 368 Key file 66 646 14 45 3 Using the Record Layouts Data Dictionary and Univariate Distributions Additional information files are provided to assist users of the SLID public use microdata files For each of the four data files key person economic family and census family record layout data dictionary and univariate distributions are provided These information files are organized by content themes and in some cases sub themes Statistics Canada Catalogue no 75F0002M The following describes the structure of the additional info
9. your calculation of means or aggregates seems too high check to ensure that you have excluded reserved codes from the calculation With only a few exceptions the reserved codes are the highest four values permitted according to the length of the variable A brief explanation of reserved codes is provided below If the coverage of a variable does not extend to a certain population sub group then there are no valid values for that sub group and the values reserved codes that do appear are in the form 9 99 9 9 and so on which indicates that the variable is not applicable The coverage of each variable on the file is referred to in the data dictionary as the population For certain records no valid value is available although the value is applicable Possibly the respondent did not provide the information or it failed an edit in processing and the value was not imputed Such missing values appear with a reserved code such as 7 97 9 7 and so on depending on the format For certain variables the number of missing values has been reduced through imputation Missing values for the income variables have been entirely imputed but most other variables may have missing values Finally a few values may have been coded as 8 98 9 8 etc These represent refusals to particular items in the interview The approach for dealing with missing values of this last kind depends on the type of analysis being carried out and the extent of missing data
10. 59 131 Hours per week worked at home for job 05440 Labour Job characteristics Occupation nocg2e6 Character 2 60 136 National Occupational Classification for Statistics 2001 25 at the end of reference year 05460 Labour Job characteristics Wages and benefits imphwel Decimal 6 2 61 138 Hourly wage at end of job or end of reference year penpln1 Character 1 62 144 Flag Has pension plan with this job in reference year uncoll1 Character 1 63 145 Flag Union member or covered by collective agreement 05470 Labour Job characteristics Employer attributes muloc10 Character 1 64 146 Flag Employer operates at more than one location nic3g10 Character 2 65 147 North American Industry Classification System 2002 16 nbemal0 Character 1 66 149 Number of employees at all locations nbempl1 Character 1 67 150 Number of employees at person s place of work Statistics Canada 25 Catalogue no 75F0002M Start Variable name Type Size Field ve Long name position pubpv10 Character 1 68 151 Flag Employer is in public or private sector 07100 Financial situation Income sources alimo42 Numeric 8 0 69 152 Support payments received alip42 Numeric 8 0 70 160 Support payments paid atinc42 Numeric 8 0 71 168 After tax income capgn42 Numeric 8 0 72 176 Taxable capital gains ccar42 Numeric 8 0 73 184 Child care expenses chfed42 Numeric 8 0 74 192 Total of federal child benefits Canada Child Tax Benefit CCTB
11. B Data dictionary The data dictionary presents the complete information about each survey variable on each of the four files For each variable in the record layout the following information is shown the variable name the description or definition code lists with descriptions or alternatively the range of values that the variable can take on the variable type its length or format and the population to which the variable pertains i e for whom it is applicable C Frequencies Statistics Canada 7 Catalogue no 75F0002M These distributions are provided to allow users of the public use microdata files to verify totals that they produce These distributions relate to the public use files and not to the internal database the distributions will be similar but not identical due to confidentiality processing procedures used to produce the public use files For character variables the description unweighted and weighted frequencies and weighted percentages for each code including reserved codes see below are provided For numeric variables the values are broken into several ranges and show the description unweighted and weighted frequencies and weighted percentages Missing values and reserved codes There are a few types of missing values on the public use files SLID has adopted standard codes which have a particular meaning It is important to account for reserved codes in any analysis particularly with numeric variables If
12. F and SLID 1989 1997 and Comparison of income estimates from the survey of consumer finances and the survey of labour and income dynamics see also section Related products and services How to cite SLID in publications For publication of any information based on the SLID microdata files on CD ROM 7S5MO010XCB the following form of accreditation is recommended This analysis is based on Statistics Canada s Survey of Labour and Income Dynamics Public Use Microdata which contains anonymized data collected in the Survey of Labour and Income Dynamics All computations on these microdata were prepared by Name of user The responsibility for the use and interpretation of these data is entirely that of the author s Statistics Canada 5 Catalogue no 75F0002M 2 File Structures Although often referred to as one file the SLID cross sectional PUMF is four separate flat files key person economic family and census family To a large extent the file structure used for SCF PUMFs has been maintained On the person file there is one record per person in the sample aged 16 and over Job characteristics such as industry wage rates and work schedule are included on the person file and relate to the person s main job during the reference year the job at which the most hours were worked during the year Although SLID collects data on all jobs held during the year by each person under 70 years old the characteristics of all other
13. User s Guide for Cross Sectional Public Use Microdata File Survey of Labour and Income Dynamics SLID sath Reference Year 2006 Table of Contents PMU OCUCUON ue SAS EE IEE SIS Se EEL 5 ZALES UCU CS a ens sets tat Sauce ba Biden ard cn occu tha toe Soccadd 8 we E tities does ISa aes 6 3 Using the Record Layouts Data Dictionary and Univariate Distributions 6 4 Guidelines Tor Applying Weights isi ac ctsceaceceitas aaccavsstupacansaoecseesionsetensemeenaisanc asmeualeacane 9 5 Guidelines for Release Data Quality and Rounding ce eeeeeeseceesseeeeeeeeceteeeesteeeesaes 9 6 Confidentiality of the Public Use Microdata ccceeeccecesccecseececssececsseeeeseeesseeeenaeeees 12 7 SLID Content Notes and Definition Methodology e cc eeesceeeesceceeeeeceeeeeeeeeeeesteeeees 13 8 Related Products and Services c c sists tan sseccivscencranevarteil aa n E a a teat ates 13 9 Questions and COMMEHS 0 cececeesessececccecsesessnsecececeeeesessnsaaeceseceesenensseceeeceeseeeeentaaeees 13 TO ALPE MC 6 Vc e ba gent consactient a 2s oraeatcaa gate a tastedan eee ENE 14 1 Introduction The cross sectional public use microdata file for the Survey of Labour and Income Dynamics SLID is a collection of income labour and family variables on persons in Canada and their families SLID is an annual household survey covering the population of the 10 Canadian provinces with the exception of I
14. acter 1 14 46 Flag Disability status for the reference year 03510 Personal characteristics Geography Geographic area pvreg25 Character 2 15 47 Province of residence group household December 31 reference year uszga25 Character 1 16 49 Adjusted size of area of residence 03610 Personal characteristics Family and household characteristics Household size and type hhsz25 Numeric 2 0 17 50 Number of persons in household as of December 31 of reference year hhcomp25 Character 1 18 52 Household composition as of December 31 of reference year 03612 Personal characteristics Family and household characteristics Dwelling housing dwltyp25 Character 1 19 53 Type of dwelling dwtenr25 Character 1 20 54 Ownership of dwelling repa25 Character 1 21 55 Repairs dwelling needed suit25 Character 1 22 56 Flag Dwelling suitable according to National Occupancy Standard 05110 Labour Labour market activity patterns Number of jobs and job change multj28 Character 1 23 57 Flag Multiple job holder in any month in reference year nbjbs28 Numeric 2 0 24 58 Number of jobs held during reference year 05120 Labour Labour market activity patterns Labour force status and main job alfst28 Character 2 25 60 Annual labour force status ml01v28 Character 2 26 62 Monthly labour force status January ml02v28 Character 2 27 64 Monthly labour force status February ml03v28 Character 2 28 66 Monthly labour force statu
15. e variables particularly monetary values are rounded e Suppression and modification of characteristics was done while preserving integrity of the file for the purpose of producing precise and accurate statistics e Imputed records and variables on the file are not identified as such e Addition of noise perturbation Numeric values may have been raised or reduced by unequal amounts and proportions in a random like fashion addition of noise while maintaining data integrity for the purpose of producing precise and accurate statistics 7 SLID Content Notes and Definition Methodology See the appropriate section in Survey of Labour and Income Dynamics SLID A survey overview 8 Related Products and Services See the appropriate section in Survey of Labour and Income Dynamics SLID A survey overview 9 Questions and Comments If you have any questions or comments about the data in this CD ROM product you can contact the Income Statistics Division Telephone 1 888 297 7355 or 613 951 7355 Facsimile Number 613 951 3012 Internet income statcan ca Income Statistics Division Statistics Canada 150 Tunney s Pasture Driveway Ottawa Ontario K1A OT6 Statistics Canada 13 Catalogue no 75F0002M 10 Appendix 1 SLID Record Layout 2006 External Cross Sectional Economic Family File ec2006ef Start Variable name Type Size Field ee Long name position 01100 Sample control Identifiers
16. ed Depending on the type of estimate this rule can Statistics Canada 9 Catalogue no 75F0002M vary slightly These rules help protect the confidentiality of survey respondents and ensure the reliability of estimates Suppression rules Estimate Suppress if Percentage Distribution Proportion Shares e 9 under the low income cut off Denominator sample size lt 25 LICO or e Income distribution Denominator sample size lt 100 and numerator e Proportion of families with sample size lt 5 income 0 Ratios Numerator sample size lt 25 or Denominator sample size lt 25 Quintiles shares means and upper income limits e shares of income by quintile sample in all quintiles 5 lt 25 e average income by quintile or e upper income limits upper income limit for upper income quintile or total of quintiles e female male earnings Other estimates e Counts e Mean e Medians sample lt 25 e Gini coefficients The denominator sample size refers to the sample size of the total estimate from which the distribution percentage proportion or share is derived Estimates of provincial aggregates and means When producing estimates for provincial aggregates and means it should be noted that for a small number of records province of residence has been suppressed This will result in a small bias in provincial estimates Rounding guidelines To ensure that estimates from this microdata file intended for publication or
17. ent during reference year recoll20 Character 1 115 458 Flag Received a certificate or diploma from a community college business school trade or vocational school or CEGEP general and vocational college during the reference year rcuniv20 Character 1 116 459 Flag Received a university degree certificate or diploma during the reference year studtf26 Character 1 117 460 Flag Attending school college CEGEP general and vocational college or university in the reference year 09210 Education Level of schooling Attainment cmphi18 Character 1 118 461 Flag Person completed high school dgcoll18 Character 1 119 462 Flag Ever received non university post secondary certificate diploma Statistics Canada 27 Catalogue no 75F0002M Variable name Type Size Field Start position Long name dguniv18 encoll18 enuniv18 hleveg18 yrcoll18 yrelhil8 yrpsec18 yrrnug 18 yrrung18 yrschl18 yruniv18 Character Character Character Character Decimal Decimal Decimal Character Character Decimal Decimal 4 1 4 1 4 1 4 1 4 1 120 121 122 123 124 125 126 127 128 129 130 463 464 465 466 468 472 476 480 482 484 488 Flag Ever received a university degree certificate or diploma from below baccalaureate degree B A to doctor s degree Ph D Flag Ever enrolled non university training Flag
18. family received Employment Insurance during reference year fmwcf46 Character 1 55 348 Flag Census family received Worker s Compensation reference year nbear46 Numeric 2 0 56 349 Number of earners 16 or older in census family for reference year nbempd46 Numeric 2 0 57 351 Number of census family members employed any time in reference year Statistics Canada 20 Catalogue no 75F0002M Start Variable name Type Size Field ae Long name position nbfyft46 Numeric 2 0 58 353 Number of census family members in full year full time jobs reference year nbscft46 Numeric 2 0 59 355 Number of census family members 16 years and older in census family in school full time nbscpt46 Numeric 2 0 60 357 Number in census family 16 years and older in school part time reference year nbsemp46 Numeric 2 0 61 359 Number of census family members self employed during reference year nbunem46 Numeric 2 0 62 361 Number of census family members unemployed during reference year nbwke46 Numeric 3 0 63 363 Number of weeks employed all census family during reference year nbwkue46 Numeric 3 0 64 366 Weeks unemployed for all census family members in reference year Statistics Canada 21 Catalogue no 75F0002M Record Layout 2006 External Cross Sectional Person File ec2006pr Start Variable name Type Size Field ae Long name position 01100 Sample control Identifiers pucpid26 Character 7 1 1 Cross sectional random person identif
19. ier puchid25 Character 7 2 8 Cross sectional random household identifier 01120 Sample control Identifiers Economic Family d31fam26 Character 2 3 15 Economic family identifier 01125 Sample control Identifiers Census Family d31cf26 Character 2 4 17 Census family identifier 01110 Sample control Identifiers Year year99 Numeric 4 0 5 19 Reference year 01200 Sample control Weights icswt26 Decimal 10 4 6 23 Regular cross sectional weight 03110 Personal characteristics Demographics Year of birth sex and marital status ecage26 Numeric 3 0 7 33 Person s age reference year external cross sectional file ecsex99 Character 1 8 36 Sex of respondent on external cross sectional file ecyob26 Numeric 4 0 9 37 Person s year of birth on external cross sectional file marst26 Character 2 10 41 Marital status of person as of December 31 of reference year 03130 Personal characteristics Demographics Major activity and health mjacg26 Character 1 11 43 Person s major activity during the reference year group 03200 Personal characteristics Ethnocultural characteristics immst15 Character 1 12 44 Flag Person is an immigrant yrimmg26 Character 1 13 45 Number of years since person immigrated to Canada group Statistics Canada 22 Catalogue no 75F0002M Start Variable name Type Size Field sae Long name position 03300 Personal characteristics Activity limitations disabs26 Char
20. ily members in full year full time jobs reference year nbscft27 Numeric 2 0 62 358 Number of 16 years and over attending school full time reference year nbscpt27 Numeric 2 0 63 360 Number in family 16 years and over in school part time in reference year nbsemp27 Numeric 2 0 64 362 Number of family members self employed during reference year nbunem27 Numeric 2 0 65 364 Number of family members unemployed during reference year nbwke27 Numeric 3 0 66 366 Number of weeks employed all family members reference year nbwkue27 Numeric 3 0 67 369 Weeks unemployed for all family members during reference year Statistics Canada 17 Catalogue no 75F0002M SLID Record Layout 2006 External Cross Sectional Census Family File ec2006cf Variable name Type Size Field Stari Long name position 01100 Sample control Identifiers puchid25 Character 7 1 1 Cross sectional random household identifier 01110 Sample control Identifiers Year year99 Numeric 4 0 2 8 Reference year 01120 Sample control Identifiers Economic Family d31fam26 Character 2 3 12 Economic family identifier 01125 Sample control Identifiers Census Family d31cf26 Character 2 4 14 Census family identifier 01200 Sample control Weights icswt26 Decimal 10 4 5 16 Regular cross sectional weight 03140 Personal characteristics Demographics Family situation mjieh46 Character 1 6 26 Flag Census family including major income ea
21. n last worked scsum28 Character 2 46 102 Yearly summary of schedules of jobs during the reference year 05150 Labour Labour market activity patterns Earnings cmphrw28 Decimal 6 2 47 104 Composite hourly wage all paid jobs in reference year revemp28 Character 1 48 110 Flag Received compensation during reference year 05200 Labour Work experience yrxftel 1 Numeric 2 0 49 111 Number of years of work experience full year full time 05410 Labour Job characteristics Dates and duration jobdur1 Numeric 3 0 50 113 Duration of job up to the end of current reference year months Statistics Canada 24 Catalogue no 75F0002M Start Variable name Type Size Field ve Long name position 05420 Labour Job characteristics Class of worker clwkr1 Character 2 51 116 Class of worker in reference year 05430 Labour Job characteristics Work schedule fllprt1 Character 1 52 118 Flag Job was full time in reference year reaisc 1 Character 2 53 119 Reason for irregular work schedule at end of the year reawptl Character 2 54 121 Reason why person worked less than 30 hours per week scdtyp1 Character 2 55 123 Type of work schedule at end of year for given job tothrp1 Numeric 4 0 56 125 Total hours paid at this job in reference year typptl Character 1 57 129 Type of part time work at this job for reference year wkhm1 Character 1 58 130 Flag Person regularly worked at home for this job hrwkhm1 Decimal 5 1
22. ndian reserves residents of institutions and military barracks The Survey of Labour and Income Dynamics began collecting data for reference year 1993 Initially SLID was designed to be first and foremost a longitudinal survey with primary focus on labour and income and the relationships between them and family composition Then the decision was made to extend the objectives of SLID to be the primary source of cross sectional household income data For many years the Survey of Consumer Finances had provided public use microdata files PUMFs to meet the needs of cross sectional household income data users SCF PUMFs were released up to and including reference year 1997 For the purpose of standard publications Statistics Canada has made the transition from SCF to SLID between 1995 and 1996 Therefore SLID cross sectional PUMFs are being made available beginning with reference year 1996 The SLID files have been designed to be analogous to those produced for the SCF The type of income data collected by SLID was identical to that of the former household income survey SCF Survey of Consumer Finances with the distinction that SLID respondents had the choice of a traditional income interview or granting permission to Statistics Canada to use their T1 income tax data To find more information on comparability between SLID and SCF data please consult the two following documents Bridging two surveys An integrated series of income data from SC
23. nents then rounded to the nearest hundredth or decimal place using the traditional rounding technique e If due to technical or other limitations a technique other than traditional rounding is used with the result that the estimates to be published or released differ in any form from the corresponding estimates that would be obtained by Statistics Canada using this microdata file we strongly advise users to indicate the reasons for the differences in the documents to be published or released f Unrounded estimates should not under any circumstances be published or released Unrounded estimates give the impression that they are much more precise than they actually are Hypothesis tests provided by statistical software packages Microdata users should be aware that the results of hypothesis tests such as the p values accompanying t statistics or Pearson statistics that are provided automatically by most standard statistical software packages are incorrect for data provided by surveys with a complex survey design such as SLID Such packages calculate these test results under the assumption of simple random sampling That is they do not take into account the special sample design features of SLID such as stratification clustering and unequal selection probabilities While many of the standard packages can account for the unequal selection probabilities in the production of estimates by allowing the use of weights these packages do not pro
24. nsus fam Total Federal provincial Child Tax Benefit programs cpqpp46 Numeric 8 0 22 107 Census family total Canada amp Quebec Pension Plan benefit cqpc46 Numeric 8 0 23 115 Census family total Canada amp Quebec Pension Plan earng46 Numeric 8 0 24 123 Census family Total earnings eipr46 Numeric 8 0 25 131 Census family total Employment Insurance contributions fditx46 Numeric 8 0 26 139 Census family total Federal income tax fmse46 Numeric 8 0 27 147 Census family total Farm self employment net income gstxc46 Numeric 8 0 28 155 Census family total Federal Goods and Services Tax Harmonized Sales Tax Credit gtr46 Numeric 8 0 29 163 Census family total Government transfers federal amp provincial inctx46 Numeric 8 0 30 171 Census family total Income tax federal plus provincial inva46 Numeric 8 0 31 179 Census family total Investment income mbinc46 Numeric 8 0 32 187 Census family total Market Basket Measure MBM income medx46 Numeric 8 0 33 195 Census family total Direct medical expenses mjsif46 Character 2 34 203 Major source of income for census family mtinc46 Numeric 8 0 35 205 Census family total Market income nfmse46 Numeric 8 0 36 213 Census family total Non farm self employment net income Statistics Canada 19 Catalogue no 75F0002M Start Variable name Type Size Field He Long name position oasgi46 Numeric 8 0 37 221 Census family total Old Age Security benefits
25. ottxm46 Numeric 8 0 38 229 Census family total Other income pen46 Numeric 8 0 39 237 Census family total Private retirement pensions phpr46 Numeric 8 0 40 245 Census family total Public health insurance premiums pvitx46 Numeric 8 0 41 253 Census family total Provincial income tax pvtxc46 Numeric 8 0 42 261 Census family total Provincial tax credits rppc46 Numeric 8 0 43 269 Census family total Registered pension plan contributions rspwi46 Numeric 8 0 44 277 Census family total Registered Retirement Savings Plan withdrawals sapis46 Numeric 8 0 45 285 Census family total Social Assistance semp46 Numeric 8 0 46 293 Census family total Self employment net income ttinc46 Numeric 8 0 47 301 Census family total Total income before taxes udpd46 Numeric 8 0 48 309 Census family total Union dues and other professional premiums uiben46 Numeric 8 0 49 317 Census family total Employment Insurance benefits wesal46 Numeric 8 0 50 325 Census family total Wages amp salaries before deductions wkrcp46 Numeric 8 0 51 333 Census family total Workers compensation benefits 03680 Personal characteristics Family and household characteristics Census family labour characteristics alhpf46 Numeric 5 0 52 341 Total hours paid all jobs census family members reference year fmsaf46 Character 1 53 346 Flag Census family member recquired Social Assistance reference year fmuif46 Character 1 54 347 Flag Census
26. perly take the sample design into account when producing variance estimates that form part of most test statistics Statistics Canada 11 Catalogue no 75F0002M To perform hypothesis tests a two step method can be employed with the standard statistical software to form the test statistics First estimate the characteristics of interest total or mean using the weights provided on the microdata file Second obtain approximate variance estimates of these characteristics by rerunning the same software procedure as that used for producing the characteristic estimates but using a scaled weight that consists of the original weight divided by the average of the original weights of all the observations being used in your computations The standard error can be derived by using the estimate and the rough estimate of the variance These quantities estimate variance standard error can then be combined to form test statistics It must be noted that this method provides only rough approximations to the variance It should be noted that users of the SLID PUMF cannot readily obtain better design based variance estimates through the use of statistical software specifically designed for survey data This is because the design information required by these software packages is not currently available on the SLID data file due to confidentiality considerations However better variance estimates can be produced by Statistics Canada on a cost recovery basis 6
27. rmation files A The columns of the record layout file e Variable name This is the variable name assigned for the public use microdata file e Type Indicates whether the variable is numeric in the sense that it can logically be used in mathematical operations or character e Size Indicates both the number of spaces including the decimal point if there are decimal places and the number of decimal places if any For example a variable which can have values of zero 00 0 to 99 9 would have a format expressed as 4 1 A variable which can have values of zero 00 to 99 would have a format expressed as 2 e Sequence Indicates the order of variable appearance e Start position This shows the location of the variable on the public use microdata file e Long variable name A standardized name which can be used to quickly identify variables to label tables and so on Although still rather cryptic it is considerably more revealing than the variable name However this longer name obviously excludes a lot of important information contained in the variable description shown in the data dictionary In short analysts are warned against making assumptions about the variable definition based on the long variable name e Number of categories Shows the number of categories in the value set for the variable in question Applies only to character variables Numeric variables have ranges which are specified in the data dictionary
28. rner of household reference year 03510 Personal characteristics Geography Geographic area pvreg25 Character 2 7 27 Province of residence group household December 31 reference year 03660 Personal characteristics Family and household characteristics Census family size and type agofm46 Numeric 3 0 8 29 Age of oldest person in census family agofmg46 Character 2 9 32 Age group of oldest person in census family agyfm46 Numeric 3 0 10 34 Age of youngest person in the census family agyfmg46 Character 2 11 37 Age group of youngest person in census family fmcomp46 Character 2 12 39 Census family composition fmsz46 Numeric 2 0 13 41 Number of census family members Statistics Canada 18 Catalogue no 75F0002M Start Variable name Type Size Field ba Long name position 03670 Personal characteristics Family and household characteristics Census family income alimo46 Numeric 8 0 14 43 Census family total Support payments received alip46 Numeric 8 0 15 51 Census family total Support payments paid atinc46 Numeric 8 0 16 59 Census family total After tax income capgn46 Numeric 8 0 17 67 Census family total Taxable capital gains ccar46 Numeric 8 0 18 75 Census family total Childcare expenses chfed46 Numeric 8 0 19 83 Census family total Canada Child Tax Benefits chprv46 Numeric 8 0 20 91 Census family total Provincial program General Child Tax Benefits chtxb46 Numeric 8 0 21 99 Ce
29. s March ml04v28 Character 2 29 68 Monthly labour force status April Statistics Canada 23 Catalogue no 75F0002M Start Variable name Type Size Field zi Long name position ml05v28 Character 2 30 70 Monthly labour force status May ml06v28 Character 2 31 72 Monthly labour force status June ml07v28 Character 2 32 74 Monthly labour force status July ml08v28 Character 2 33 76 Monthly labour force status August ml09v28 Character 2 34 78 Monthly labour force status September ml10v28 Character 2 35 80 Monthly labour force status October mll1v28 Character 2 36 82 Monthly labour force status November ml12v28 Character 2 37 84 Monthly labour force status December wksem28 Numeric 2 0 38 86 Total number of weeks employed during reference year wksnlf28 Numeric 2 0 39 88 Total number of weeks not in the labour force during reference year wksuem28 Numeric 2 0 40 90 Total number of weeks unemployed during reference year 05130 Labour Labour market activity patterns Class of worker fpdwk28 Character 1 41 92 Flag Person was a paid worker during reference year fsein28 Character 1 42 93 Flag Self employed incorporated job in reference year fseui28 Character 1 43 94 Flag Self employed unincorporated job in reference year 05140 Labour Labour market activity patterns Work schedule alhrp28 Numeric 4 0 44 95 Total hours paid all jobs during reference year mtlswk28 Numeric 3 0 45 99 Number of months since perso
30. tal Income tax federal plus provincial inva27 Numeric 8 0 32 180 Economic family total Investment income licofa27 Character 1 33 188 Flag Family after tax income is below low income cut off LICO in reference year licofb27 Character 1 34 189 Flag Family before tax income is below low income cut off LICO in Statistics Canada 15 Catalogue no 75F0002M Start Variable name Type Size Field re Long name position reference year mbinc27 Numeric 8 0 35 190 Economic family total Market Basket Measure MBM income medx27 Numeric 8 0 36 198 Economic family total Direct medical expenses myjsif27 Character 2 37 206 Major source of income for economic family mtinc27 Numeric 8 0 38 208 Economic family total Market income nfmse27 Numeric 8 0 39 216 Economic family total Non farm self employment net income oasgi27 Numeric 8 0 40 224 Economic family total Old Age Security benefits ottxm27 Numeric 8 0 41 232 Economic family total Other income pen27 Numeric 8 0 42 240 Economic family total Private retirement pensions phpr27 Numeric 8 0 43 248 Economic family total Public health insurance premiums pvitx27 Numeric 8 0 44 256 Economic family total Provincial income tax pvtxc27 Numeric 8 0 45 264 Economic family total Provincial tax credits rppc27 Numeric 8 0 46 272 Economic family total Registered pension plan contributions rspwi27 Numeric 8 0 47 280 Economic family total Registered Retirement Sa
31. tics Family and household characteristics Economic family income alimo27 Numeric 8 0 15 44 Economic family total Support payments received alip27 Numeric 8 0 16 52 Economic family total Support payments paid atinc27 Numeric 8 0 17 60 Economic family total After tax income capgn27 Numeric 8 0 18 68 Economic family total Taxable capital gains ccar27 Numeric 8 0 19 76 Economic family total Childcare expenses chfed27 Numeric 8 0 20 84 Economic family total Canada Child Tax Benefit chprv27 Numeric 8 0 21 92 Economic family total Provincial program general Child Tax Benefit CTB chtxb27 Numeric 8 0 22 100 Economic family total Federal provincial program general Child Tax Benefit CTB cpqpp27 Numeric 8 0 23 108 Economic family total Canada Pension Plan and Quebec Pension Plan benefit cqpc27 Numeric 8 0 24 116 Economic family total Canada amp Quebec Pension Plan earng27 Numeric 8 0 25 124 Economic family total Earnings eipr27 Numeric 8 0 26 132 Economic family total Employment Insurance contributions fditx27 Numeric 8 0 27 140 Economic family total Federal income tax fmse27 Numeric 8 0 28 148 Economic family total Farm self employment net income gstxc27 Numeric 8 0 29 156 Economic family total Federal Goods and Services Tax Harmonized Sales Tax Credit gtr27 Numeric 8 0 30 164 Economic family total Government transfers federal amp provincial inctx27 Numeric 8 0 31 172 Economic family to
32. vings Plan withdrawals sapis27 Numeric 8 0 48 288 Economic family total Social Assistance semp27 Numeric 8 0 49 296 Economic family total Self employment net income ttinc27 Numeric 8 0 50 304 Economic family total Total income before taxes udpd27 Numeric 8 0 51 312 Economic family total Union dues and other professional premiums uiben27 Numeric 8 0 52 320 Economic family total Employment Insurance benefits wgsal27 Numeric 8 0 53 328 Economic family total Wages amp salaries before deductions wkrcp27 Numeric 8 0 54 336 Economic family total Workers compensation benefits 03650 Personal characteristics Family and household characteristics Economic family labour characteristics alhpf27 Numeric 5 0 55 344 Total hours paid all jobs economic family members reference year Statistics Canada 16 Catalogue no 75F0002M Start Variable name Type Size Field re Long name position fmsaf27 Character 1 56 349 Flag Family member received Social Assistance reference year fmuif27 Character 1 57 350 Flag Family member received Employment Insurance during reference year fmwcf27 Character 1 58 351 Flag Family member received Worker s Compensation reference year nbear27 Numeric 2 0 59 352 Number of earners 16 or older in economic family in reference year nbempd27 Numeric 2 0 60 354 Number of economic family members employed any time during reference year nbfyft27 Numeric 2 0 61 356 Number economic fam
33. xc42 Numeric 8 0 97 370 Provincial tax credits rppc42 Numeric 8 0 98 378 Registered pension plan contributions rspwi42 Numeric 8 0 99 386 Registered Retirement Savings Plan withdrawals Statistics Canada 26 Catalogue no 75F0002M Start Variable name Type Size Field sae Long name position sapis42 Numeric 8 0 100 394 Social Assistance semp42 Numeric 8 0 101 402 Self employment net income ttinc42 Numeric 8 0 102 410 Total income before taxes udpd42 Numeric 8 0 103 418 Union dues and other professional premiums uiben42 Numeric 8 0 104 426 Employment Insurance benefits wesal42 Numeric 8 0 105 434 Wages and salaries before deductions wkrcp42 Numeric 8 0 106 442 Workers compensation benefits 09100 Education Educational activity atbus20 Character 1 107 450 Flag Attended business or commercial school in reference year atcc20 Character 1 108 451 Flag attended a community college or institute of applied arts and technology in reference year atcegp20 Character 1 109 452 Flag Attended CEGEP general and vocational college in reference year atelhi20 Character 1 110 453 Flag Attended high school in reference year attrd20 Character 1 111 454 Flag Person attended trade school in reference year atuniv20 Character 1 112 455 Flag Person attended university in reference year cmphi20 Character 1 113 456 Flag Person completed high school in reference year fllprt20 Character 1 114 457 Flag Person full time stud
Download Pdf Manuals
Related Search