User's Guide for Cross-Sectional Public-Use
Contents
1. 397 399 401 403 Economic family total Union dues other profess premiums Economic family total Employment Insurance benefits Economic family total Wages amp salaries before deductions Economic family total Workers compensation benefits Total hours paid all jobs economic family members reference year Flag Family member received Social Assistance reference year Flag Family member received Employment Insurance during reference year Flag Family member received Worker s Compensation reference year Number of earners 16 or older in economic family in reference year Number of economic family members employed any time during reference year Number economic family members in full year full time jobs reference year Number of 16 attending school full time reference year Number in family 16 in school part time in reference year Number of family members self employed during reference year Statistics Canada 17 Catalogue no 75F0002M Text table 3 External cross sectional economic family file ec2007ef continued Variable name Type Size Field Start Long name pos nbunem27 Numeric 2 0 71 405 Number of family members unemployed during reference year nbwke27 Numeric 3 0 72 407 Number of weeks employed all family members reference year nbwkue27 Numeric 3 0 73 410 Weeks unemployed for all family members during reference year Text table 4 External2. 4 19 Economic family identifier d31cf26 Character 2 5 21 Census family identifier wicsld26 Decimal 10 4 6 23 Regular integrated cross sectional weight for SLID 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 files ecyob26 Numeric 4 0 9 37 Person s year of birth on external cross sectional files mjice26 Character 1 10 41 Flag Major income earner in the census family reference year mjieh26 Character 1 11 42 Flag Major income earner in the household reference year mjine26 Character 1 12 43 Flags Person was major earner in economic family reference year rmjcg26 Character 1 13 44 Relationship to major income earner census family group rmjig26 Character 1 14 45 Relationship to major income earner economic family group Statistics Canada 30 Catalogue no 75F0002M
3. 47 273 Economic family total Public health insurance premiums prpen27 Numeric 8 0 48 281 Private pension income pvitx27 Numeric 8 0 49 289 Economic family total Provincial income tax pvtxc27 Numeric 8 0 50 297 Economic family total Provincial tax credits rppc27 Numeric 8 0 51 305 Economic family total Registered pension plan contributions rspwi27 Numeric 8 0 52 313 Economic family total RRSP withdrawals sapis27 Numeric 8 0 53 321 Economic family total Social Assistance semp27 Numeric 8 0 54 329 Economic family total Self employment net income ttinc27 Numeric 8 0 55 337 Economic family total Total income before taxes uccb27 Numeric 8 0 56 345 Economic family total Universal child care benefit Statistics Canada 16 Catalogue no 75F0002M Text table 3 External cross sectional economic family file ec2007ef continued Variable name Type Field Start pos Long name udpd27 uiben27 wgsal27 wkrcp27 alhpf27 fmsaf27 fmuif27 fmwcf27 nbear27 nbempd27 nbfyft27 nbscft27 nbscpt27 nbsemp27 Numeric Numeric Numeric Numeric Numeric Character Character Character Numeric Numeric Numeric Numeric Numeric Numeric 8 0 8 0 8 0 8 0 5 0 2 0 2 0 2 0 2 0 2 0 2 0 57 58 59 60 61 62 63 64 65 66 67 68 69 70 353 361 369 377 385 390 391 392 393 395
4. 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 published Depending on the type of estimate this rule can vary slightly These rules help protect the confidentiality of survey respondents and ensure the reliability of estimates Statistics Canada 9 Catalogue no 75F0002M Text table 2 Suppression rules Estimate Suppress if Percentage distribution proportion shares e under the low income cut off Denominator sample size lt 25 LICO or e Income distribution Denominator sample size lt 100 and e Proportion of families with numerator 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 female male earnings 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 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 Wh
5. of 16 in census family in school full time Number in census family 16 in school part time reference year Statistics Canada 21 Catalogue no 75F0002M Text table 4 External cross sectional census family file ec2007cf continued Variable name Type Size Field Start Long name pos nbsemp46 Numeric 2 0 66 399 Number of census family members self employed during reference year nbunem46 Numeric 2 0 67 401 Number of census family members unemployed during reference year nbwke46 Numeric 3 0 68 403 Number of weeks employed all census family during reference year nbwkue46 Numeric 3 0 69 406 Weeks unemployed for all census family members in reference year Text table 5 External cross sectional person file ec2007pr Variable name Type Size Field Start Long name pos pucpid26 Character 7 1 1 Cross sectional random person identifier puchid25 Character 7 2 8 Cross sectional random household identifier d31fam26 Character 2 3 15 Economic family identifier d31cf26 Character 2 4 17 Census family identifier year99 Numeric 4 0 5 19 reference year wtcsld26 Decimal 10 4 6 23 Regular integrated cross sectional weight for SLID 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 files ecyob26 Numeric 4 0 9 37 Person s year of birth on external cross sectional files marst26 Character 2 10 41 Marital sta
6. public or private sector alimo42 Numeric 8 0 80 189 Support payments received alip42 Numeric 8 0 81 197 Support payments paid atinc42 Numeric 8 0 82 205 After tax income capgn42 Numeric 8 0 83 213 Taxable capital gains ccar42 Numeric 8 0 84 221 Child care expenses chfed42 Numeric 8 0 85 229 Total of federal child benefits CCTB WIS NCBS chprv42 Numeric 8 0 86 237 Total provincial child benefits chtxb42 Numeric 8 0 87 245 Total federal amp provincial child benefits Statistics Canada 26 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos cpqpp42 Numeric 8 0 88 253 CPP amp QPP benefits cqpc42 Numeric 8 0 89 261 Canada amp Quebec Pension Plan contributions earng42 Numeric 8 0 90 269 Earnings eipr42 Numeric 8 0 91 277 Employment Insurance contributions fditx42 Numeric 8 0 92 285 Federal income tax fmse42 Numeric 8 0 93 293 Farm self employment net income including farm program gstxc42 Numeric 8 0 94 301 Federal GST HST Credit excludes provincial sales tax credit gtr42 Numeric 8 0 95 309 Government transfers federal amp provincial inctx42 Numeric 8 0 96 317 Income tax federal plus provincial inva42 Numeric 8 0 97 325 Investment income majri42 Character 2 98 333 Major source of income mbinc42 Numeric 8 0 99 335 Disposable income for Market Basket Measure MBM medx42 Numeric 8 0 100 343 Direct medical expen
7. 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 e Rounding Some variables particularly monetary values are rounded e Suppression and modification of characteristics was done while preserving Statistics Canada 12 Catalogue no 75F0002M 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 Canad
8. 122 519 Workers compensation benefits atbus20 Character 1 123 527 Flag Attended business or commercial school in reference year atcc20 Character 1 124 528 Flag Attended college or applied arts technical institution reference year atcegp20 Character 1 125 529 Flag Attended CEGEP in reference year atelhi20 Character 1 126 530 Flag Attended high school in reference year attrd20 Character 1 127 531 Flag Person attended trade school in reference year atuniv20 Character 1 128 532 Flag Person attended university in reference year cmphi20 Character 1 129 533 Flag Person completed high school in reference year fllprt20 Character 1 130 534 Flag Person full time student during reference year rccoll20 Character 1 131 535 Flag Received certificate diploma from college business trade vocation CEGEP reference year rcuniv20 Character 1 132 536 Flag Received university degree certificate diploma reference year studtf26 Character 1 133 537 Flag Attending school college CEGEP or university in reference year cmphi18 Character 1 134 538 Flag Person completed high school Statistics Canada 28 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos dgcoll18 Character 1 135 539 Flag Ever received non university post secondary certificate diploma dguniv18 Character 1 136 540 Flag Ever received university degree certific
9. 6 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 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
10. Catalogue no 75FO002M No 1 ISSN 1707 2840 ISBN 978 1 100 14727 7 Research Paper Income Research Paper Series User s Guide for Cross Sectional Public Use Microdata File Survey of Labour and Income Dynamics SLID 2007 Income Statistics Division Jean Talon Building 170 Tunney s Pasture Driveway Ottawa Ontario K1A 0T6 Telephone 1 613 951 7355 I Eeg geses Statistaue Canada How to obtain more information For information about this product or the wide range of services and data available from Statistics Canada visit our website at www statcan gc ca e mail us at infostats statcan gc ca or telephone us Monday to Friday from 8 30 a m to 4 30 p m at the following numbers Statistics Canada s National Contact Centre Toll free telephone Canada and United States Inquiries line 1 800 263 1136 National telecommunications device for the hearing impaired 1 800 363 7629 Fax line 1 877 287 4369 Local or international calls Inquiries line 1 613 951 8116 Fax line 1 613 951 0581 Depository Services Program Inquiries line 1 800 635 7943 Fax line 1 800 565 7757 To access this product This product Catalogue no 75F0002M is available free in electronic format To obtain a single issue visit our website at www statcan gc ca and select Publications Standards of service to the public Statistics Canada is committed to serving its clients in a prompt reliable and courteous manner To this end Sta
11. a 150 Tunney s Pasture Driveway Ottawa Ontario K1A OT6 Statistics Canada 13 Catalogue no 75F0002M 10 Appendix 1 SLID Record Layout 2007 Text table 3 External cross sectional economic family file ec2007ef Variable name Type Size Field Start Long name pos puchid25 Character 7 1 1 Cross sectional random household identifier year99 Numeric 4 0 2 8 Reference year d31fam26 Character 2 3 12 Economic family identifier wtcsld26 Decimal 10 4 4 14 Regular integrated cross sectional weight for SLID mjieh27 Character 1 5 24 Flag Economic family including major income earner of household reference year 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 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 fmtyp27 Character 2 14 42 Economic family type reference person alimo27 Numeric 8 0 15 44 Economic family total Support payments received alip27 Numeric 8 0 16 52 Economic family total Support payments paid Statistics Canada 14 Catalogue no 75F0002M Text table 3 Extern
12. al cross sectional economic family file ec2007ef continued Variable name Type Size Field Start pos Long name atinc27 capgn27 ccar27 chfed27 chprv27 chtxb27 cpqpp27 cqpc27 earng27 eipr27 fditx27 fmse27 gstxc27 gtr27 inctx27 inva27 licofa27 licofb27 mbinc27 Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Character Character Numeric 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 8 0 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 60 68 76 84 92 100 108 116 124 132 140 148 156 164 172 180 188 189 190 Economic family total after tax income Economic family total Taxable capital gains Economic family total childcare expenses Economic family total CCTB Economic family total Provincial program general CTB Economic family total Federal provincial program general CTB Economic family total CPP QPP Economic family total Canada amp Quebec Pension Plan Economic family total earnings Economic family total Employment Insurance contributions Federal income tax Economic family total Economic family total farm self employment net income Ec
13. ate diploma from below Bachelor to PhD encoll18 Character 1 137 541 Flag Ever enrolled non university training enuniv18 Character 1 138 542 Flag Person has ever enrolled in university hleveg18 Character 2 139 543 Highest level of education of person 1st grouping yrcoll18 Decimal 4 1 140 545 Number Years completed at college technical institution trade vocational CEGEP yrelhi18 Decimal 4 1 141 549 Number of years completed at elementary amp high school yrpsec18 Decimal 4 1 142 553 Number of years of postsecondary schooling completed yrrnug18 Character 2 143 557 Year received recent non university postsecondary diploma 5 yrs interview group yrrung18 Character 2 144 559 Year received highest university degree 5 year interview group yrschl18 Decimal 4 1 145 561 Number of years of schooling completed by person elementary high school post secondary yruniv18 Decimal 4 1 146 565 Number of years of university person has completed Text table 6 External cross sectional key file ec2007ke Variable name Type Size Field Start Long name pos puchid25 Character 1 1 Cross sectional random household identifier Statistics Canada 29 Catalogue no 75F0002M Text table 6 External cross sectional key file ec2007ke continued Variable name Type Size Field Start Long name pos pucpid26 Character 7 2 8 Cross sectional random person identifier year99 Numeric 4 0 3 15 Reference year d31fam26 Character 2
14. car46 Numeric 8 0 18 75 Census family total Childcare expenses chfed46 Numeric 8 0 19 83 Census family total CCTB chprv46 Numeric 8 0 20 91 Census family total Provincial program general CTB chtxb46 Numeric 8 0 21 99 Census family Total federal provincial CTB 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 GST HST Credit gtr46 Numeric 8 0 29 163 Census family total Government transfers federal amp provincial Statistics Canada 19 Catalogue no 75F0002M Text table 4 External cross sectional census family file ec2007cf continued Variable name Type Size Field Start Long name pos 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 disposable income for Market Basket Measure medx46 Numeric 8 0 33 195 Census family total Direct medical expenses mjsif46 Character 2 34 203 Major source of in
15. come 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 oasgi46 Numeric 8 0 37 221 Census family total Old Age Security benefits ogovtr46 Numeric 8 0 38 229 Census family total Other government transfers ottxm46 Numeric 8 0 39 237 Census family total Other income pen46 Numeric 8 0 40 245 Census family total Private retirement pensions Includes pension income splitting pengiv46 Numeric 8 0 41 253 Pension Income Splitting Transferee Money given to spouse to reduce tax burden penrec46 Numeric 8 0 42 261 Pension income transfered from spouse received phpr46 Numeric 8 0 43 269 Census family total Public health insurance premiums prpen46 Numeric 8 0 44 277 Private pension income pvitx46 Numeric 8 0 45 285 Pension Income Splitting Transferee pvtxc46 Numeric 8 0 46 293 Census family total Provincial tax credits rppc46 Numeric 8 0 47 301 Census family total Registered pension plan contributions rspwi46 Numeric 8 0 48 309 Census family total RRSP withdrawals sapis46 Numeric 8 0 49 317 Census family total Social Assistance Statistics Canada 20 Catalogue no 75F0002M Text table 4 External cross sectional census family file ec2007cf continued Variable name Type Size Field Start pos Long name semp46 ttinc46 uccb46 udpd46 uiben46 wgsal46 wkrcp46 a
16. cross sectional census family file ec2007cf Variable name Type Size Field Start Long name pos puchid25 Character 7 1 1 Cross sectional random household identifier year99 Numeric 4 0 2 8 reference year d31fam26 Character 2 3 12 Economic family identifier d31cf26 Character 2 4 14 Census family identifier wicsld26 Decimal 10 4 5 16 Regular integrated cross sectional weight for SLID mjieh46 Character 1 6 26 Flag Census family including major income earner of household reference year pvreg25 Character 2 7 27 Province of residence group household December 31 reference year agofm46 Numeric 3 0 8 29 Age of oldest person in census family Statistics Canada 18 Catalogue no 75F0002M Text table 4 External cross sectional census family file ec2007cf continued Variable name Type Field Start Long name pos 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 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 c
17. eeeterseaeeeeess 13 TOA ppendiz letraren e a E a a E ENNS 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 Indian 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 sur
18. en 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 any other type of release correspond to estimates that would be obtained by Statistics Canada we 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 i 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 Statistics Canada 10 Catalogue no 75F0002M 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 techniq
19. encies 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 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 var
20. erson 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 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 The sizes of the 2007 public use files are Text table 1 File sizes Files Number of records Number of Record length variables Person file 53 052 146 568 Economic family file 27 843 73 412 Census family file 31 102 69 408 Key file 64 783 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
21. iables 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 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 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 Statistics Canada 8 Catalogue no 75F0002M 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 WTCSLD2
22. 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 6 Catalogue no 75F0002M The following describes the structure of the additional information files A The columns of the record layout file Variable name This is the variable name assigned for the public use microdata file Type Indicates whether the variable is numeric in the sense that it can logically be used in mathematical operations or character 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 Sequence Indicates the order of variable appearance Start position This shows the location of the variable on the public use microdata file 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
23. lhpf46 fmsaf46 fmuif46 fmwcf46 nbear46 nbempd46 nbfyft46 nbscft46 nbscpt46 Numeric Numeric Numeric Numeric Numeric Numeric Numeric Numeric Character Character Character Numeric Numeric Numeric Numeric Numeric 8 0 8 0 8 0 8 0 8 0 8 0 8 0 5 0 2 0 2 0 2 0 2 0 2 0 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 325 333 341 349 357 365 373 381 386 387 388 389 391 393 395 397 Census family total Self employment net income Census family total Total income before taxes Census family total Universal child care benefit Census family total Union dues other professional premiums Census family total Employment Insurance benefits Census family total Wages amp salaries before deductions Census family total Workers compensation benefits Total hours paid all jobs census family members reference year Flag Census family member received Social Assistance reference year Flag Census family received El during reference year Flag Census family received Worker s Compensation reference year Number of earners 16 or older in census family for reference year Number of census family members employed any time in reference year Number of census family members in full year full time jobs reference year Number
24. making assumptions about the variable definition based on the long variable name 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 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 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 Statistics Canada 7 Catalogue no 75F0002M 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 frequ
25. of the year reawptt Character 2 63 156 Reason why person worked less than 30 hours per week scdtyp1 Character 2 64 158 Type of work schedule at end of year for given job tothrp1 Numeric 4 0 65 160 Total hours paid at this job in reference year typptt Character 1 66 164 Type of part time work at this job for reference year Statistics Canada 25 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos wkhm1 Character 1 67 165 Flag Person regularly worked at home for this job hrwkhm1 Decimal 5 1 68 166 Hours per week worked at home for job nocg2e6 Character 2 69 171 NOC S 2006 NOC S 2001 End of reference year manag1 Character 1 70 173 Flag Job was perceived as managerial superv1 Character 1 71 174 Flag Job involved supervising employees imphwe1 Decimal 6 2 72 175 Hourly wage at end of job or end of reference year penpin1 Character 1 73 181 Flag Has pension plan with this job in reference year uncoll1 Character 1 74 182 Flag Union member or covered by collective agreement muloc10 Character 1 75 183 Flag Employer operates at more than one location n07c3g10 Character 2 76 184 Grouping 3 industry code of employer based on NAICS 2007 nbemai10 Character 1 77 186 Number of employees at all locations nbempl1 Character 1 78 187 Number of employees at person s place of work pubpv10 Character 1 79 188 Flag Employer is in
26. onomic family total Federal GST HST Credit Economic family total Government transfer federal amp provincial Economic family total Income tax federal plus provincial Economic family total Investment income Flag Family after tax income is below LICO in reference year Flag Family before tax income is below LICO in reference year Economic family total disposable income for MBM Statistics Canada 15 Catalogue no 75F0002M Text table 3 External cross sectional economic family file ec2007ef continued Variable name Type Field Start Long name pos mbmpf27 Character 1 36 198 Flag Family s disposible income below the Market Basket Measure medx27 Numeric 8 0 37 199 Economic family total Direct medical expenses mjsif27 Character 2 38 207 Major source of income for economic family mtinc27 Numeric 8 0 39 209 Economic family total Market income nfmse27 Numeric 8 0 40 217 Economic family total Non farm self employment net income oasgi27 Numeric 8 0 41 225 Economic family total Old Age Security benefits ogovtr27 Numeric 8 0 42 233 Economic family total Other government transfers ottxm27 Numeric 8 0 43 241 Economic family total Other income pen27 Numeric 8 0 44 249 Economic family total Private retirement pensions pengiv27 Numeric 8 0 45 257 Pension Income Splitting Transferee penrec27 Numeric 8 0 46 265 Pension income transfered from spouse received phpr27 Numeric 8 0
27. ses mtinc42 Numeric 8 0 101 351 Market income nfmse42 Numeric 8 0 102 359 Non farm self employment net income oasgi42 Numeric 8 0 103 367 Total of Old Age Security benefits ogovtr42 Numeric 8 0 104 375 Other government transfers ottxm42 Numeric 8 0 105 383 Other other income pen42 Numeric 8 0 106 391 Private retirement pensions Includes pension income splitting pengiv42 Numeric 8 0 107 399 Pension Income Splitting Transferee penrec42 Numeric 8 0 108 407 Pension income transfered from spouse received phpr42 Numeric 8 0 109 415 Public health insurance premiums prpen42 Numeric 8 0 110 423 Private retirement pensions pvitx42 Numeric 8 0 114 431 Provincial income tax pvtxc42 Numeric 8 0 112 439 Provincial tax credits rppc42 Numeric 8 0 113 447 Registered pension plan contributions rspwi42 Numeric 8 0 114 455 RRSP withdrawals sapis42 Numeric 8 0 115 463 Social Assistance Statistics Canada 27 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos semp42 Numeric 8 0 116 471 Self employment net income ttinc42 Numeric 8 0 117 479 Total income before taxes uccb42 Numeric 8 0 118 487 Universal child care benefit udpd42 Numeric 8 0 119 495 Union dues and other professional premiums uiben42 Numeric 8 0 120 503 Employment Insurance benefits wgsal42 Numeric 8 0 121 511 Wages amp salaries before deductions wkrcp42 Numeric 8 0
28. tgage payments excluding property taxes rentm25 Numeric 8 0 28 76 Regular monthly rent paid by the household for the dwelling Statistics Canada 23 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos multj28 Character 1 29 84 Flag Multiple job holder in any month in reference year nbjbs28 Numeric 2 0 30 85 Number of jobs held during reference year alfst28 Character 2 31 87 Annual labour force status ml01v28 Character 2 32 89 Monthly labour force status January ml02v28 Character 2 33 91 Monthly labour force status February ml03v28 Character 2 34 93 Monthly labour force status March ml04v28 Character 2 35 95 Monthly labour force status April ml05v28 Character 2 36 97 Monthly labour force status May ml06v28 Character 2 37 99 Monthly labour force status June ml07v28 Character 2 38 101 Monthly labour force status July ml08v28 Character 2 39 103 Monthly labour force status August ml09v28 Character 2 40 105 Monthly labour force status September ml10v28 Character 2 41 107 Monthly labour force status October ml11v28 Character 2 42 109 Monthly labour force status November ml12v28 Character 2 43 111 Monthly labour force status December wksem28 Numeric 2 0 44 113 Total number of weeks employed during reference year wksnlf28 Numeric 2 0 45 115 Total number of weeks not in the labour force during reference year wksuem28 N
29. tistical 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 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 e 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
30. tistics Canada Ottawa Ontario Canada K1A OT6 March 2010 Catalogue no 75F0002M no 001 ISSN 1707 2840 ISBN 978 1 100 14727 7 Frequency Occasional Ottawa Cette publication est galement disponible en fran ais Note of appreciation Canada owes the success of its statistical system to a long standing partnership between Statistics Canada the citizens of Canada its businesses governments and other institutions Accurate and timely statistical information could not be produced without their continued cooperation and goodwill Table of contents Ls INO GUC ON ai SAE E E BG 5 27 Pile SUC LORS al oz cen3 os tht Siu adn oe celts dan E ieee as We acne oem ba tiusa dues EE S 6 3 Using the record layouts data dictionary and univariate distributions eeeeeeeee 6 4 Guidelines for applying weights cs5c2 oc cascascccens vaccavcgouneteet sancacatarqctadeaccanes eee enee ae 8 5 Guidelines for release data quality and rounding cece eeeeceeeeeceteeeeeeeeeeeteeeeneeeeaees 9 6 Confidentiality of the public use microdata ceeescecesececeeececeeeeeceeececeeeeeeseeeeneeeenas 12 7 SLID content notes and definition methodology 0 0 0 eeeeeeeeeceeesececseeeeeeteeeenteeeenaeeees 13 8 Related products and services x s c hs5tes ccacsnauaeedat upreandadaedeatanceaiansuneeued eaec uarnaitaal aeatscas anes 13 9 Questions and comments cceesesscececccecsessnsecececececsesenseaeceseceesenensaseeececces
31. tistics Canada has developed standards of service that its employees observe To obtain a copy of these service standards please contact Statistics Canada toll free at 1 800 263 1136 The service standards are also published on www statcan gc ca under About us gt Providing services to Canadians Statistics Canada Income Statistics Division Income Research Paper Series User s Guide for Cross Sectional Public Use Microdata File Survey of Labour and Income Dynamics SLID 2007 Published by authority of the Minister responsible for Statistics Canada Minister of Industry 2010 All rights reserved The content of this electronic publication may be reproduced in whole or in part and by any means without further permission from Statistics Canada subject to the following conditions that it be done solely for the purposes of private study research criticism review or newspaper summary and or for non commercial purposes and that Statistics Canada be fully acknowledged as follows Source or Adapted from if appropriate Statistics Canada year of publication name of product catalogue number volume and issue numbers reference period and page s Otherwise no part of this publication may be reproduced stored in a retrieval system or transmitted in any form by any means electronic mechanical or photocopy or for any purposes without prior written permission of Licensing Services Client Services Division Sta
32. tus of person as of December 31 of reference year Statistics Canada 22 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos mjacg26 Character 1 11 43 Person s major activity at end of reference year group fslac26 Character 1 12 44 Flag Person is living with adult children 25 reference year fslsp26 Character 1 13 45 Flag Person living with spouse in reference year immst15 Character 1 14 46 Flag Person is an immigrant yrimmg26 Character 1 15 47 Number of years since person immigrated to Canada group disabs26 Character 1 16 48 Flag Disability status for the reference year pvreg25 Character 2 17 49 Province of residence group household December 31 reference year uszga25 Character 1 18 51 Adjusted size of area of residence hhsz25 Numeric 2 0 19 52 Number of persons in household as of December 31 of reference year hhcomp25 Character 1 20 54 Household composition as of December 31 of reference year condm25 Numeric 8 0 21 55 Monthly condominium fee paid by household for dwelling dwityp25 Character 1 22 63 Type of dwelling dwtenr25 Character 1 23 64 Ownership of dwelling repa25 Character 1 24 65 Repairs dwelling needed suit25 Character 1 25 66 Flag Dwelling suitable according to National Occupancy Standard mortg25 Character 1 26 67 Flag There is a mortgage on the dwelling mortgm25 Numeric 8 0 27 68 Monthly mor
33. ue 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 components 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 the
34. umeric 2 0 46 117 Total number of weeks unemployed during reference year fpdwk28 Character 1 47 119 Flag Person was a paid worker during reference year fsein28 Character 1 48 120 Flag Self employed incorporated job in reference year Statistics Canada 24 Catalogue no 75F0002M Text table 5 External cross sectional person file ec2007pr continued Variable name Type Size Field Start Long name pos fseui28 Character 1 49 121 Flag Self employed unincorporated job in reference year alhrp28 Numeric 4 0 50 122 Total hours paid all jobs during reference year mtlswk28 Numeric 3 0 51 126 Number of months since person last worked scsum28 Character 2 52 129 Yearly summary of schedules of jobs during the reference year cmphrw28 Decimal 6 2 53 131 Composite hourly wage all paid jobs in reference year rcvemp28 Character 1 54 137 Flag Received compensation during reference year yrxfte 1 Numeric 2 0 55 138 Number of years of work experience full year full time jobdur1 Numeric 3 0 56 140 Duration of job up to the end of current reference year months clwkr1 Character 2 57 143 Class of worker in reference year prmjb1 Character 1 58 145 Flag Permanent job reanp1 Character 2 59 146 Reason why this job is not permanent awh12v5 Decimal 5 1 60 148 Average weekly hours at job in December fllprt1 Character 1 61 153 Flag Job was full time in reference year reaisc1 Character 2 62 154 Reason for irregular work schedule at end
35. vey 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 SCF 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 75MO010XCB 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 PUMEF 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 p
36. y 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 properly take the sample design into account when producing variance estimates that form part of most test statistics 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 Statistics Canada 11 Catalogue no 75F0002M 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 sta
Download Pdf Manuals
Related Search