Français   Index

 

SLID Systems

SLIDRet 4.0

 

Important things to know

The information in this section has been added as a result of questions from users.

For all queries

 

·        The weight used to select the sample NOW appears using its actual name. The weight no longer appears in the record layout with the letter AA@ as prefix (e.g. AICSWT26 instead of ICSWT26 or AILWCP26 instead of ILWCP26, etc.). That automatic or Asystem@ weight will not appear in the data dictionary, unless you add it to your list of selected variables.

·        Deleting queries using Windows Explorer no longer poses a problem. Therefore the Delete option has been removed from the SLIDRet menu.

·        SLIDRet queries are saved with the .qry extension.

·        To improve the performance of SLIDRet for large or complex queries, you may find it helpful to close some of the other large or memory intensive applications you have open at the same. This is however normally not required.

·        There are reserved codes in SLID. The pattern followed by the reserved codes is:

...6 => Interim Processing Code

...7 => Don’t know

...8 => Refusal

...9 => Not applicable

You can find the codeset associated to a particular variable in the codeset file (*.cod) produced by SLIDRET, and in the data dictionary.

 


For cross-sectional queries:

 

·        The year, appropriate weight and identifiers are automatically inserted into the query results, and do not appear in the list of variables available.


·        For the reference year(s) selected, SLIDRET automatically inserts the cross-sectional weight associated with the unit of analysis: for PERSON, the associated weight is ICSWT26 (exception:  if you select any variable from the theme LABOUR, the labour weight ILBWT26 is automatically selected); for PERSON-JOB, JOB ABSENCE and JOBLESS SPELL, the associated weight is ILBWT26. For all other units of analysis, the default weight is ICSWT26.

·        As a consequence of the integration of the SCF and SLID samples for the 1993-1997 period, new cross-sectional weight variables were created this year to ease the use of weights for data users. Cross-sectional weights are now available if one wants to use data from the SCF sample exclusively (WTCSCF26) or if one wants to use data from the SLID sample exclusively (WTCSLD26) or if one wants to use data from the combined sample of SCF and SLID for the years that they overlap (ICSWT26).

 

Note that the labour weight ILBWT26 is a person weight, not a household integrated weight as are the cross-sectional weights ICSWT26, WTCSCF26 and WTCSLD26: be careful when you use it in estimates of families or households.

 

·        SLIDRET extracts the cross-sectional sample for weights greater than zero for selected year(s).

·        After selecting PERSON as the unit of analysis, it is possible to select job characteristics. For persons with more than one job during a particular year, the job characteristics on the output file are those of the main job held during the year (i.e., the one at which the person worked the most hours). Those without a job would have a value of ANot applicable@ for all job variables.

·        Similarly, for queries with units of analysis HOUSEHOLD, ECONOMIC FAMILY and CENSUS FAMILY, it is possible to select person-level characteristics. These characteristics on the output file pertain to the Major Income Earner (MIE) in that group of persons for the year of interest. The MIE is the person in that group of persons who received the greatest income among all group members. Job characteristics of the MIE’s main job may also be included.

 


 

Here are the three possibilities:

Please, use the following statement in the Restrict Option (see section at the end of the manual)

                RESP99 equals 90

 

Please, use the following statement in the Restrict Option (see section at the end of the manual)

                RESP99 not equals 90

 

Please, use the following statement in the Restrict Option (see section at the end of the manual)

                (YEAR99 more than 1989

                AND YEAR99 less than 1996

               AND RESP99 equals 90)

                OR (YEAR99 more than 1995

                AND YEAR99 less than 1998

               AND RESP99 not equals 90)

 


 


For longitudinal queries:

 

·        The units of analysis Marital status and Education certificates automatically give you all data in the database up to the latest year selected, regardless of which other years you selected.

·        For Longitudinal (year) type of analysis SLIDRET extracts the longitudinal sample for weights greater than zero and response code RESP99 = “01” (longitudinal person in scope) for the latest year selected in the query.

·        For Longitudinal (panel) type of analysis SLIDRET extracts data for all the longitudinal persons in the panel(s) selected for the years indicated regardless of the weight values and response code.

·        SLIDRET will automatically choose the weight that will allow you to have the largest sample available. ILGWT26 will be used for extractions over 4, 5, or 6 years, or when the panels do not overlap. ILWCP26 will be used to combine two panels and study the behaviour of their population for the years they do overlap.

·        SLIDRET users who make longitudinal (year) queries should take account of the panel rotation when selecting the reference years covered by the query.  Panel 1 started with reference year 1993, and subsequent panels start every 3 years.  The life of each panel is 6 years.  In addition to the six full years of data, some baseline information is available for the year prior to the start of the panel (for example, 1992 for panel 1).  Those users who select more than 7 years or those users who select a range of years which do not correspond to the sample rotation will get results which may not be very useful.  Variables corresponding to years in which the person was not in the SLID sample will have a value of "not applicable" on the data file produced by SLIDRET.

 

The following chart identifies the years covered by each panel:

 

Panel

 

Full data

 

Baseline data

 

1

 

1993 to 1998

 

1992

 

2

 

1996 to 2001

 

1995

 

3

 

1999 to 2004

 

1998

 

4

 

2002 to 2007

 

2001

 

5

 

2005 to 2010

 

2005

 

...

 

...

 

...

 

And the next one illustrates how panels overlap:

 

 

1993

 

1994

 

1995

 

1996

 

1997

 

1998

 

1999

 

2000

 

2001

 

2002

 

2003

 

2004

 

Panel 1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Panel 2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Panel 3

 

Here is a description of the seven different units of analysis for longitudinal (year) queries.

 

·        PERSON: all persons selected as a member of the active longitudinal panels who were respondent in the last year included in the query and who were in scope in the last year included in the query. The Ain scope@ part means that those who die, are institutionalized or emigrate would be excluded. There would be one record per person on the file. On a longitudinal extraction for 1993 to 1995, there are 26,875,830 estimated persons in Canada.

 

      Notice that for all the subsequent files the persons included are subsets of the persons on the PERSON file.

 

·        PERSON-JOB: one record for every job (up to 6 jobs per year) held by every person on the PERSON file during the years included in the query. A person with no job in any of the years would not be included in the file. On a longitudinal extraction for 1993 to 1995, there are 27,392,244 estimated person-jobs in Canada.

 

·        JOB ABSENCE: one record for every absence (up to 2 absences per job per year) taken from every job included on the PERSON-JOB file during the years included in the query. A person with no job would not be included in the file. On a longitudinal extraction for 1993 to 1995, there are 5,477,868 estimated job absences in Canada.

 

·        JOBLESS SPELL: one record for every jobless spell experienced by each person included in the PERSON longitudinal file during the years included in the query (up to 7 jobless spells per year). A person without a jobless spell in all years would not be included in the file. On a longitudinal extraction for 1993 to 1995, there are 16,154,065 estimated jobless spells in Canada.

 

·        MONTHLY RECEIPT OF EI/WC/SA: one record for each person (up to 3 record per year) included in the PERSON longitudinal file for each program from which benefits were received during the years included in the query. A person who does not receive any of these benefits during any of the years would not be included in the file. On a longitudinal extraction for 1993 to 1995, there are 8,590,762 estimated monthly receipts in Canada.

 

·        MARITAL STATUS: one record for every marital spell experienced by every person included in the PERSON longitudinal file. Every person will have at least one marital spell (i.e., single). On a longitudinal extraction for 1992 to 1995, there are 49,544,035 estimated marital status in Canada.

 

·        EDUCATIONAL CERTIFICATE: one record for every post-secondary degree, diploma or certificate received by every person in the PERSON longitudinal file. A person without such a certificate would not be included on the file. On a longitudinal extraction for 1992 to 1995, there are 14, 076,174 estimated education certificates in Canada.

 

For Longitudinal (panel) type of analysis files have the same content as described above but for all the longitudinal persons in the panel(s) selected for the years indicated regardless of the weight values and response code.