Question
A file called Community Profiles was released along with the pumf for the
1991 Aboriginal Peoples Survey. A graduate student would like a similar
aggregated file from the later APS surveys.
She is aware of the 2001 Census Aboriginal Population Profile and the 2006
Census Aboriginal Population Profile. It would be convenient for her to be
able to look at all the communities in one file instead of having to work
her way through them one community at a time. All the topic-based
tabulations with aboriginal identity, etc., lack census subdivision level
coverage as far as I can see.
So the question is, are there amalgamated Community Profiles for 2001 and
2006?
Answer
I found some aboriginal tables at the CSD level that may offer what your
student needs.
For 2006, there is a topic-based tabulation in the Aboriginal Peoples of
Canada CD-ROM that is at the Census Subdivision level:
/dli/census-recensement/2006/Topic-based-tabulations/aboriginal-peoples/cd-r
om
The file number and name is 92-598-XCB2006001 (Aboriginal Population Profile
for Canada, Provinces and Territories, Census Divisions and Census
Subdivisions, 2006 Census).
For 2001, there is a CSD-level table as well:
/dli/census-recensement/2001/B2020/Profiles/aboriginal-b2020
The file number and name is 94f0043xcb01001.ivt (Aboriginal Population
Profile for Canada, Provinces, Territories, Census Divisions and Census
Subdivisions, 2001 Census).
Friday, March 13, 2009
Average years of schooling
Question
I am wondering if there is an easy answer to this question of “average age of schooling for Canadians”. Although not conveyed in the email from the Grad student, the key to this request (communicated during a phone chat) is the desire to have annual data on this topic, back to the 1970’s. Also, if possible, to have the data by province. The student adds via email:
Pertaining to our discussion yesterday, the data that I'm looking for is this:
What is the average years of schooling for Canadians?
By schooling, I mean elementary, high school (secondary), and university or an accredited/recognized post-secondary educational institution.
So for example, I have:
elementary through high school so that's 12 years
my bachelor's degree so that's 5 years
one master's degree so that 2 years
my second master's degrees (in progress) 2 years.
total years of schooling is 12 + 5 + 2 + 2 = 21 years.
The data can be aggregated to all Canadians.
Thanks for any help. We have looked at the Labour Force Survey (educational attainment) via SDA, but there appears to be no simple (single) answer for the question asked, in terms of annual data for “average years” of schooling for Canadians.
Answer
Here is a summary of what the author divisions have told me about the years of schooling variable:
- census data for this variable is not available for 2006 due to changes in the questionnaire. This matches some information I found on the following page of the Statcan site (scroll down to the heading "Modified Questions - Education)": http://www12.statcan.ca/english/census06/reference/dictionary/ovpop4a.cfm#04. This means they cannot provide a custom tabulation for 2006 on years of schooling
- total years of schooling is available for census years between 1971 and 2001 as a custom tabulation. Note that the population for 1976 was 1/3 sample and 1971 1/3 sample. Here is the link to the 2001 Census Dictionary stating the comparability years for total years of schooling:
http://www12.statcan.ca/english/census01/Products/Reference/dict/pop121.htm
- LFS has only annual data on "educational attainment" starting in 1990. They suggested that you check the CANSIM table 282-0004 to see if it would correspond to your needs.
I am wondering if there is an easy answer to this question of “average age of schooling for Canadians”. Although not conveyed in the email from the Grad student, the key to this request (communicated during a phone chat) is the desire to have annual data on this topic, back to the 1970’s. Also, if possible, to have the data by province. The student adds via email:
Pertaining to our discussion yesterday, the data that I'm looking for is this:
What is the average years of schooling for Canadians?
By schooling, I mean elementary, high school (secondary), and university or an accredited/recognized post-secondary educational institution.
So for example, I have:
elementary through high school so that's 12 years
my bachelor's degree so that's 5 years
one master's degree so that 2 years
my second master's degrees (in progress) 2 years.
total years of schooling is 12 + 5 + 2 + 2 = 21 years.
The data can be aggregated to all Canadians.
Thanks for any help. We have looked at the Labour Force Survey (educational attainment) via SDA, but there appears to be no simple (single) answer for the question asked, in terms of annual data for “average years” of schooling for Canadians.
Answer
Here is a summary of what the author divisions have told me about the years of schooling variable:
- census data for this variable is not available for 2006 due to changes in the questionnaire. This matches some information I found on the following page of the Statcan site (scroll down to the heading "Modified Questions - Education)": http://www12.statcan.ca/english/census06/reference/dictionary/ovpop4a.cfm#04. This means they cannot provide a custom tabulation for 2006 on years of schooling
- total years of schooling is available for census years between 1971 and 2001 as a custom tabulation. Note that the population for 1976 was 1/3 sample and 1971 1/3 sample. Here is the link to the 2001 Census Dictionary stating the comparability years for total years of schooling:
http://www12.statcan.ca/english/census01/Products/Reference/dict/pop121.htm
- LFS has only annual data on "educational attainment" starting in 1990. They suggested that you check the CANSIM table 282-0004 to see if it would correspond to your needs.
APS 2006
Question
Will this product be made available via DLI as data product ?
The PUMF for the APS 2006 is expected to be released sometime this month, and it will be made available through the DLI.
Will this product be made available via DLI as data product ?
Answer
The PUMF for the APS 2006 is expected to be released sometime this month, and it will be made available through the DLI.
SHS 2005 vs. SHS 2006
Question
Here's the silliest of silly questions - I'm looking at the SPSS syntax
provided to us for the 2005 and the 2006 SHS PUMF file. Why is it in 2005
all the variables are coded as string and in 2006 they're coded as numeric?
I missed this the first time - but my faculty didn't
Answer
FYI - the SPSS syntax for SHS 2006 has been changed so that it is consistent
with the coding for earlier years. I will be sending out an announcement to
this effect soon.
Here's the silliest of silly questions - I'm looking at the SPSS syntax
provided to us for the 2005 and the 2006 SHS PUMF file. Why is it in 2005
all the variables are coded as string and in 2006 they're coded as numeric?
I missed this the first time - but my faculty didn't
Answer
FYI - the SPSS syntax for SHS 2006 has been changed so that it is consistent
with the coding for earlier years. I will be sending out an announcement to
this effect soon.
2006 SLID - SAS and SPSS syntax files
Question
Two researchers here at York, using the pumfs from the 2006 SLID, have
reported problems with the syntax files in SPSS and SAS. Both are
receiving error messages for missing value specifications. I am not
very familiar with these applications and don't know how to help. Any
suggestions would be very welcome.
Answer
The SLID 2006 SPSS files have been updated. I will be sending out an
announcement regarding these and other updated SLID files soon.
Two researchers here at York, using the pumfs from the 2006 SLID, have
reported problems with the syntax files in SPSS and SAS. Both are
receiving error messages for missing value specifications. I am not
very familiar with these applications and don't know how to help. Any
suggestions would be very welcome.
Answer
The SLID 2006 SPSS files have been updated. I will be sending out an
announcement regarding these and other updated SLID files soon.
Maternity Experiences Survey 2006 - record 5019
Question
Will there be a PUMF for this one time survey?
Answer
In January, the author division told me that there would be no PUMF for this survey. However, the microdata is available through the Research Data Centres, and custom tabulations are also available. I found the answer in the listserv archives:
http://www.statcan.gc.ca/dli-ild/data-donnees/mhonarc/dli-ild-msg/msg14381.html
Will there be a PUMF for this one time survey?
Answer
In January, the author division told me that there would be no PUMF for this survey. However, the microdata is available through the Research Data Centres, and custom tabulations are also available. I found the answer in the listserv archives:
http://www.statcan.gc.ca/dli-ild/data-donnees/mhonarc/dli-ild-msg/msg14381.html
E-Stat Access Problem
*Note: Some correspondence translated from the original French.
Question
It seems there's a problem with accessing E-Stat lately. I am getting error messages when clicking on links from the menu at right.
http://estat.statcan.ca/cgi-win/CNSMCGI.exe?Lang=F&CANSIMFile=EStat/Francais/CII_1_F.htm
Answer
The url needs to be updated with the .gc portion
http://www.statcan.gc.ca/estat/licence-eng.htm
Follow-up Question
I thought we were assured that the URLs would be redirected for a
number of months. Has that not happened?
Follow-up Answer
I don't think redirection is happening to a great extent.
I just found out that some weeks ago we had to change the urls for over 500
Stat Can publications that were linked from our catalogue. The Collections staff
just went ahead and did it without letting me know there was a problem.
Apparently a Find and Replace technique worked for many of the urls.
But I think it would be useful to be told ahead of time that something
like this was about to occur so we could plan for it.
***
UPDATE:
We been working with Dissemination Division to find solutions to the redirection issues you have found with E-STAT and the Statistics Canada web site in general. Here are the results of their discussions:
1. Redirection for E-STAT addresses has been problematic and the solutions are not straightforward. Therefore, to ensure the E-STAT works correctly you must access it through the following URLs:
English: http://www.statcan.gc.ca/estat/licence-eng.htm
French: http://www.statcan.gc.ca/estat/licence-fra.htm
2. Redirection should be working for the rest of the Statistics Canada site. However, it is clear from your feedback that there are URLs that are not redirecting. If you find a link that is not redirecting properly, please let us know so we can have Dissemination Division fix it. The intention is still that redirects (outside of E-STAT) will work for at least the next 2 years so it is important that we correct any that are not working at the moment.
Thank you all for your feedback and patience on this matter. We will be sure to inform Dissemination Division of any problems you report to us regarding redirection.
Follow-up Question
Would this be a good time to update all the www.statcan.ca links to www.statcan.gc.ca that are scattered across our websites?
If I am asking for E-Stat to be updated everywhere I may as well ask for other links to be done as well
Or are there some areas where this would cause problems?
Follow-up Answer
There are some areas of the site that still have issues with their URLs. I would recommend holding off on updating all the URLs for the time being until most or all of them are resolved.
In the meantime, please be sure to report any URLs that you find that are not redirecting properly.
Question
It seems there's a problem with accessing E-Stat lately. I am getting error messages when clicking on links from the menu at right.
http://estat.statcan.ca/cgi-win/CNSMCGI.exe?Lang=F&CANSIMFile=EStat/Francais/CII_1_F.htm
Answer
The url needs to be updated with the .gc portion
http://www.statcan.gc.ca/estat/licence-eng.htm
Follow-up Question
I thought we were assured that the URLs would be redirected for a
number of months. Has that not happened?
Follow-up Answer
I don't think redirection is happening to a great extent.
I just found out that some weeks ago we had to change the urls for over 500
Stat Can publications that were linked from our catalogue. The Collections staff
just went ahead and did it without letting me know there was a problem.
Apparently a Find and Replace technique worked for many of the urls.
But I think it would be useful to be told ahead of time that something
like this was about to occur so we could plan for it.
***
UPDATE:
We been working with Dissemination Division to find solutions to the redirection issues you have found with E-STAT and the Statistics Canada web site in general. Here are the results of their discussions:
1. Redirection for E-STAT addresses has been problematic and the solutions are not straightforward. Therefore, to ensure the E-STAT works correctly you must access it through the following URLs:
English: http://www.statcan.gc.ca/estat/licence-eng.htm
French: http://www.statcan.gc.ca/estat/licence-fra.htm
2. Redirection should be working for the rest of the Statistics Canada site. However, it is clear from your feedback that there are URLs that are not redirecting. If you find a link that is not redirecting properly, please let us know so we can have Dissemination Division fix it. The intention is still that redirects (outside of E-STAT) will work for at least the next 2 years so it is important that we correct any that are not working at the moment.
Thank you all for your feedback and patience on this matter. We will be sure to inform Dissemination Division of any problems you report to us regarding redirection.
Follow-up Question
Would this be a good time to update all the www.statcan.ca links to www.statcan.gc.ca that are scattered across our websites?
If I am asking for E-Stat to be updated everywhere I may as well ask for other links to be done as well
Or are there some areas where this would cause problems?
Follow-up Answer
There are some areas of the site that still have issues with their URLs. I would recommend holding off on updating all the URLs for the time being until most or all of them are resolved.
In the meantime, please be sure to report any URLs that you find that are not redirecting properly.
Subscribe to:
Posts (Atom)