Friday, March 13, 2009

Survey of Household Spending

Question

I am helping an economics professor with the Survey of Household Spending and he has a question about the age of the respondent variable. He would like to know if there is any way to obtain the exact age as opposed to just an age group. I checked the questionnaire and there is indeed a question about the age so the data must be available somewhere…  As a neophyte, I would also be curious to know the rationale for providing age groups rather than the exact age figure.



Anyway, the prof in question is used to the Survey of Consumer Finance (stopped in 1998) which apparently provided the exact age. So he would like to be able to obtain the same information with the SHS. Is there a master file available from a RDC for that survey?

Answer



The author division confirmed that the exact age is available on the RDC internal file for the SHS:

"Any Research Data centre should have a copy of the Internal files for the SHS for all years, or if they don't have one should get one on request. The exact ages are on the internal file, The Pumf uses age groups for confidentiality."

They also confirmed that custom tabulations are available, provided that the sample size is sufficient and there are no confidentiality issues with the particular variables being crossed. However, the Division encourages people to use the Research Data Centres to perform their own custom tabulations, so the professor can submit a proposal to use the RDC file if he wants to avoid the cost of a custom tabulation.

CTUMS 2008 Cycle 1 and CCHS 2007

Question

Do we have a date when the PUMF for the CTUMS 2008 Cycle 1 will be released to DLI? (http://www.statcan.gc.ca/daily-quotidien/090119/dq090119b-eng.htm)




Also, could you please confirm that the CCHS 2007 is still due to be released this summer (and perhaps a more specific date)?

Answer


The PUMF for CTUMS 2008 Cycle 1 was released to the DLI some time ago, but the author division subsequently found there were problems with the bootstrap weight files so we were asked not to load it. I asked for an update just now, and was told that they are still correcting the bootstrap weight files. However, they said that we could go ahead and load all the other files for now and they will send us the bootstrap weight files separately once they are corrected. Jackie is loading the files as we speak and I will announce them as soon as they are available on the sites.

As for the CCHS 2007, the author division confirmed that "end of summer 2009" is still the anticipated release date (they cannot provide a more accurate date at this point).

Survey on Financing of Small and Medium Enterprises, 2007

Question


I know this has just been released, but any possibility of getting this or previous years through the DLI? I have an SME researcher that I know will be asking.

Answer
This is another survey for which no standard data products were released. I have asked the author division if they are willing to provide the DLI with any cross-tabulations and will keep you posted.

***
The contact for this survey explained that aggregate data is available upon request, free of charge, from the division. However, it is also being made available through Industry Canada's website. I checked their site and found the following under the "SME Financing Data Initiative" section of the site:

http://www.sme-fdi.gc.ca/eic/site/sme_fdi-prf_pme.nsf/eng/h_01570.html

Anyone can request the data (free of charge, in PDF or Excel formats) for 2000, 2001, 2004 and 2007 through this site, which also contains other information on SME Financing that may be of interest to your researcher.

Survey of Family Expenditures

*Note: Correspondence translated from the original French.

Question

We're currently working on the Survey of Family Expenditures. It doesn't look like you have the surveys for the following years: 1969, 1974, 1978, 1982, 1984, 1986, 1990, and 1992. Are we able to obtain them?

Answer

The surveys you mentioned are now available on our site. I'm going to send a bilingual announcement soon.

***
Family Expenditures Survey (FAMEX) - Questionnaires


Questionnaires for the Family Expenditures Survey are now available for 1969, 1974, 1978, 1982, 1984, 1986, 1990, 1992 and 1996.



FTP:  /dli/famex- Family expenditures survey

Dual Income Earners in a Household

Question

I have cool question from an undergraduate student this afternoon - can anyone direct me to a source that could tell me the number of dual income earners in a household before and after 1960.  The student has looked at Census - and pulling out the # of earners in a household is not as straightforward...  I'm stuck on the 1960 bit.

Any suggestions would be greatly appreciated.

Answer

I looked in the 1951 Census print publications and found one table that may be relevant.  It can be found in Volume III: Housing and Families:

Table 128.  Families by size, types, numbers of members in the labour force...1951

This table provides the number of families with either 0, 1, or 2+ members in the labour force for Canada, provinces, counties and census divisions.

There are 2 similar tables for other levels of geography:

Table 129 = incorporated cities, towns, and villages of 1,000 population and over
Table 130 = Census Metropolitan Areas

Number of Doctors in Quebec and Ontario

*Note: Correspondence translated from the original French.

Question

I'm searching for the number of doctors in Quebec and Ontario for the years 1993 to 2000. I found in "Aperçu des statistiques sur la santé 1999" data from 1977 to 1992 and 2000 to 2007 on the CIHI (Canadian Institute for Health Information) site. Does a source exist for 1993 to 2000?

Answer

1) The last of the reports should answer your question. It is in the paper version: Number, distribution and migration of the Canadian doctors - Years chosen, 1961-1995.

http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=AR_14_F

2) CIHI published numerous publications for 1993-2000, but they are not always available online. I suggest you consult the pertinent versions of the following titles (and to order printed versions via inter-library loans):

1. Médecins équivalents à temps plein, Canada : http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=AR_17_F

2. Nombre, répartition et migration des médecins canadiens : http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=AR_14_F&cw_topic=14

3. Chapitre 21 du rapport Tendances relatives au personnel de la santé au Canada, de 1995 à 2004 :
http://secure.cihi.ca/cihiweb/dispPage.jsp?cw_page=PG_399_F&cw_topic=399&cw_rel=AR_21_F

Moreover, you always have the option of ordering data from CIHI if the aforementioned publications are not enough. Also keep in mind that the Health Stats Division (here at Statcan) told me that CIHI is the best resource for the statistics that you want.

Hope this helps you.

Monday, March 9, 2009

Saskatchewan Birth Rates

*Note: Correspondence translated from the original French.

Question

I'm looking for the Saskatchewan birth rates from 2005 to 2008. I found the previous years (1994-2004) in the publication #91-213, but for the more recent years they don't give the number of births (in all the publications I consulted including Cansim and the Monthly Statistical Review of Saskatchewan). Is this data available?

Answer

I found the Saskatchewan birth rates for 2005 to 2008 on the following Statistics Canada web page:

http://www40.statcan.gc.ca/l02/cst01/demo04b-fra.htm

By default, this table presents the number of births, but they can choose birth rates from the menu on the left (under the title "Dans cette série"). Please note the figures for 2007-2008 are provisional.

Follow-up Question

Thank you! The same research asks if such data exists for different regions in the interior of the provinces (or even another province besides Quebec)?

Follow-up Answer

Sorry for the delay in answering your question. I needed to hear back from a number of Statistics Canada people to be certain.

An analyst at the demography division says the birth rates are not easily available for the other geographic provincial levels. It should be calculated with the population estimates and number of births (a personalized totalization). Nevertheless, they recommend using fertility rate totals, which is available at the CMA level for 2005 at the following publication:

http://www.statcan.gc.ca/cgi-bin/af-fdr.cgi?l=eng&loc=/pub/91-209-x/91-209-x2004000-fra.pdf



I hope this helps.