Thursday, September 16, 2010

PALS 2006

Question

I had to do some deep reading to remember why the frequencies in PALS 2006 are so different between the full data set (72,167 cases) and the user guide (17,423 cases), and once again thrilled to the charming explanation of the differences between the original documented record layout and the SAS and SPSS syntax files 8-)

However, now I have a new query. On page 322 of the User guide, we find the following frequencies for variable TENURP:

-5 Not stated 0 0
1 BAND HOUSING 79 13,329
2 NOT APPLICABLE 4,573 1,184,265
3 OWNED BY MEMBER OF HHLD 12,771 2,965,102
4 RENTED 0 0
====== =========
17,423 4,162,696

Hmmmmmmmmmm - no renters anywhere in Canada! And about 26.2% of us live in not applicable housing...the mind boggles, but at least in the midst of Easter, one can think of a few explanations, although I would be sorry to see any of them in a codebook.

Unfortunately, the SAS and SPSS syntax files also contain this error, so the odesi, SDA, and Equinox implementations of this file are all wrong.

Could we get confirmation from the relevant department that value 2 should be 'rented', and 4 'not applicable'?

Thanks in advance!


Answer

Our contacts have looked into your question with a methodologist and there is an error in the PALS 2006 user guide for the variable TENURP. For your reference, the explanation I received from our contacts follows.

"It turns out that there was a system error in the dictionary database when switching from RDC to PUMF resulting in discrepancies in how categories were labeled.

The original PUMF statistics are:
79 = "Band Housing"
4,573 = "Not Applicable"
12,771 = "Owned"
0 = "Rent"

The correct PUMF statistics are:
79 = "Not Applicable"
4,573 = "Band Housing and Rented" (i.e., Rented is a not a separate category in PUMF)
12,771 = "Owned"

The "Not stated" and "Rented" should have been removed from PUMF hence why there are 0 counts for both. The corresponding weights are the same."

I have asked our contacts for a corrected version of the user guide and of any other files affected by this error. We will make them available through the DLI FTP and website as soon as we receive them.

Thank you once for bringing this to our attention.

Beyond 20/20 & Windows 7

Question

We haven't been able to install Beyond 20/20 on a laptop running Windows 7. We have tried compatibility modes but no luck so far. Any solutions would be greatly appreciated.

Answer

Our contact for Beyond 20/20 here at StatCan has confirmed that Beyond 20/20 is compatible with Windows 7. He is aware of an installation issue however that has to do with difference between the Beyond 20/20 installers for 32 bit and 64 bit operating systems. His description of this issue and suggestion follow:

"There are 2 different installers for B2020 currently available on our website, one for 32 bit Operating Systems and one for 64 bit Operating Systems. It is possible that the user has tried to install the 32 bit version on the 64 bit Operating System so I would look to that as the first possible solution.

I believe both install packages are available on the DLI FTP site (note: we will make sure that both install packages are on the DLI FTP site) but I am providing the link to the 64 bit below. Please have your client try the .zip file (unzip the package and run 'setup.exe'). If the problem still occurs we would probably need a little more detail as to the error message being generated so that we can pass that along to the company.

64 bit installer (zip)
http://www2.beyond2020.com/SC/probrowser.zip"

I hope that this resolves the issue you are experiencing. Please let us know if this works.

A Portrait of Mixed Ethnocultural Couples

A portrait of mixed ethnocultural couples which examines the socio-demographic characteristics of mixed union couples in Canada is being released today.

As Canada’s population continues to become ethnoculturally diverse, there is greater opportunity for individuals to form conjugal relationships with someone from a different ethnocultural background. In this study, a mixed union, either marital or common-law, is based on one of two criteria: either one member of a couple belongs to a visible minority group and the other does not; or the couple belongs to different visible minority groups. Using data primarily from the 2006 Census of Population, this study examines the socio-demographic characteristics of mixed union couples in Canada. Studying mixed unions is important not only because these relationships reflect another aspect of the diversity of families today, but also for their implications in terms of social inclusion and identification with one or more visible minority groups, particularly for subsequent generations.

Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm

Voter Turnout By Gender In Canadian Federal Elections

Question

I'm looking for statistics on voter turnout by gender in Canadian federal elections since 1965.

I've looked at the Elections Canada site, the Canadian Election Study (CES) site. I found some data in the collection of studies from the Royal Commission on Electoral Reform and Party Financing /Commission Royale Sur la Réforme Electorale et le Financement des Parties (1989).

I'm just wondering if there are more resources out there.

Your suggestions would be very much appreciated.

Answer

Statistics Canada doesn't collect these data but you may wish to contact Elections Canada to see if they can provide this information. StatCan disseminates little election-related statistics

(ex. summary tables:http://www40.statcan.gc.ca/l01/ind01/l3_75_79-eng.htm?hili_govt09 and Historical Statistics of Canada: http://www.statcan.gc.ca/pub/11-516-x/sectiony/4057759-eng.htm#2);

Our recent statistics on this topic are from Elections Canada.

Rural and Urban Spaces in CMAs

Question

Students at UBC are trying to determine the area in square kilometers of the rural and urban parts of 10 census metropolitan areas for all censuses 1986-2006. All we can find in the published tables and in Geosuite is the total land area.

According to the census dictionary the rural areas of CMAs are designated the rural fringe. Is it at all possible to find the land area for the rural fringe as well as for the urban core and urban fringe?

Thanks for helping to clarify this.

Answer

I checked with our geography consultants and they indicated that this would be very difficult to do but provided provided following steps if the students wish to proceed:

"First, you would have to find the following spatial data layers. 1986, urban core, urban fringe, rural fringe (you would have to subtract urban from total CMA for this calculation); then you would have to find a water layer which was compatible with the 1986 spatial data layers in order to calculate the land area for the areas in question.

You would have to repeat this operation for 1991, 1996, 2001 and 2006 (and you would not be comparing the same area necessarily – due to changes in boundaries, scale and projection from one census to the next).

She also suggested the students could try breaking it down by CSDs. "

Historical Census Data, Churchill, MB

Question

I have a researcher looking for Census data for the town of Churchill, Manitoba between 1901 and 1996. I can access the complete Census from 1901 and 1961-1996 through the FTP, but I was unsure if Census data were available between 1901 and 1961.

They are only, as far as I know, in print publications. I have pdf files of the tables of contents of the print publications from of all censuses between 1901 and 1961 linked from: http://www.chass.utoronto.ca/datalib/major/censusag.htm#1926

(It's the 'Content of tables' link in each respective census'. I find them useful, so that I can determine which of several volumes to look in, before actually heading out to where the print vols. are. Look for any
tables for 'cities, towns, and villages'..........those should include Churchill.

Answer

The StatCan library has the census books, the admin reports and the commissioner manuals for those years. The quinquennial censuses of 06, 16, 26, etc. are loaded with Manitoba data.

Additional Information

If needed, we have a fairly thorough collection of census materials in paper at the Elizabeth Dafoe Library, University of Manitoba. Our Government Documents stacks are open to the public to use within the Library. Not all our older Census materials are catalogued, but they are all in one location, so it is pretty easy to scan through specific Census years.

Mental Health Stats (BC)

Question

I received the following request for statistics/data today while I was away at a Conference. I am not sure how to find all the requested bits and pieces. The Canadian Community Health Survey, cycle 1.2, 2002 (Mental Health) has some data, but does not offer all the data requested.

"I am doing research on mental illness and parenting. Do you have any data/statistics on the following:

1) Number/percentage of people with Schizophrenia, Bipolar, or major depression in B.C. from 2005 to 2010 if available?

2) Hospitalizations in B.C. with Schizophrenia, Bipolar, or Major depression who have children from 2005-2010 if available?

3) Number of grandparents looking after grandchildren in B.C. due to their daughter/son illness (2005-2010)

4) Parental illness and loss of custody in B.C. 2005-2010

5) Parents with mental illness whose children are apprehended or in the care of the Ministry of Children and families Development.

Any information would be appreciated"


Answer

For question 1 ("Number/percentage of people with Schizophrenia, Bipolar, or major depression in B.C. from 2005 to 2010 if available?"), your client may be interested in the provincial-level CANSIM tables on mood disorders (an aggregate) that are available through StatCan's Health Indicators publication

(http://www.statcan.gc.ca/pub/82-221-x/2009001/tblstructure/1hs/1hc/hc1mdx-eng.htm).

The data in these tables are from CCHS and cover 2003, 2005, 2007, 2008. The CCHS PUMFs may also be of interest to your client. 2007, 2008 are the latest years for which data are available from this survey. The "How Healthy Are Canadians? Annual Report 2004" publication

(http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?lang=eng&catno=82-003-S2004000)

focused on mental health and may also be of interest. The National Population Health Survey includes a mental health module but the most recent file is for 2006/2007. NPSH-related products can be accessed via the Links to related products section on the left side bar of

http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3225?=en&db=imdb&adm=8&dis=2.

The survey is also available in the RDCs and data may be available on a custom basis.

For question 2 ("Hospitalizations in B.C. with Schizophrenia, Bipolar, or Major depression who have children from 2005-2010 if available?") I would recommend looking into the data available from CIHI. According to the Definitions, data sources and methods section of the StatCan website

(http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=3204?=en&db=imdb&adm=8&dis=2):

"As of the 1994/95 data year, the Canadian Institute for Health Information (CIHI) assumed the data collection and dissemination responsibilities for Mental Health Statistics. (...) The annual information presently collected by this program provides data on separation (discharges) from psychiatric hospitals and general hospitals for inpatients being treated for mental disorders." Your provincial health department and mental health-related associations may also disseminate data on these topics.

For question 3, 4 and 5, your client may wish to look into the custody-related data available in the National Longitudinal Survey of Children and Youth

(NLSCY; http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4450?=en&db=imdb&adm=8&dis=2).

We have NLSCY synthetic files in the DLI collection (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/nlscy-elnej-eng.htm) that can be used to prepare for a visit to an RDC or to request data through remote job submission (the data in these synthetic files are "synthetic/dummy" data that can't be used for analytical purposes). NLSCY data on this topic may also be available for a fee on a custom basis. If this is of interest to your client, I would be pleased to refer you to an Account-Executive in our Vancouver office who could confirm what data could be disseminated as a custom table and at what cost. You may also wish to look into what data that might be available from provincial ministries.

I hope that these suggestions are helpful. Please don't hesitate to let me know if you have any other questions.