INSTRUCTIONS FOR PESTICIDE DATA PROGRAM 1998 DATA DOWNLOAD

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

Instructions:
1) Click on the 1998 Data link and save the 98data.exe file to your hard drive.
2) In Windows or DOS, launch the 98data.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
   PDP98SAM and press the key.  The 6 (.exe) files can then be deleted.
3) Print the Data Dictionary file (DATADI98.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:
  PDP98SAM.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP98SAM.ASC) which holds 8,500
                    Sample Information records for 1998 PDP samples.
  PDP98RE1.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP98RE1.ASC) which holds 168,534
                    Analytical Results records for the 1st Quarter (Jan-Mar).
  PDP98RE2.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP98RE2.ASC) which holds 174,787
                    Analytical Results records for the 2nd Quarter (Apr-Jun).
  PDP98RE3.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP98RE3.ASC) which holds 177,226
                    Analytical Results records for the 3rd Quarter (Jul-Sep).        
  PDP98RE4.EXE  -  Self-extracting executable which de-compresses to an ASCII,
                    fixed-length data file (PDP98RE4.ASC) which holds 158,812
                    Analytical Results records for the 4th Quarter (Oct-Dec).
  PDP98PES.ASC  -  ASCII, fixed-length data file which holds 170 
                    Pesticide Code/Names for relational reference (join) with 
                    the Analytical Results table (link on Pest_Code). Datasets
                    prior to 1997 provided the Pesticide Name on each 
                    Analytical Result record, which resulted in data 
                    redundancy and thus excessive storage space requirements.

  DATADI98.TXT  -  Data Dictionary that provides the file structures for the
                    Sample Info data file (pdp98sam.asc), the 4 Analytical
                    Results data files (pdp98re#.asc), and the Pesticide 
                    Code/Name data file (pdp98pes.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:
  ANNOT98.TXT   -  valid PDP Annotation Codes & Descriptions
  CLAIM98.TXT   -  valid PDP Marketing Claim Codes & Descriptions
  CLASS98.TXT   -  valid PDP Test Class Codes & Descriptions
  CNTRY98.TXT   -  valid PDP Country Codes & Names for 1998 Imported Samples
  COLTYP98.TXT  -  valid PDP Collection Site Type Codes & Descriptions
  COMMOD98.TXT  -  valid PDP Commodity Codes & Descriptions for 1998 Samples
  CONFME98.TXT  -  valid PDP Confirmation Method Codes & Descriptions
  CTYPE98.TXT   -  valid PDP Commodity Type Codes & Descriptions
  DETERM98.TXT  -  valid PDP Determinative Method Codes & Descriptions
  EXTRAC98.TXT  -  valid PDP Extraction Method Codes & Descriptions
  LABS98.TXT    -  valid PDP Participating Laboratory Codes & Cities
  MEAN98.TXT    -  valid PDP Mean of Result Codes & Descriptions
  PEST98.TXT    -  valid PDP Pesticide Codes & Names reported in 1998
  QUANT98.TXT   -  valid PDP Quantitative Method Codes & Descriptions
  STATE98.TXT   -  valid State Postal Codes & Names for 50 states

  READ98.ME     -  text file containing these same instructions