Friday, February 9, 2018

KLEMS

Question:
The KLEMS data is pretty historic now.  Will the database ever be updated?

Answer:
Subject matter directed me to the following CANSIM tables with the message “KLEMS is now available in CANSIM:

http://www5.statcan.gc.ca/cansim/a26?lang=eng&id=3830032&p2=33
http://www5.statcan.gc.ca/cansim/a26?lang=eng&id=3830021&p2=33

Thursday, February 8, 2018

Missing Values in NHS Individuals PUMF


Question:
For the WAGES variable in the NHS individuals PUMF, why are "not available" and "not applicable" not declared as missing values? The codebook states that:

"The value 8,888,888 stands for not available. The value 9,999,999 stands for not applicable and is applied to all persons aged less than 15 years"

Leaving those values (which constitute over 17% of the cases) subject to calculation would seem to skew the results rather significantly, would they not?


Answer:
B Estimation
Note: Users must refrain from publishing unweighted estimates and from conducting analyses based on unweighted data from the file because the unweighted results do not represent the population but
only describe the sample. They must also make sure to exclude values of study variables that are not applicable or not available from their calculations because those values might be considered as valid observed values by the statistical software when they are not. For example, values such as 9,999,999 or 8,888,888 for a numeric (or quantitative) variable would be interpreted as valid observed values but should be considered as nominal values indicating these values are not usable in estimation.

Example 4:

We want to estimate the average total income of women aged 15 years and over living in Ontario who
have an income. In the calculation of the numerator, WEIGHT is multiplied by the value of the 'total income' variable for individuals with an income (where TOTINC ^= 8,888,888, TOTINC ^= 9,999,999, TOTINC ^= 0) whose gender is female (SEX = 1) and who are aged 15 or over (AGEGRP ≥ 6, AGEGRP ^= 88) in the province of Ontario (PR = 35); the results are then totalled. To estimate the average, the numerator (or estimated total income) is divided by the sum of WEIGHT for individuals satisfying the same conditions on TOTINC, SEX, AGEGRP and PR.
The result obtained is: $179,154,359,345 / 5,072,260 = $35,320, which means the average total income of women aged 15 and over living in Ontario who have an income is around $35,320.
B.2.b.3 Estimator of a ratio
A ratio can be defined as the division of two amounts, which could be two totals or two averages

Example these counts are included
8888 Not available (unweighted) 13,676 - (Weighted) 483,013
9999 Not applicable Canadian citizens by birth and non-permanent residents (unweighted) 697,600 – (Weighted) 26,060,226

PUMF for Survey on Disability 2017

Question:
A researcher has asked when (or if) there will be a public use microdata file for this product (http://www23.statcan.gc.ca/imdb/p2SV.pl?Function=getSurvey&SDDS=3251).


Answer:
CSD will not be getting any PUMFs in the future – The reason is due to the fact that the majority of the variables would need to be suppressed and/or aggregated for confidentiality reasons and would not be of analytical value. The geography would likely have to be at the highest level (Canada).

Wednesday, February 7, 2018

Number of Employees


Question:
I have a student who is interested in # of employees (full time, part time or self-employed) for: City of North Vancouver, District of North Vancouver, District of West Vancouver and the Arbutus/UBC corridor in the smallest possible geography. He's not interested in category of employee or employer characteristics--just the number of employees.

He would like the data in a format that could easily be exported in ArGIS or QGIS.

Answer:

The 2016 Census offers “Number of employment income recipients”, that is the total number of people who received employment income during the year. It does not break them out by full, part-time, self employed. But using Vancouver CMA Census tracts seems like it might meet your requirement. You should be able to identify the Census Tracts you need for Arbutus and West.

Follow-Up Answer:

This is a custom table request that has to be assessed by the nearest regional office. I am not sure of this the Arbutus/UBC corridor as a geography or a format that exports to ArGIS or QGIS.

They can download Canada, provinces, territories, census divisions, census subdivisions and dissemination areas (British Columbia only) from the Census profile page

or

Census Profile, 2016 Census
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/prof/search-recherche/results-resultats.cfm?Lang=E&TABID=1&G=1&Geo1=&Code1=&Geo2=&Code2=&SearchText=Vancouver&SearchType=Begins&wb-srch-place=search

This table has the variable Class of Worker (Employee –Self employed).
http://www12.statcan.gc.ca/census-recensement/2016/dp-pd/dt-td/Rp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=110647&PRID=10&PTYPE=109445&S=0&SHOWALL=0&SUB=0&Temporal=2017&THEME=124&VID=0&VNAMEE=&VNAMEF=

Friday, February 2, 2018

Local Government Expenditure Data

Question:

A student here is working on a project related to charitable giving using Canadian data, and interested in government tax expenditures on education, environment, social service, health, recreation and culture at the local level with particular year of 2004, 2007, 2010, and 2013. She's found CANSIM table 3850001 (1989-2009) and 3850041 (2008-present), but the two tables use different accounting methods to calculate the figures, and therefore can't be joined.

Are definitions of what is included under education, environment, social service, health, recreation and culture available?

Is there any chance of getting the data calculated on a consistent basis for all the years in question? Assuming there is, is it available at some sub-annual frequency?

Another problem is that provincial and local data are always consolidated; any chance of getting the data only for local governments?

Another question re: local government: does it always include aboriginal governments, or not?

Answer:

Are definitions of what is included under education, environment, social service, health, recreation and culture available?
For table 385-0001, references can be found under the archived Financial Management System documentation (http://www5.statcan.gc.ca/olc-cel/olc.action?objId=68F0023X&ObjType=2&lang=en&limit=0) 
For table 385-0041, PSSD does not currently have a list of the definitions your client is looking for. She may be able to find the definitions she is looking for in the 2014 GFS Manual found here: https://www.imf.org/external/Pubs/FT/GFS/Manual/2014/gfsfinal.pdf

Is there any chance of getting the data calculated on a consistent basis for all the years in question? Assuming there is, is it available at some sub-annual frequency?
As your client pointed out, the CANSIM tables that she was looking at use two different accounting methods. The FMS was founded on a modified-cash based system of accounting (eg., CANSIM Table 385-0001). Statistics Canada has moved from a modified-cash based accounting system to an internationally accepted accrual accounting framework for government finance statistics (eg., CANSIM Table 385-0041). For this reason, FMS data is not comparable to GFS data, therefore CANSIM Table 385-0001 is not directly comparable to CANSIM Table 385-0041.               

Another problem is that provincial and local data are always consolidated; any chance of getting the data only for local governments?
Your client can refer to CANSIM Table 385-0037 for local government data that is not consolidated.

Another question re: local government: does it always include aboriginal governments, or not?
Local government does not always include aboriginal governments.