Thursday, October 6, 2005

Data on Advanced Voting

Question

I am interesting in getting my hands on a dataset which summarizes advance and regular voting by candidate and riding in the 2000 and/or 2004 elections. I realize these data are available for the above elections aggregated at the provincial level, and disaggregated at the riding level by poll. However, I am interested in a set which would have the results by riding with some indication of the amount of advance voting for each candidate.

Answer

My guess is you would have to contact Elections Canada for that - they do provide the number of advance polls in some of their standard tables (in 2004 election results, tables 1 and 5), but only at the province level: http://www.elections.ca

Update on SAAD Files

Question

Any chance of an update to the SAAD files, especially 13c0016: Families? The latest data available under DLI seem to be to 2000.

Answer

I am pleased to announce that our FTP site was just updated with 2003 SAAD tables. There remains some gaps in the collection, but the author division is working at filling in those gaps through time.

Wholesale Prices

Question

There is a class of students doing business plans here, and one of them is looking at making energy drinks using 100% fruit juice as one of the ingredients. What he would like to find is the price that he would have to pay for fruit juice. This would be the wholesale price, not the retail price. I was able to find retail price in CANSIM Table 326-0012. But, so far, I have not been able to dig up wholesale prices. Does anyone have any ideas?

Answer
You can get futures prices of commodities (such as orange juice) via Thomson Financial's Datastream database.

I would also look at the US Dept of Agriculture's AMS page of Wholesale Terminal prices here:
http://www.ams.usda.gov/fv/mncs/terminal.htm

There are links for fruits and tropical fruits.

Also: You can find wholesale to retail prices of many types of food on Agriculture Canada's website in a database at
http://infohort.agr.gc.ca/index.cfm?action=dspWklyWhlsl&lang=eng

This database allows you to select the year, month, and day, as well as type of commodity, and location of market.

It then gives you an output, and allows you to export the data as a .csv file

DLI Updates

Just a quick note to let you know that the DLI just released a new DLI Update (Volume 8, issue 1). You can retrieve the DLI Update from the following web address: http://www.statcan.ca/english/Dli/update.htm

Publication highlights:
DLI is Coming Out of Its Shell by Chuck Humphrey (University of Alberta)
STC Mainframe Computer by Mike Sivyer (Data Liberation Initiative)
The DLI Training Repository by Jane Fry (Carleton University)
The Licensing Portal by Monia Bergeron (Data Liberation Initiative)
Data Gaps in the DLI Collection by Mike Sivyer (Data Liberation Initiative)
Difference between DLI's FTP and Web Sites by Jackie Godfrey (Data Liberation Initiative)
Additions to the DLI Collection from July 2004 - 2005 by Monia Bergeron (Data Liberation Initiative)

---------------------------------
Canadian Business Patterns June 2005

FTP: /dli/cbp/2005/cbp2005-june.zip

WEB: http://www.statcan.ca/english/Dli/Data/Ftp/cbp.htm

New Version of Beyond 20/20

Question

Is the Version 7.0 of the Beyond 20/20 Browser available?

Answer

CD-ROM products started using version 7.0 at the beginning of this calendar year. I am not sure of the exact number of products, but possibly 3 or 4 so far.

Version 7.0 of Beyond 20/20 is now available on the FTP site at the following address: /ftp/dli/util/b2020-70.exe

Installing Beyond 20/20

Question

I have been trying to get Beyond 20/20 installed on computers at the University -- particularly in the computer labs. I was able to get our systems people to do this in the past, but now they seem to have an issue with this. I received the following response as a result of a recent request:

"The Beyond 20/20 browser does not obey group policy, it cannot be installed on ADM machines. If there is a new version of the application available please let me know and I can test that to see if they have fixed the application. The easiest way to fix the problem would be to use standard Windows Open dialog boxes."

Has anyone experienced this at their institution? Does anyone know if the problem this systems person is describing is being addressed? I would very much like students to be able to open and work with IVT files at any computer in the university, particularly those in the labs.

Answer

2005: As far as I know there are no restrictions to the number of desktops that can have the Browser installed within the DLI community.

From the Past: Several years ago I requested the installation of the B2020 browser in our campus computing labs to increase access to the 1996 Census tables (like i said, the request was several years ago.) The Computing Centre would not install the browser until they had a license confirming that the copy they were installing was legitimate. Lynda Richardson, who was the DLI Liaison at the time, provided me with a document stating that the U of A was licensed through DLI to installed B2020 on our
campus.

I'm passing along this "old" news in the event that your computing centre raises the same concern. The DLI Unit will provide you with a document that you can give the software license administrator on your campus.

National Survey of Giving, Volunteering

Question

I'm writing about the 1997 Survey of Giving, Volunteering and Participation. A student here raises a question about the variable AGEGRP, which has a frequency distribution as follows, from the User Guide:

Variable: AGEGRP Position: 518 Length: 1
Public microdata variable. Respondent Age
FREQ WTD
1 15-24 years 2,389 3,980,297
2 25-34 years 3,636 4,625,964
3 35-44 years 4,280 5,123,614
4 45-54 years 2,883 3,979,917
5 55-64 years 2,109 2,580,451
6 65 years and over 3,004 3,517,908
======= ==========
18,301 23,808,151

In the SPSS command code provided on the DLI FTP site, this variable is assigned a missing value for "6". So, in the converted SPSS System file we have 6 coded as 'missing', but the frequency 'missing' matches those "65 years and over" in the User Guide. Since our student is particularly interested in those 65 and over, this is a problem.

Is the AGEGRP value "6" incorrectly assigned as missing in the SPSS command code?

Answer

Just spoke with the DLI Team, and he confirmed that you are correct in your assumption - AGEGRP value -- incorrectly assigned as missing in the SPSS command code.

If you wish to go ahead and adjust the SPSS code to make use of the data immediately, please go ahead. We will work on fixing the SPSS code and reloading it on the sites.