The World Trade Analyzer (WTA) is a trade database that allows you to access data for 600 commodity groups for 192 countries for up to 18 years (1985-2002). It is created from data reported by member countries to the United Nations Statistical Office, later compiled by Statistics Canada.
Data Organization: Data is arranged using the Standard International Trade Classification (SITC), Revision 2, at up to 4-digit level of detail. You are strongly urged to determine a code number for your commodity before beginning to collect the data. See our information on choosing a commodity and on coding systems. You can browse the books cited or, from the initial "Top Screen" of WTA, you can click the "Commodity Information" button and browse the SITC hierarchy. You can also toggle over to this commodity outline from the Table view at any time by clicking "Commodity" at the top of the window.
Help Guides: Besides this web page (detailed example given below), you can look at the following short Quick-Start help guides in Adobe Acrobat (.pdf) format, which use examples to show how to specify your data and get output.
There is also a more comprehensive manual in Adobe Acrobat format.
Determine the top 15 exporters of a commodity in 1998. Manipulate the display, then modify your criteria.
Before beginning, determine the SITC rev. 2 code for a commodity as discussed above under "Organization." We will use 791, for railroad equipment.
From the desktop, open the icon that says "CD Network" or "CD Tower" if the menu is not already open. Open the World Trade Analyzer folder and then the WTA program.
At the opening menu, click the "Table View" button to build a spreadsheet of data or click on "Commodity Information" to browse SITC codes. From the Commodity window, you can click "Table" at the top to toggle over to the Table View. The program does not transfer an SITC code from the Commodity window to the Table window; the Commodity Information is just there for reference purposes.
Ignore the spreadsheet that comes up when you open the program. This will just reflect the latest WTA specifications used on the particular computer that you're using. (If you find it distracting, you can click "Reset" at the top to clear the old search.) Click the Selector Button in the upper left corner to get the Selector dialog box. The Selector is the key to specifying criteria for your data.
How it works: This is where you specify values for each of the five dimensions (Measure, Year, SITC, Exporter, Importer). The "selection values" section in the middle of the Selector dialog box shows what values are currently selected. You highlight a dimension on the left, then click on various icons at the top of the dialog box to change that dimension's values to what you want.
The following examples will illustrate how to create various spreadsheets in WTA.
Finally, click "OK" in the Selector dialog to return to the Table View. The display (below), however, will need some manipulation for the data to be meaningful.
The key to the display is moving the 5 dimensions among the 3 segments at the top denoted by the purple corner icon (out-of-the-way dimensions), the blue row labels icon, and the green column headings icon. You can use Windows drag-and-drop techniques for this.
Note: It's best to get dimensions with many values (a string of years or a list of countries) into the blue row or green column sections, and reserve the purple section for single-value dimensions or dimensions for which you only need to see one value at a time.
Below shows the results of dragging Exporter to the blue row section and dragging Year and SITC to the purple section. In the purple section, if a dimension has more than two values, use the drop-down arrow to choose which to display.
Important Definitions: For a given cell in a data table (see above), just substitute the name of the importing market for "given importer" in the definitions below (the World, in the above example) and the name of the exporting market for "given exporter" (each country listed along the left, in the above example).
"World Export Share": Percent of the given importer's total imports coming from the given exporter.
"World Import Share": Percent of the given exporter's total exports going to the given importer.
"Value Change": Calculates change to the indicated year from the immediately preceding year (which isn't necessarily the previously listed, or visible, year).
Use the Selector dialog (you can also double-click on a dimension tile in the purple, blue, or green sections) to select all years (best to use the "List" option), drag Exporter to purple and Year to the blue column section. Use the drop down arrow to choose Canada as Exporter and click OK back to the Table View. See result below.
First, open the Selector dialog and choose only 1998 for the year. This is so we can rank importers of Canadian railroad equipment according to trade in the most recent year for which we have data. [You're supposed to be able to select which year you want the ranking to reflect from within the Select Top/Bottom dialog, but this feature doesn't work, at least over the network.]
Next select Importers using the TopBot dialog (below). Change "the top" to 10 and "at level(s)" to Country. Check the summary at the bottom.
Finally, change years selected again using the list dialog (below). Highlight and use the buttons as needed to choose every fifth year from 1998 and going back.
The program does not recalculate the ranking of trade partners for the earlier date; it continues to use the same set of countries that it found when you used the Top/Bottom dialog with 1998 chosen, until you were to re-select Importers.
In the resulting Table View, drag Importer to the blue row section, Year to the green column section, and Measure to the purple section.
Printing is awkward in WTA. It is recommended that you export your data to a spreadsheet, then use the capabilities of a spreadsheet program to analyze the data, produce graphs, etc.
If the data on the screen is wider than what will fit on a normal sheet of paper, choose the Landscape orientation from the "Layout" dialog (left).
You should leave "Render Style" at Report or else the printout will include all the marginalia in the window around the actual spreadsheet data (menu headings, dimension tiles, etc.).
Use the Export Menu at the top of the Table View to export the data on the current view. Any of the three File Formats open in most spreadsheet programs. You can label a header and footer and name your file.
You should bring a floppy diskette and save your file to the a: drive (below).
Unless otherwise specified on this page, this work is licensed under a
Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.