Tuesday, February 28, 2017

Revised Bootstrap weights files for the CTADS 2015 PUMF

Updated bootstrap weights are now available for the Canadian Tobacco, Alcohol and Drugs Survey (CTADS) – 2015 PUMF.


As of 2015, new content, covering alcohol use as well as prescription and non-prescription drug use, was added to the Canadian Tobacco Use Monitoring Survey. Therefore, the survey is now entitled Canadian Tobacco, Alcohol and Drugs Survey (CTADS).

The overall objective of CTADS is to provide regular and reliable data on tobacco, alcohol and drug use and related issues, with the primary focus on 15- to 24-year-olds.

Definitions, data sources and methods: survey number 4440.

The Canadian Tobacco, Alcohol and Drugs Survey (CTADS) is a biennial general population survey of tobacco, alcohol and drug use among Canadians aged 15 years and older. It replaces the Canadian Tobacco Use Monitoring Survey (CTUMS), which was conducted from 1999 to 2012, and the Canadian Alcohol and Drug Use Monitoring Survey (CADUMS), which was conducted from 2008 to 2012. The CTADS merged the core tobacco content from CTUMS and the core drug and alcohol content from CADUMS, resulting in more efficient data collection and providing a tool to monitor and compare the use of multiple products and substances with addictive properties. The CTADS is conducted by Statistics Canada on behalf of Health Canada.

Understanding Canadian trends in tobacco, alcohol and drug use is vital to the effective development, implementation and evaluation of national and provincial health strategies, policies and programs.

Monday, February 27, 2017

2001 Census - Immigrants from Pakistan

I’m helping someone researching the Pakistani Christian community in Toronto. Looking at the 2001 Census PUMF Individuals, I’m able to find data for Born outside Canada: Southern Asia: Other Southern Asia. Is it possible to disaggregate that category for Pakistan, specifically?

The other variables of interest are

  • Sex
  • Immigration status
  • Religion (variable RELIGRPA)

For the Toronto CMA only.


I received the following response from subject matter: “Unfortunately, there is no way to disaggregate the variable, however, the following standard table does break Place of Birth down. It is cross referenced with Immigrant Status and Period of Immigration”:
“The PUMF would not be able to provide this information. I did take a look in CANSIM and could not find a match to their requirements, however these are not our products so they may want to contact them directly. It is possible to request a custom table via the regional office.”

Friday, February 24, 2017

Inquiry on Sexual Orientation and CCHS

I have two queries that I would like assistance with.

1. I have a student wanting to know the number of self-identified gay or lesbian people in Canada.

From what I can see, the Census doesn't ask the question. There is information about same sex couples, but nothing about individuals.

2. We have a patron who is looking for Canadian health stats on the following population:

People who:
  1. have had a lower limb amputation, also called lower extremity amputation and
  2. are 65 years of age and older and
  3. live in Edmonton, if not then the region or the province.
She's interested in finding information on prevalence or rate within this population for:
  • co-morbidity
  • mortality
  • diabetics
  • smokers
I am thinking that I may be able to find some information about this in CIHI.

Answer (1) 
This is a link Ryerson University has on its LGBTQ+ Studies Research Guide:
Answer (2) 
I received one response already form CCHS group. There is a variable that pertains to sexual orientation, but as per subject matter, it only exists on the Masterfile:

“We do ask the following question on CCHS but the answers are not available on the PUMF, only in the master file.


Do you consider yourself to be...?
1: heterosexual (sexual relations with people of the opposite sex)
2: homosexual, that is lesbian or gay (sexual relations with people of your own sex)
3: bisexual (sexual relations with people of both sexes)
8: RF
9: DK”
Answer (3) 
I received word from CIHI’s subject matter group. They had the following to say:

1. Regarding self-identified gay or lesbian people in Canada – we don’t collect this data.
2. Regarding the specific population specified in your earlier email:

We most likely have hospitalization data for this population. For instance if a patient went to the ED with a traumatic limb amputation, or had to be admitted to an acute inpatient setting for something related to the amputation (ex/ infection).

Regarding co-morbidity, mortality, diabetic, smoker rates and prevalence for the above population:

In terms of data, we are restricted to what ICD-10-CA diagnosis codes are provided on the hospitalization abstracts.

With regards to smokers, co-morbidities (inc. diabetes), I don’t think its mandatory to code all of these on the hospitalization – unless it is immediately relevant to the visit. For instance, a comorbid diagnosis of diabetes would only show up if the patient was treated for this co-morbidity during the visit. Similarly, a smoking diagnosis code would only show up if the hospitalization would also contain another diagnosis directly linked to it (ex/ could occur with COPD).

Regarding mortality – we do collect the visit/discharge disposition, and it includes things like ‘Died’ ‘DOA’ etc.

Note that although we can provide this kind of data through a custom data request, we don’t actually do rates or prevalence calculations on our end.

Postal CodeOM Conversion File Plus (PCCF+) version 6C: Revised SAS Program

Postal CodeOM Conversion File Plus (PCCF+) version 6C: Revised SAS Program
An error in the PCCF+ 6C SAS code was identified which resulted in the overwriting of 2011 Census dissemination areas (DAs) with 2006 Census DAs. This error was introduced during our process of standardizing the coding for the input data files for version 6C of PCCF+. This error does not impact the majority of dissemination areas since 92% of DAs have a one-to-one match between 2006 and 2011 censuses (Statistics Canada, Correspondence Files, Reference Guide – Census year 2011; Catalogue no. 92-156-G). For the remaining 8% of DAs, users may find their data are assigned to a decommissioned 2006 Census DA unique identifier code.

An error in the processing of the institutional routine which resulted in rural postal codes erroneously being assigned via population weighted random allocation instead of the rural post office (RPO) has been corrected in the PCCF+ SAS program.
Since the SAS input data files in PCCF+ version 6C were not affected by these errors, a new version of the full product was not created. Instead, the SAS program has been revised to correct this error. Users should replace PCCFplus_6C_revised.sas with the attached version (PCCFplus_6C_revised2.sas) in order to resolve these errors.

Please contact Health Analysis Division by e-mail (HAD-DAS@canada.ca) should you have any questions.

EFT: /MAD_PCCF_FCCP_DAM/root/2011/pccf-fccp-plus/pccf6c-fccp6c/doc/PCCFplus_6C_revised2_SAS/

Thursday, February 23, 2017

Percentage of Aboriginal social workers in Canada

I have a researcher wanting to access data related to the percentage of Social Workers in Canada who are Aboriginal (according to this report http://casw-acts.ca/en/critical-demand-social-work-canada-volume-1-final-report-2000 it is 4.6% from the 1996 census). The researcher wants to access the data to confirm this number, as well as to cite the original source in her journal article. I can’t find anything that gives me both occupation to the NOC level combined with Aboriginal identity (I’m assuming that that combination could only come from a custom tab or working with the master file?).

I received a reply from Census group indicating that the 1996 Census does not provide the information you are seeking. I have been instructed to follow up with another group. I will let you know their response to your questions.

I received a response from the group responsible for the Aboriginal Peoples Survey (APS):

"The 1991 Aboriginal Peoples Survey could be a source, as it has both NOC(SOC91: http://www23.statcan.gc.ca/imdb/p3VD.pl?Function=getVD&TVD=143375 ) and aboriginal identity.

Having said that, I was able to find the variables in the 1996 Census in e-DICT:

Occupation variable (depending on the table):
Soc91 for 1991 Standard Occupational Classification
Nochrd for 1990 National Occupational Classification

Aboriginal Identity variable: AsRr
Both sources are possible, so it would really depend what is listed in the article as the source information for the data they wish to re-create. If the client is unsure of the source, they may need to contact the author(s) of the report, as it is not a Statistics Canada publication."

Wednesday, February 22, 2017

Post-Secondary Student Information System (PSIS) International Student Data

I have a request from a faculty member regarding international students enrollment (Immigration status). The PSIS data I have found at https://dli-idd.statcan.gc.ca/wds/ReportFolders/ReportFolders.aspx?IF_ActivePath=P,17351,20239&IF_Language=eng covers the time period 1993 – 2010. Is the 2011 – 2016 data available?

The researcher would like to have data that describes the number of international students who are enrolled in ESL programs in Canada.

A breakdown by province and type of school (private vs. public) would also be desirable if available.

We would like to suggest to the client to look at “Languages Canada website or contact them for that research purposes. They have private language school as well as some public institutions offering English as a second language as well as French as a second language.

We have also found some information on the ESL programs in our PSIS User guide. Please see extract below.

English as a Second Language (ESL)/English as an Additional Language (EAL)/French as a Second Language (FSL)

Most postsecondary institutions in the country have ESL, EAL or FSL activities. However, how this information is stored within each institution varies: some may include these activities as part of another program within their student registration system, while others may store this activity separately (i.e. with a distinct Program code). Alternately, information on ESL, EAL or FSL may be in a registration system that is separate from the centralized system and the information may not be available for reporting to the Postsecondary Student Information System (PSIS) at this time.

For ESL, EAL or FSL activities that are stored separately from other educational activities and are available for reporting to PSIS, they are coded to Program type “01 – Basic education and skills programs” and coded to the Credential type that best describes the type of formal qualification awarded for successful completion of the program. Where no qualification is awarded, the program was coded to Credential type “98 – Not applicable”.

DAD files - location information

I have a researcher that is interested in the Discharge Abstract Database (DAD) files. Looking at the files on the EFT, there does not appear to be facility location information or number of beds for each facility or if the facility is located in a rural or urban area. The researcher would like access this information. It is possible to get access to this information?

I received a response from CIHI:

“In short, this kind of information is not available in the DAD-DLI files. The DAD DLI files are a heavily de-identified, randomized 10% sample of the original DAD dataset. During the de-identification process we remove any data elements that may be potentially used to re-identify patients or facilities. This would include things like facility location, number of beds, urban/rural etc.

However, we do have information on the facility location and urban/rural status in the original DAD datasets. The number of beds is also available, but this may have to be brought in via another CIHI data holding.

If the researcher is interested in obtaining this kind of data through CIHI, I would suggest they fill out a data inquiry form, here: