INSTRUCTIONS FOR PESTICIDE DATA PROGRAM 1997 DATA DOWNLOAD

Notice: Due to funding constraints, only 159 (26%) of the originally 
        scheduled 600 Soybean samples were collected and analyzed. These
        data constitute a convenience sample and are not considered 
        suitable for drawing statistically reliable inferences.

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

Instructions:
1) Click on the 1997 Data link and save the 97data.exe file to your hard drive.
2) In Windows or DOS, launch the 97data.exe file to extract 23 files.  There
   will be 5 executable files and 18 text files (described below).
3) Launch each of the 5 executable (.exe) files to extract 5 ASCII
   fixed-length (.asc) data files.  Example: At the DOS prompt, type
   PDP97SAM and press the key.  The 6 (.exe) files can then be deleted.
3) Print the Data Dictionary file (DATADI97.TXT) to see file structures.
4) Create three database tables that match the provided file structures 
   using your own database software. Import the 6 (.asc) files.
5) Print the 15 PDP code reference (.txt) files.  You may want to 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:
  PDP97SAM.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP97SAM.ASC) which holds 7,835
                    Sample Information records for 1997 PDP samples.
  PDP97RE1.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP97RE1.ASC) which holds 116,597
                    Analytical Results records for the 1st Quarter (Jan-Mar).
  PDP97RE2.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP97RE2.ASC) which holds 125,553
                    Analytical Results records for the 2nd Quarter (Apr-Jun).
  PDP97RE3.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP97RE3.ASC) which holds 136,121
                    Analytical Results records for the 3rd Quarter (Jul-Sep).        
  PDP97RE4.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP97RE4.ASC) which holds 145,994
                    Analytical Results records for the 4th Quarter (Oct-Dec).
  PDP97PES.ASC  -  ASCII, fixed-length data file which holds 145 
                    Pesticide Code/Names for relational reference (join) with 
                    the Analytical Results table (link on Pest_Code). Prior
                    year datasets provided the Pesticide Name on each 
                    Analytical Result record, which resulted in data 
                    redundancy and thus excessive storage space requirements.

  DATADI97.TXT  -  Data Dictionary that provides the file structures for the
                    Sample Info data file (pdp97sam.asc), the 4 Analytical
                    Results data files (pdp97re#.asc), and the Pesticide 
                    Code/Name data file (pdp97pes.asc). This is a text
                    file that can be viewed/printed with any text editor.

   Fifteen ASCII text files that can be used to reference and interpret the
   standard codes used in the PDP data:
  ANNOT97.TXT   -  valid PDP Annotation Codes & Descriptions
  CLAIM97.TXT   -  valid PDP Marketing Claim Codes & Descriptions
  CLASS97.TXT   -  valid PDP Test Class Codes & Descriptions
  CNTRY97.TXT   -  valid PDP Country Codes & Names for 1997 Imported Samples
  COLTYP97.TXT  -  valid PDP Collection Site Type Codes & Descriptions
  COMMOD97.TXT  -  valid PDP Commodity Codes & Descriptions for 1997 Samples
  CONFME97.TXT  -  valid PDP Confirmation Method Codes & Descriptions
  CTYPE97.TXT   -  valid PDP Commodity Type Codes & Descriptions
  DETERM97.TXT  -  valid PDP Determinative Method Codes & Descriptions
  EXTRAC97.TXT  -  valid PDP Extraction Method Codes & Descriptions
  LABS97.TXT    -  valid PDP Participating Laboratory Codes & Cities
  MEAN97.TXT    -  valid PDP Mean of Result Codes & Descriptions
  PEST97.TXT    -  valid PDP Pesticide Codes & Names reported in 1997
  QUANT97.TXT   -  valid PDP Quantitative Method Codes & Descriptions
  STATE97.TXT   -  valid State Postal Codes & Names for 50 states

  READ97.ME     -  text file containing these same instructions