"When I got back to the office yesterday after the Gerstein event, there was a perfect question waiting for me:
The user wanted annual smoking rates for Ontario, from about 2000 to the latest. We checked CANSIM, but each time series from the Canadian community health survey seemed to consist of only one year per series, and it would have required 'gluing' together a series of numbers from disparate CANSIM tables.
So we went to the Canadian tobacco use monitoring survey. Selecting (in
SDA) each annual person file, and doing a cross-tabulation of the smoking status question (Q10 or Q010 in most years) and province, and noting down the % of daily smokers, occasional smokers, and non-smokers.
I encourage you to try the same thing, in SDA, and in
One major difference: in SDA the resulting table is by default weighted to the population, while in Nesstar (ie