Education Tables
Our friends in the Culture, Tourism and the Centre for Education Statistics Division provided the DLI with a few standard tables that they usually sell at a fee but are not listed in the on-line catalogue. These are deemed to be semi-custom tables.
The data stem from a variety of surveys including:
- Financial Information of Universities and Colleges Survey (FIUC)
- Elementary-Secondary Education Statistics Project (ESESP)
- Tuition and Living Accommodation Costs for Full-time Students at Canadian Degree-granting Institutions
- University and College Academic Staff System (UCASS)
Well worth a quick look!
FTP: /usr2/ftp/dli/education
WEB: http://www.statcan.ca/english/Dli/Data/Ftp/education.htm
Monday, February 12, 2007
Friday, February 9, 2007
Unable to locate derived variable in CCHS 3.1
Question
Smoking Stage of Change (Current and Former Smokers)
Variable name: SCHEDSTG
Modules used: Smoking (SMK), Smoking -- Stages of Change (SCH)
Based on: SMKE_202, SMKE_06A, SMKE_06B, SMKE_09A, SMKE_09B, SMKE_10, SMKE_10A, SMKE_10B,
SCHE_1, SCHE_2, SCHE_3, SCHE_4, ADME_MOI
Product: Master Data File and Public Use Microdata File (PUMF)
Description: This variable classifies current and former smokers into categories based on the stages of change
model.
Reference: DiClemente, C.C., Prochaska, J.O., Fairhurst, S., Velicer, W.F., Rossi J.S., & Velasquez, M. (1991).
The process of smoking cessation: An analysis of precontemplation, contemplation and contemplation/action.
Journal of Consulting and Clinical Psychology, 59, 295-304.
As noted in this documentation it is supposed to be in the PUMF, but I can't locate it in any of the cycles for the 3.1 - was it not included in the PUMF as released?
Answer
Here's what Health told us about the missing variable.
The "Smoking - Stages of Change" module is an optional module, selected in the 3.1 by a single health region: the Yukon Territory. In the PUMF, because the three territories are collapsed to a single geography, the module (hence all SCH module variables including SCHEDSTG) is suppressed. The 3.1 document on DVs is incorrect in stating the data reside in both the master (yes) and PUMF (no). The data dictionaries provide a more accurate picture. Sorry about the confusion.
Back one cycle in time, i.e., CCHS 2.1 (2003), the module had been selected more widely, and the data appear in the corresponding PUMF. A quick way to verify if/where optional content appears is to run a cross tab on HR (health region) geography against the module's selection flag. In the case of this particular module, in the 2.1: SCHCFOPT against GEOCDPMF. This takes 30 seconds using the PUMF's built-in B20/20 browser.
Smoking Stage of Change (Current and Former Smokers)
Variable name: SCHEDSTG
Modules used: Smoking (SMK), Smoking -- Stages of Change (SCH)
Based on: SMKE_202, SMKE_06A, SMKE_06B, SMKE_09A, SMKE_09B, SMKE_10, SMKE_10A, SMKE_10B,
SCHE_1, SCHE_2, SCHE_3, SCHE_4, ADME_MOI
Product: Master Data File and Public Use Microdata File (PUMF)
Description: This variable classifies current and former smokers into categories based on the stages of change
model.
Reference: DiClemente, C.C., Prochaska, J.O., Fairhurst, S., Velicer, W.F., Rossi J.S., & Velasquez, M. (1991).
The process of smoking cessation: An analysis of precontemplation, contemplation and contemplation/action.
Journal of Consulting and Clinical Psychology, 59, 295-304.
As noted in this documentation it is supposed to be in the PUMF, but I can't locate it in any of the cycles for the 3.1 - was it not included in the PUMF as released?
Answer
Here's what Health told us about the missing variable.
The "Smoking - Stages of Change" module is an optional module, selected in the 3.1 by a single health region: the Yukon Territory. In the PUMF, because the three territories are collapsed to a single geography, the module (hence all SCH module variables including SCHEDSTG) is suppressed. The 3.1 document on DVs is incorrect in stating the data reside in both the master (yes) and PUMF (no). The data dictionaries provide a more accurate picture. Sorry about the confusion.
Back one cycle in time, i.e., CCHS 2.1 (2003), the module had been selected more widely, and the data appear in the corresponding PUMF. A quick way to verify if/where optional content appears is to run a cross tab on HR (health region) geography against the module's selection flag. In the case of this particular module, in the 2.1: SCHCFOPT against GEOCDPMF. This takes 30 seconds using the PUMF's built-in B20/20 browser.
Wednesday, February 7, 2007
Turnover rates by industry
Question
A grad student here is looking for 2005 and 2006 annual turnover rates for two industries (I'm still getting clarification about what industries she's after). She's defining turnover rate (or attrition) as "the rate employees separate/leave an organization voluntarily (or involuntarily). Usually, it's calculated by number of terminations divided by total number of employees in an organization."
I realize I can probably concoct the data by manipulating the LFS, but was hoping to find something pre-digested, as it were.
Answer
This research might help the student find sources:
http://www.statcan.ca/english/research/11F0019MIE/11F0019MIE2003199.pdf
The division has also suggested using the Labour Force Survey.
A grad student here is looking for 2005 and 2006 annual turnover rates for two industries (I'm still getting clarification about what industries she's after). She's defining turnover rate (or attrition) as "the rate employees separate/leave an organization voluntarily (or involuntarily). Usually, it's calculated by number of terminations divided by total number of employees in an organization."
I realize I can probably concoct the data by manipulating the LFS, but was hoping to find something pre-digested, as it were.
Answer
This research might help the student find sources:
http://www.statcan.ca/english/research/11F0019MIE/11F0019MIE2003199.pdf
The division has also suggested using the Labour Force Survey.
Friday, February 2, 2007
Graduate Salary Information
Question
I had thought that this would be an easy find--my mistake. If it should have been an easy find, my apologies. I think that the information is likely in ESIS (Enhanced Student Information System), but this doesn't appear to be part of the DLI collection. Is there any way to get the following information short of paying for a custom tab?
I would like to know the average salary after 2 years (or 3 or 4 or 5 years) for people graduating with a BA in communication in Canada. Several years ago, a sessional we had hired in Mass Communication had extracted that information from Statistics Canada.
His information compared the salaries of people who had a BA in communication with those who had a community college degree with those who had a BA and then went to college. In all cases, the straight BA came out significantly ahead (especially when compounded over 10 or 20 years). He had the statistics after 2 years, after 5 and after 10.
Answer
ESIS would not be the best source for this information as it tends to be administrative data from the universities themselves. However, I am not sure if you looked at the National Graduate Survey (NGS) or the follow-up surveys?
If the information can not be found in the PUMF, a custom extraction can be done - but starting at $1000 and taking weeks to complete.
1995 is the most recent NGS data we have in the DLI collection. The production of NGS 2000 is still on hold (but I heard they are actually working towards it, but it is at the bottom of a long list of priorities. We will see some basic tables and analysis at some point, the release of custom tables which will be provided free of charge to the DLI, and then the PUMF). No date provided.
The best I can offer is that there is a Master file for 2000 and the user can order custom tabulations at a fee. There is no data yet
available for 2005.
I had thought that this would be an easy find--my mistake. If it should have been an easy find, my apologies. I think that the information is likely in ESIS (Enhanced Student Information System), but this doesn't appear to be part of the DLI collection. Is there any way to get the following information short of paying for a custom tab?
I would like to know the average salary after 2 years (or 3 or 4 or 5 years) for people graduating with a BA in communication in Canada. Several years ago, a sessional we had hired in Mass Communication had extracted that information from Statistics Canada.
His information compared the salaries of people who had a BA in communication with those who had a community college degree with those who had a BA and then went to college. In all cases, the straight BA came out significantly ahead (especially when compounded over 10 or 20 years). He had the statistics after 2 years, after 5 and after 10.
Answer
ESIS would not be the best source for this information as it tends to be administrative data from the universities themselves. However, I am not sure if you looked at the National Graduate Survey (NGS) or the follow-up surveys?
If the information can not be found in the PUMF, a custom extraction can be done - but starting at $1000 and taking weeks to complete.
1995 is the most recent NGS data we have in the DLI collection. The production of NGS 2000 is still on hold (but I heard they are actually working towards it, but it is at the bottom of a long list of priorities. We will see some basic tables and analysis at some point, the release of custom tables which will be provided free of charge to the DLI, and then the PUMF). No date provided.
The best I can offer is that there is a Master file for 2000 and the user can order custom tabulations at a fee. There is no data yet
available for 2005.
National Survey of the Work and Health of Nurses
Question
I've had an enquiry regarding the eventual possibility of a PUMF coming out of the above-named survey (first described in the Dec
11, 2006 issue of the Daily). Any possibility, or is it destined for the RDC?
Answer
There will not be a PUMF created for this survey.
The RDCs will get a copy of the master file some time in the future, but not before March 2007.
I've had an enquiry regarding the eventual possibility of a PUMF coming out of the above-named survey (first described in the Dec
11, 2006 issue of the Daily). Any possibility, or is it destined for the RDC?
Answer
There will not be a PUMF created for this survey.
The RDCs will get a copy of the master file some time in the future, but not before March 2007.
LSIC Synthetic Files
Question
There's a researcher asking about synthetic files for the longitudinal survey of immigrants to Canada. I've found several discussions in the archives, but no definitive answer regarding their status. Can anyone tell me if synthetic files were ever produced for LSIC?
Answer
LSIC created one synthetic file for wave 1 (wave 2 and 3 will not have a synthetic file). This file is not available to the DLI and does not reside in the RDC either. The RDC never asked for the file, although if they did ask perhaps they could get a copy?
Sorry - only custom tabulations at a fee will be available for this survey for members of the DLI.
There's a researcher asking about synthetic files for the longitudinal survey of immigrants to Canada. I've found several discussions in the archives, but no definitive answer regarding their status. Can anyone tell me if synthetic files were ever produced for LSIC?
Answer
LSIC created one synthetic file for wave 1 (wave 2 and 3 will not have a synthetic file). This file is not available to the DLI and does not reside in the RDC either. The RDC never asked for the file, although if they did ask perhaps they could get a copy?
Sorry - only custom tabulations at a fee will be available for this survey for members of the DLI.
Thursday, February 1, 2007
Annual retail store data (ARSD)
Question
We have the ARSD CD-ROM for 1999/00. The description talks about annual releases. Did this ever happen?
Answer
The CD-Rom is discontinued, but the data is available in two CANSIM tables we currently have under Retail - 80-0011 and 80-0012, and they are up to date.
The division does offer more data (such as sales per square foot, total operating revenues per square foot and number of locations per square foot) but these are only at a price.
We have the ARSD CD-ROM for 1999/00. The description talks about annual releases. Did this ever happen?
Answer
The CD-Rom is discontinued, but the data is available in two CANSIM tables we currently have under Retail - 80-0011 and 80-0012, and they are up to date.
The division does offer more data (such as sales per square foot, total operating revenues per square foot and number of locations per square foot) but these are only at a price.
Subscribe to:
Posts (Atom)