/*
 *  Survey:           NHANES II
 *  Years:            1976-1980
 *  Questionnaire:    Nutrient Composition
 *  Tape Number:      5703
 *
 *  Code Created By:  CDC/IMB
 *
 *  DESCRIPTION:  This file is provided as a starting point to perform advanced 
 *  statistical queries on the survey data.  They are to be used in conjunction 
 *  with legacy codebooks or data tape documentation to analyze the data.  In order 
 *  to use this program: either copy the tape file to your C:\temp directory, or change 
 *  the infile to point to the location that your tape file is located.
*/

PROC FORMAT;

VALUE NCDNF
     9999999='unknown'
     ;
RUN;

DATA D_5703;
   INFILE 'c:\temp\DU5703.txt' LRECL = 2000 MISSOVER;
      LENGTH
         N2NC0001 8
         N2NC0005 4
         N2NC0007 8
         N2NC0012 8
         N2NC0019 8
         N2NC0026 8
         N2NC0033 8
         N2NC0040 8
         N2NC0047 8
         N2NC0054 8
         N2NC0061 8
         N2NC0068 8
         N2NC0075 8
         N2NC0082 8
         N2NC0089 8
         N2NC0096 8
         N2NC0103 8
         N2NC0110 8
         N2NC0117 8
         N2NC0124 8
         N2NC0131 8
         N2NC0138 $13
      ;
FORMAT
         N2NC0012 NCDNF.
         N2NC0014 NCDNF.
         N2NC0019 NCDNF.
         N2NC0026 NCDNF.
         N2NC0033 NCDNF.
         N2NC0040 NCDNF.
         N2NC0047 NCDNF.
         N2NC0054 NCDNF.
         N2NC0061 NCDNF.
         N2NC0068 NCDNF.
         N2NC0075 NCDNF.
         N2NC0082 NCDNF.
         N2NC0089 NCDNF.
         N2NC0096 NCDNF.
         N2NC0103 NCDNF.
         N2NC0110 NCDNF.
         N2NC0117 NCDNF.
         N2NC0124 NCDNF.
         N2NC0131 NCDNF.
;
      INPUT
         N2NC0001 1-4
         N2NC0005 5-6
         N2NC0007 7-11
         N2NC0012 12-18
         N2NC0019 19-25
         N2NC0026 26-32
         N2NC0033 33-39
         N2NC0040 40-46
         N2NC0047 47-53
         N2NC0054 54-60
         N2NC0061 61-67
         N2NC0068 68-74
         N2NC0075 75-81
         N2NC0082 82-88
         N2NC0089 89-95
         N2NC0096 96-102
         N2NC0103 103-109
         N2NC0110 110-116
         N2NC0117 117-123
         N2NC0124 124-130
         N2NC0131 131-137
         N2NC0138 138-150
      ;

      LABEL
         N2NC0001 = "CATALOG NUMBER: 5703"
         N2NC0005 = "FOOD GROUP"
         N2NC0007 = "FOOD CODES"
         N2NC0012 = "CALORIES"
         N2NC0019 = "PROTEIN (GRAMS)"
         N2NC0026 = "FAT (GRAMS)"
         N2NC0033 = "TOTAL CARBOHYDRATES (GRAMS)"
         N2NC0040 = "CALCIUM (MILLIGRAMS)"
         N2NC0047 = "PHOSPHORUS (MILLIGRAMS"
         N2NC0054 = "IRON (MILLIGRAMS)"
         N2NC0061 = "SODIUM (MILLIGRAMS)"
         N2NC0068 = "POTASSIUM (MILLIGRAMS)"
         N2NC0075 = "VITAMIN A (MILLIGRAMS)"
         N2NC0082 = "THIAMINE (MILLIGRAMS)"
         N2NC0089 = "RIBOFLAVIN (MILLIGRAMS)"
         N2NC0096 = "PREFORMED NIACIN (MILLIGRAMS)"
         N2NC0103 = "VITAMIN C (MILLIGRAMS)"
         N2NC0110 = "TOTAL SATURATED FATTY ACIDS (GRAMS)"
         N2NC0117 = "OLEIC ACID (GRAMS)"
         N2NC0124 = "LINOLEIC ACID (GRAMS)"
         N2NC0131 = "CHOLESTEROL (MILLIGRAMS)"
         N2NC0138 = "BLANK"
      ;
RUN;