Check Yourself — Lesson 5

Answers to Exercise 5

1. Find heating and air conditioning contractors located in New Jersey with a sales greater than $100,000.
   
   Hint: Use PC=171104; you may want to check out the bluesheet for prefixes for STATE and SALES.
   
   Use ONTAP Duns Market Identifiers File 276.
   
   
   b 276
   s pc=171104
   s s1 and st=nj and sa>100000
   t s2/full
   
   
   
   
2. In terms of dollars, what was the export of corn and/or wheat from the U.S. to Mexico?
   
   Hint: The product code for grain is 011.
   
   Use ONTAP Gale Group PROMT®, File 216.
   
   
   b 216
   s pc=011 and ec=64?
   
   Note: EC denotes event code; 64 is the event code for foreign trade
   Note: Adding truncation to the product code retrieves all narrower categories.
   
   s s1 and mexic?
   t s2/full
   

Close this window when you're done and return to the lesson.

Print page