MKT 426: International Marketing
Research Guides:
Trade & Industry Codes:
Global Economic Data
|
Databases you'll use for your E/O project:
Foreign Product Market documents:
|
Business Librarian: Steve Cramer
smcramer@uncg.edu
336-256-0346
AIM & Google Talk: stevebizlib
Text me: send a message to 265010 & start the message with stevebizlib.
PC-TAS Workshop:
- Introduction to commodity codes
- Harmonized
- NAICS (industry codes)
- SIC (industry codes)
- Cross classification table
- The two types of trade data
- PC-TAS (trade data cd-rom)
- Description
- How to access it
- Movie demos
- Basic steps to create a search
1. Introduction to Commodity Codes
Introduction
- In trade data, numbering codes are used to identify commodities (i.e. raw materials or products.)
- The codes are hierarchal:
- The longer the number, the more specific the commodity (aggregated data.)
- The shorter the number, the broader category of commodities (disaggregated data.)
It's vital to have the proper commodity codes!
Take your time with this.
For details, see my Trade Data guide.
a. Harmonized System (HS)
- Also called Harmonized Tariff Code (HTC)
- Used by the U.S. government to classify U.S. imports and exports.
- These codes can be up to 10 digits long.
- Exports codes (also called Schedule B) are administered by the U.S. Census Bureau.
- Import codes are administered by the U.S. International Trade Commission (USITC).
Examples of HS codes:
61 Articles of apparel and clothing accessories, knitted or crocheted
6103 Men's or boys' suits, ensembles, suit-type jackets....knitted or crocheted
610319 Of other textile materials
61031920 Of cotton
6103192010 Jackets imported as parts of suits
b. North American Industrial Classification System (NAICS)
- NAICS replaced SIC in 1992.
- (However, some databases still use SIC.)
- NAICS is more detailed than SIC, and does a much better job of covering service and technology industries.
- It was created by the U.S., Canadian, and Mexican governments.
- Use a company directory to find a company's codes.
Examples of NAICS codes:
51 Information
513 Broadcasting and Telecommunications
5133 Telecommunications
51332 Wireless Telecommunications Carriers (except Satellite)
513322 Cell phones and cell phone service
c. Standard Industrial Classification (SIC)
- Until 1987, the U.S. Census Bureau used SIC codes to classify business activities.
- However, some publishers (ex. Duns) still use it.
- NAICS (see below) is the successor to SIC codes.
- Use a company directory to find a company's codes.
Examples of SIC codes:
23 Apparel made from fabrics and similar materials
232 Men's and boys' furnishings, work clothing, and allied garments
2325 Men's and boy's separate trousers and slacks
d. Cross-Classification Table
- After you have found a 10-digit HS code, use this table to find the corresponding SIC and SITC codes.
- This kind of table is also called an industry concordance.
2. The Two Types of Trade Data
Summary Global Trade (country to world)
The total exports of a commodity from one country to the rest of the world, OR total imports of a commodity from the rest of the world to one country.
Examples:
- how much cotton the U.S. exports to all other countries.
- how much crude oil the U.S. imports from all other countries.
United States Exports 2003-2008 |
| Product: HS 52 - COTTON; in US$ '000 |
| Reporter |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
| USA,PR,USVI |
2,798,533 |
2,765,349 |
2,615,981 |
1,040,959 |
1,947,245 |
2,217,379 |
Bilateral Global Trade (country to country)
Trade between two countries (sometimes called trading partners), or between one country and a country group.
Examples:
HTS - 52: COTTON, INCLUDING YARNS AND WOVEN FABRICS THEREOF
FAS Value by HTS Number and FAS Value, For Mexico,
U.S. Total Exports |
| HTS Number |
Country |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
Percent Change
2006 - 2007 |
| In 1,000 Dollars |
| 52 |
Mexico |
466,715 |
598,627 |
937,510 |
991,839 |
1,453,447 |
1,226,894 |
-15.6% |
3. How to Use PC-TAS CD-ROM
This is for your split-share analysis.
a. Description
- Provides summary and bilateral global trade data, covering over 125 countries.
- Supports up to 6-digit HS codes.
- Covers 2003-2007.
- Data can be exported into a spreadsheet and presented as graphs.
- The data is from the COMTRADE database of the United Nations Statistics Division.
- Detailed user's guide
b. How to access PC-TAS
PC-TAS (United Nations Trade Analysis System - Personal Computer) is a networked CD available in ITS computer labs (including the Super Lab and the Bryan labs).
- Open "All Programs"
- Open "TAS Personal"
- Select "PC-TAS HS
c. Movie demos 
- Searching for your summary global trade data (523K)
- Searching for your bilateral trade data (526K)
d. Basic steps to to create a search
-
From the View menu, choose Screening.
-
Click the button labeled Product.
-
In the box labeled Codes beginning with, type the HS code.
-
Click the List button (in the upper-right area of the window).
-
Click on the product code to select it.
-
Click the button labeled Copy (in the middle of the window).
-
Click the button labeled Done (in the lower-right area of the window).
-
Click the button labeled Reporter (in the upper-left area of the window).
-
Select the country(s) or country group(s) you need. CTRL-click to select more than one.
-
Click the button labeled Done
-
Click the button labeled Partner Country (in the upper-left area of the window).
-
Select the country(s) or country group(s) you need. CTRL-click to select more than one.
-
Click the button labeled Done
- Choose "Import" or "Export".
-
Click the button labeled Run (in the upper-right area of the window) to display the data
-
To export the data into Excel, select the View menu, and then Export.
-
To display graphs of the data, select the View menu, and then Graph.
