INSTRUCTIONS FOR PESTICIDE DATA PROGRAM 1994 DATA DOWNLOAD

** Approximately 40 MB of free disk storage space is needed to hold the
   de-compressed 1994 PDP data.

Instructions:
1) Click on the "1994 Data" link and save the 94data.exe self-extracting
   zip file to your local hard drive.
2) In Windows or DOS, launch the 94data.exe file to extract 21 files.
   There will be 5 executable files and 16 text files (described below).
3) Launch each of the 5 executable (.exe) files to extract the 5 ASCII
   fixed-length (.asc) data files.  Example: At the DOS prompt, type
   PDP96SAM and press the key.  The 6 (.exe) files can be deleted.
3) Print the Data Dictionary file (DATADI94.TXT) to see file structures.
4) Create 2 database tables using your own database software
   that match the provided files structures.  Import the 5 (.asc) files.
5) Print the 14 PDP code reference (.LST) files.  You can create database
   tables for these, remove the headings from the files, and import the
   codes/descriptions into look-up tables that can be linked to your data.

File descriptions:
  PDP94SAM.EXE  - Self-extracting executable which de-compresses to an
                   ASCII, fixed-length data file (PDP94SAM.ASC) which holds
                   7,589 Sample Information records for 1994 PDP samples.
  PDP94RE1.EXE  - Self-extracting executable which de-compresses to an
                   ASCII, fixed-length data file (PDP94RE1.ASC) which holds
                   93,978 Analytical Results records for 1st Qtr (Jan-Mar).
  PDP94RE2.EXE  - Self-extracting executable which de-compresses to an
                   ASCII, fixed-length data file (PDP94RE2.ASC) which holds
                   112,810 Analytical Results records for 2nd Qtr (Apr-Jun).
  PDP94RE3.EXE  - Self-extracting executable which de-compresses to an
                   ASCII, fixed-length data file (PDP94RE3.ASC) which holds
                   115,611 Analytical Results records for 3rd Qtr (Jul-Sep).
  PDP94RE4.EXE  - Self-extracting executable which de-compresses to an
                   ASCII, fixed-length data file (PDP94RE4.ASC) which holds
                   109,337 Analytical Results records for 4th Qtr (Oct-Dec).

  DATADI94.TXT  - Data Dictionary that provides the file layouts for the
                   Sample Info data file (pdp94sam.asc) and the 4 Analytical
                   Results data files (pdp94re#.asc).  This is a text file
                   that requires compressed (132-column) print.

   Fourteen ASCII text files that can be used to reference and interpret the
   standard codes used in the PDP data:
  ANNOT94.LST   - valid PDP Annotation Codes & Descriptions
  CLAIM94.LST   - valid PDP Marketing Claim Codes & Descriptions
  CLASS94.LST   - valid PDP Test Class Codes & Descriptions
  CNTRY94.LST   - valid PDP Country Codes & Names for 1994 Imported Samples
  COLTYP94.LST  - valid PDP Collection Site Type Codes & Descriptions
  COMMOD94.LST  - valid PDP Commodity Codes & Descriptions
  CONFME94.LST  - valid PDP Confirmation Method Codes & Descriptions
  CTYPE94.LST   - valid PDP Commodity Type Codes & Descriptions
  FDACOM94.LST  - valid PDP FDA Commodity Codes & Descriptions
  LABS94.LST    - valid PDP Participating Laboratory Codes & Cities
  MEAN94.LST    - valid PDP Mean of Result Codes & Descriptions
  PEST94.LST    - valid PDP Pesticide Codes & Names reported in 1994
  QUANT94.LST   - valid PDP Quantitative Method Codes & Descriptions
  STATE94.LST   - valid State Postal Codes & Names for 50 states

  READ94.ME     - text file containing these same instructions