Wednesday, September 28, 2016

Revised and/or enhanced Discharge Abstract Database files for 2014-2015

With the kind cooperation of the DLI group, I have uploaded a zip file containing revised geographic and clinical files for the 2014-2015 CIHI DAD onto the DLI EFT site, into the /MAD_CIHI_ICIS_DAM/Root/discharge-abstract-database-2014-15/data/Revised folder. I hope that the community finds them useful.

About the revisions and/or enhancements to the 2014-2015 DAD files:

The revised data files have data transformed (where appropriate) from string variables (e.g., as received, age may be recorded as a string of "Under 1 year") to coded variables (restoring age to an ordinal variable). It also restores the proper CCI encoding, reinserting the punctuation which is omitted from the file received from CIHI, making it possible for the user to match the data stored in the file to the documentation.

As distributed by CIHI, there are 25 ICD10 variables for diagnoses, and 20 variables for type of intervention. In addition to those variables, the revised data file also contains 245 ICD10 and 190 CCI flag variables - these identify which records contain particular codes across any of the multiple ICD10 or CCI variables.

For example, consider the constructed variable

CCIF040 "Diagnostic Interventions on the Nervous System (2AA - 2BX)"

If any of the 20 CCI variables (I_CCI_1 through I_CCI_20) in a record contain a code that begins with the string 2AA through 2BX, that record will be flagged in variable CCIF040 as true: a "Diagnostic Intervention on the Nervous System" was reported in at least one of the 20 CCI variables.

Similarly, consider the constructed variable

ICDF127 "Reported K40-K46: Hernia"

If any of the 25 ICD10 diagnosis variables (D_I10_1 through D_I10_25) in a record contain an ICD10 code that begins with the string K40, K41, K42, K43, K44, K45, or K46, that record will be flagged in variable ICDF127 as true: a Hernia was reported in at least one of the 25 ICD10 variables.

Additionally, the revised data files contains counts of the number of diagnoses and interventions for each record on the file. This enables the user, for example, to distinguish "simple" cases (e.g., one diagnosis or intervention) from complex (however many the user defines as complex).

The zip file contains ASCII (.rev) and SPSS system file (.sav) versions of the revised data files. It also contains the two SPSS programs which are used to reformat the clinical file, and the SPSS program used to reformat the geographic file. It also contains the log files (in both ASCII text format and SPSS spv format) created from running the SPSS programs, and the frequencies of each variable (including the constructed flag and count variables). The frequencies of the 25 ICD10 diagnosis are contained in a single text file; the 20 CCI variables are contained in a second text file. The log files contain a write statement, which shows the record layout of the ASCII versions of the revised data files (hence the .rev extension).

Tuesday, September 27, 2016

DLI Nesstar search


The Nesstar search allows users to search surveys or statistical products for both public-use microdata files (PUMF) and public master files ( It also allows the search of variables(

The DLI team is pleased to announce that there have been further updates to the Nesstar search!


Use Boolean operators (AND, +, OR, NOT, -) to expand or narrow your search results.
Note: the default search is AND, and Boolean operators must be capitalized.

Try using phrase search “” (i.e. “users of SLID data”) in your query.

To expand your search results, use truncation (i.e. immigr* -> immigration, immigrated, immigrating)


We are always making improvements to the Nesstar search and welcome your feedback!

2014 Canadian Income Survey (CIS) PUMF

The anticipated release date for the 2014 Canadian Income Survey (CIS) PUMF is late-November, pending approval from the Microdata Release Committee.

Monday, September 26, 2016

HPV Vaccination Rates


I have doctoral student here who’s researching HPV vaccination rates, but stats are pretty thin on the ground. I’ve checked PHAC’s site and have found a few useful items. Searching CIHI was less productive. I’ve also contacted individual health regions in the province to see if they collect immunization stats and would be willing to share them.

My questions are two:

1. Is there an updated version of the National Immunization Coverage Survey (the most recent one I’ve found is 2013)?

2. Are there other sources of immunization data that I’ve overlooked/don’t know about?


I see that the frequency of collection for the Childhood National Immunization Coverage Survey (CNICS) is every two years. I can confirm with subject matter if there is a 2015 reference period.

I have been able to find the following reference that may be of use on the National Advisory Committee on Immunization (NACI):

Table 5. Summary of evidence (published and unpublished) related to HPV9 vaccine

Vaccine uptake in Canadian adults: Results from the 2014 adult National Immunization Coverage Survey (aNICS)

The 2014 aNICS was conducted by the Environics Research Group.

CNICS was collected in 2015. For the time being, there is no date set as for the release. It will not be before 2017.

Concordance SOC 2010 and NOC 2006


I am wondering if there is a concordance for Standard Occupational Classification (SOC) 2010 (used by the US) and National Occupational Classification (NOC) 2006?


I am consulting the Concordances between classifications page available on the Statcan Website, and unfortunately do not see one from SOC 2010 to NOC 2006.

I see:
Standard Occupational Classification (SOC)

Thursday, September 22, 2016


The Data Liberation Initiative (DLI) program has reorganized its collection holdings and undertaking a renaming of the folder names in the file path structure on the EFT. Public Use Microdata Files (PUMFs) are now available in the MAD_PUMF_FMGD_DAM folder (navigate to top hierarchy to access) and organized in a bilingual structure, based on the survey record number and survey acronyms, as follows:

New structure
A folder directory (Readme-Key_Lisezmoi-clé.xls), please see attached, identifying what the survey acronym mean, is available in the folder of the new safe.

For more information, please consult the presentation material from the webinar on the EFT restructuring available on the DLI Training Repository.

Wednesday, September 21, 2016

Tuition and Living Accommodation Costs for Full-time Students at Canadian Degree-granting Institutions (TLAC)

TLAC data for 2015- 2016 are now available on the EFT site.

The Tuition and Living Accommodation Costs for Full-time Students at Canadian Degree-granting Institutions (TLAC) survey was administered from April to July 2015 and the data cover the 2015-2016 academic year. Data are provided for the 111 institutions that represent the survey universe.

eft: /MAD_DLI_IDD_DAM/Root/other_autres/3123_TLAC_FSS/