FILENAME SNS2 'D:\SNS\DAT\SNSIFF2.DAT' LRECL=569; **** LRECL includes 2 positions for CRLF, assuming use of PC SAS ; DATA WORK; INFILE SNS2 MISSOVER; LENGTH SEQN 7 SU2STAT 3 SU2IID 3 SU2MN 3 SU2FN 3 SU2CN 3 SU2MNC 3 SU2MPC 3 SU2MTOE $5 SU2REC 3 SU2VIF 3 SU2CFF 3 SU2TCC 3 SU2FCODE $7 SU2FID 3 SU2COMM 3 SU2PPDC 3 SU2CAUF 3 SU2IGW 8 SU2IALCO 8 SU2ICALC 8 SU2ICARB 8 SU2ICARO 8 SU2ICHOL 8 SU2ICOPP 8 SU2IFIBE 8 SU2IFOLA 8 SU2IIRON 8 SU2IKCAL 8 SU2IMAGN 8 SU2IMFAT 8 SU2INIAC 8 SU2IPFAT 8 SU2IPHOS 8 SU2IPOTA 8 SU2IPROT 8 SU2ISFAT 8 SU2ISODI 8 SU2ITFAT 8 SU2IVAIU 8 SU2IVARE 8 SU2IVB1 8 SU2IVB2 8 SU2IVB6 8 SU2IVB12 8 SU2IVC 8 SU2IVE 8 SU2IWATE 8 SU2IZINC 8 SN2IGW 8 SN2IWATE 8 SN2IKCAL 8 SN2IPROT 8 SN2ITFAT 8 SN2ISFAT 8 SN2IMFAT 8 SN2IPFAT 8 SN2ICHOL 8 SN2ICARB 8 SN2IFIBE 8 SN2IALCO 8 SN2IVAIU 8 SN2IRETI 8 SN2IBCAR 8 SN2IVE 8 SN2IVC 8 SN2IVB1 8 SN2IVB2 8 SN2INIAC 8 SN2IVB6 8 SN2IFOLA 8 SN2IVB12 8 SN2ICALC 8 SN2IPHOS 8 SN2IMAGN 8 SN2IIRON 8 SN2IZINC 8 SN2ICOPP 8 SN2ISODI 8 SN2IPOTA 8 SN2ICFIB 8 SN2IASH 8 SN2ICAFE 8 SN2ISELE 8 SN2IPACI 8 SN2IATOC 8 SN2IBTOC 8 SN2IGTOC 8 SN2IDTOC 8 SN2IVD 8 SN2IS040 8 SN2IS060 8 SN2IS080 8 SN2IS100 8 SN2IS120 8 SN2IS140 8 SN2IS160 8 SN2IS170 8 SN2IS180 8 SN2IS200 8 SN2IS220 8 SN2IM141 8 SN2IM161 8 SN2IM181 8 SN2IM201 8 SN2IM221 8 SN2IP182 8 SN2IP183 8 SN2IP184 8 SN2IP204 8 SN2IP205 8 SN2IP225 8 SN2IP226 8 SN2IGLUC 8 SN2IFRUC 8 SN2IGALA 8 SN2ISUCR 8 SN2ILACT 8 SN2IMALT 8 SN2IIFIB 8 SN2ISFIB 8 SN2IPECT 8 SN2ISTAR 8 SN2IASPR 8 SN2ITRYP 8 SN2ITHRE 8 SN2IISOL 8 SN2ILEUC 8 SN2ILYSI 8 SN2IMETH 8 SN2ICYST 8 SN2IPHAL 8 SN2ITYRO 8 SN2IVALI 8 SN2IARGI 8 SN2IHIST 8 SN2IALAN 8 SN2IASPA 8 SN2IGLUT 8 SN2IGLYC 8 SN2IPROL 8 SN2ISERI 8 SN2ISACC 8 SN2IAPRO 8 SN2IVPRO 8 SN2IOXAA 8 SN2IPHYA 8 ; FORMAT SU2STAT 1. SU2MN Z2. SU2FN Z2. SU2CN Z2. SU2FID Z5. SU2COMM Z5. ; INPUT SEQN 1-5 SU2STAT 6 SU2IID 7-8 SU2MN 9-10 SU2FN 11-12 SU2CN 13-14 SU2MNC 15-16 SU2MPC 17-18 SU2MTOE 19-23 SU2REC 24 SU2VIF 25 SU2CFF 26 SU2TCC 27-28 SU2FCODE 29-35 SU2FID 36-39 SU2COMM 40-44 SU2PPDC 45-47 SU2CAUF 48 SU2IGW 49-52 SU2IALCO 53-55 SU2ICALC 56-59 SU2ICARB 60-64 SU2ICARO 65-68 SU2ICHOL 69-72 SU2ICOPP 73-76 SU2IFIBE 77-80 SU2IFOLA 81-84 SU2IIRON 85-88 SU2IKCAL 89-92 SU2IMAGN 93-96 SU2IMFAT 97-101 SU2INIAC 102-105 SU2IPFAT 106-110 SU2IPHOS 111-114 SU2IPOTA 115-118 SU2IPROT 119-123 SU2ISFAT 124-128 SU2ISODI 129-132 SU2ITFAT 133-137 SU2IVAIU 138-142 SU2IVARE 143-147 SU2IVB1 148-151 SU2IVB2 152-155 SU2IVB6 156-159 SU2IVB12 160-165 SU2IVC 166-169 SU2IVE 170-173 SU2IWATE 174-177 SU2IZINC 178-182 SN2IGW 183-186 SN2IWATE 187-190 SN2IKCAL 191-194 SN2IPROT 195-199 SN2ITFAT 200-204 SN2ISFAT 205-209 SN2IMFAT 210-214 SN2IPFAT 215-218 SN2ICHOL 219-222 SN2ICARB 223-227 SN2IFIBE 228-231 SN2IALCO 232-234 SN2IVAIU 235-239 SN2IRETI 240-244 SN2IBCAR 245-249 SN2IVE 250-253 SN2IVC 254-257 SN2IVB1 258-261 SN2IVB2 262-266 SN2INIAC 267-270 SN2IVB6 271-274 SN2IFOLA 275-278 SN2IVB12 279-284 SN2ICALC 285-288 SN2IPHOS 289-292 SN2IMAGN 293-296 SN2IIRON 297-300 SN2IZINC 301-305 SN2ICOPP 306-309 SN2ISODI 310-313 SN2IPOTA 314-317 SN2ICFIB 318-321 SN2IASH 322-325 SN2ICAFE 326-329 SN2ISELE 330-334 SN2IPACI 335-338 SN2IATOC 339-342 SN2IBTOC 343-345 SN2IGTOC 346-349 SN2IDTOC 350-353 SN2IVD 354-357 SN2IS040 358-360 SN2IS060 361-363 SN2IS080 364-366 SN2IS100 367-369 SN2IS120 370-373 SN2IS140 374-376 SN2IS160 377-380 SN2IS170 381-383 SN2IS180 384-387 SN2IS200 388-390 SN2IS220 391-393 SN2IM141 394-396 SN2IM161 397-399 SN2IM181 400-404 SN2IM201 405-407 SN2IM221 408-410 SN2IP182 411-414 SN2IP183 415-418 SN2IP184 419-421 SN2IP204 422-424 SN2IP205 425-427 SN2IP225 428-430 SN2IP226 431-433 SN2IGLUC 434-437 SN2IFRUC 438-441 SN2IGALA 442-444 SN2ISUCR 445-449 SN2ILACT 450-453 SN2IMALT 454-457 SN2IIFIB 458-461 SN2ISFIB 462-465 SN2IPECT 466-468 SN2ISTAR 469-473 SN2IASPR 474-479 SN2ITRYP 480-482 SN2ITHRE 483-485 SN2IISOL 486-488 SN2ILEUC 489-492 SN2ILYSI 493-496 SN2IMETH 497-499 SN2ICYST 500-502 SN2IPHAL 503-505 SN2ITYRO 506-508 SN2IVALI 509-512 SN2IARGI 513-516 SN2IHIST 517-519 SN2IALAN 520-523 SN2IASPA 524-527 SN2IGLUT 528-531 SN2IGLYC 532-535 SN2IPROL 536-538 SN2ISERI 539-541 SN2ISACC 542-546 SN2IAPRO 547-551 SN2IVPRO 552-555 SN2IOXAA 556-561 SN2IPHYA 562-567 ; LABEL SEQN = "Respondent identification number" SU2STAT = "SNS2 Recall Status Code" SU2IID = "SNS2 Interviewer ID" SU2MN = "SNS2 Meal number" SU2FN = "SNS2 Food number" SU2CN = "SNS2 Component number" SU2MNC = "SNS2 meal name code" SU2MPC = "SNS2 meal place code" SU2MTOE = "SNS2 Meal time of eating" SU2REC = "SNS2 Recipe or prep. food flag (1/0)" SU2VIF = "SNS2 Variable ingredient flag (1/0)" SU2CFF = "SNS2 Combination Food Flag(1,0)" SU2TCC = "SNS2 Combination Food Code" SU2FCODE = "SNS2 USDA food code. Food ID1" SU2FID = "SNS2 Food ID 2. Look-up NCC Description" SU2COMM = "SNS2 Brand/Food Code (1st char 0,1)" SU2PPDC = "SNS2 Preparation Description Code" SU2CAUF = "SNS2 component amount unknown flag" SU2IGW = "SNS2 USDA Total grams of food/beverage" SU2IALCO = "SNS2 USDA Alcohol (gm)" SU2ICALC = "SNS2 USDA Calcium (mg)" SU2ICARB = "SNS2 USDA Carbohydrate (gm)" SU2ICARO = "SNS2 USDA Carotenes (RE)" SU2ICHOL = "SNS2 USDA Cholesterol (mg)" SU2ICOPP = "SNS2 USDA Copper (mg)" SU2IFIBE = "SNS2 USDA Total dietary fiber (gm)" SU2IFOLA = "SNS2 USDA Folacin (micrograms)" SU2IIRON = "SNS2 USDA Iron (mg)" SU2IKCAL = "SNS2 USDA Food energy (Kcal)" SU2IMAGN = "SNS2 USDA Magnesium (mg)" SU2IMFAT = "SNS2 USDA TOT Monounsat. fatty acids(gm)" SU2INIAC = "SNS2 USDA Niacin (mg)" SU2IPFAT = "SNS2 USDA TOT Polyunsat. fatty acids(gm)" SU2IPHOS = "SNS2 USDA Phosphorus (mg)" SU2IPOTA = "SNS2 USDA Potassium (mg)" SU2IPROT = "SNS2 USDA Protein (gm)" SU2ISFAT = "SNS2 USDA Total sat. fatty acids (gm)" SU2ISODI = "SNS2 USDA Sodium (mg)" SU2ITFAT = "SNS2 USDA Total fat (gm)" SU2IVAIU = "SNS2 USDA Vitamin A (IU)" SU2IVARE = "SNS2 USDA Vitamin A (RE)" SU2IVB1 = "SNS2 USDA Thiamin (mg)" SU2IVB2 = "SNS2 USDA Riboflavin (mg)" SU2IVB6 = "SNS2 USDA Vitamin B6 (mg)" SU2IVB12 = "SNS2 USDA Vitamin B12 (micrograms)" SU2IVC = "SNS2 USDA Ascorbic acid (mg)" SU2IVE = "SNS2 USDA Vit. E (alpha tocopherol eq.)" SU2IWATE = "SNS2 USDA Water (gm)" SU2IZINC = "SNS2 USDA Zinc (mg)" SN2IGW = "SNS2 NCC Total grams of foods and bev." SN2IWATE = "SNS2 NCC Water (gm)" SN2IKCAL = "SNS2 NCC Calories (kcal)" SN2IPROT = "SNS2 NCC Protein (gm)" SN2ITFAT = "SNS2 NCC Total fats (gm)" SN2ISFAT = "SNS2 NCC Total sat. fatty acids (gm)" SN2IMFAT = "SNS2 NCC Tot monounsat. fatty acids (gm)" SN2IPFAT = "SNS2 NCC Tot polyunsat. fatty acids (gm)" SN2ICHOL = "SNS2 NCC Cholesterol (mg)" SN2ICARB = "SNS2 NCC Total carbohydrates (gm)" SN2IFIBE = "SNS2 NCC Dietary fiber (gm)" SN2IALCO = "SNS2 NCC Alcohol (gm)" SN2IVAIU = "SNS2 NCC Total vitamin A (IU)" SN2IRETI = "SNS2 NCC Retinol (mcg)" SN2IBCAR = "SNS2 NCC Beta-carotene (mcg)" SN2IVE = "SNS2 NCC Total alpha-tocopherol eq. (mg)" SN2IVC = "SNS2 NCC Vitamin C (mg)" SN2IVB1 = "SNS2 NCC Thiamin (mg)" SN2IVB2 = "SNS2 NCC Riboflavin (mg)" SN2INIAC = "SNS2 NCC Niacin (mg)" SN2IVB6 = "SNS2 NCC Vitamin B6 (mg)" SN2IFOLA = "SNS2 NCC Folic acid (mcg)" SN2IVB12 = "SNS2 NCC Vitamin B12 (mcg)" SN2ICALC = "SNS2 NCC Calcium (mg)" SN2IPHOS = "SNS2 NCC Phosphorous (mg)" SN2IMAGN = "SNS2 NCC Magnesium (mg)" SN2IIRON = "SNS2 NCC Iron (mg)" SN2IZINC = "SNS2 NCC Zinc (mg)" SN2ICOPP = "SNS2 NCC Copper (mg)" SN2ISODI = "SNS2 NCC Sodium (mg)" SN2IPOTA = "SNS2 NCC Potassium (mg)" SN2ICFIB = "SNS2 NCC Crude Fiber (gm)" SN2IASH = "SNS2 NCC Ash (gm)" SN2ICAFE = "SNS2 NCC Caffeine (mg)" SN2ISELE = "SNS2 NCC Selenium (mcg)" SN2IPACI = "SNS2 NCC Pantothenic acid (mg)" SN2IATOC = "SNS2 NCC Alpha-tocopherol (mg)" SN2IBTOC = "SNS2 NCC Beta-tocopherol (mg)" SN2IGTOC = "SNS2 NCC Gamma-tocopherol (mg)" SN2IDTOC = "SNS2 NCC Delta-tocopherol (mg)" SN2IVD = "SNS2 NCC Vitamin D (mcg)" SN2IS040 = "SNS2 NCC SFA 4:0 (gm)" SN2IS060 = "SNS2 NCC SFA 6:0 (gm)" SN2IS080 = "SNS2 NCC SFA 8:0 (gm)" SN2IS100 = "SNS2 NCC SFA 10:0 (gm)" SN2IS120 = "SNS2 NCC SFA 12:0 (gm)" SN2IS140 = "SNS2 NCC SFA 14:0 (gm)" SN2IS160 = "SNS2 NCC SFA 16:0 (gm)" SN2IS170 = "SNS2 NCC SFA 17:0 (gm)" SN2IS180 = "SNS2 NCC SFA 18:0 (gm)" SN2IS200 = "SNS2 NCC SFA 20:0 (gm)" SN2IS220 = "SNS2 NCC SFA 22:0 (gm)" SN2IM141 = "SNS2 NCC MFA 14:1 (gm)" SN2IM161 = "SNS2 NCC MFA 16:1 (gm)" SN2IM181 = "SNS2 NCC Oleic acid (MFA 18:1) (gm)" SN2IM201 = "SNS2 NCC MFA 20:1 (gm)" SN2IM221 = "SNS2 NCC MFA 22:1 (gm)" SN2IP182 = "SNS2 NCC Linoleic acid (PFA 18:2) (gm)" SN2IP183 = "SNS2 NCC Linolenic acid (PFA 18:3) (gm)" SN2IP184 = "SNS2 NCC PFA 18:4 (gm)" SN2IP204 = "SNS2 NCC PFA 20:4 (gm)" SN2IP205 = "SNS2 NCC PFA 20:5 (gm)" SN2IP225 = "SNS2 NCC PFA 22:5 (gm)" SN2IP226 = "SNS2 NCC PFA 22:6 (gm)" SN2IGLUC = "SNS2 NCC Glucose (gm)" SN2IFRUC = "SNS2 NCC Fructose (gm)" SN2IGALA = "SNS2 NCC Galactose (gm)" SN2ISUCR = "SNS2 NCC Sucrose (gm)" SN2ILACT = "SNS2 NCC Lactose (gm)" SN2IMALT = "SNS2 NCC Maltose (gm)" SN2IIFIB = "SNS2 NCC Water insol. dietary fiber (gm)" SN2ISFIB = "SNS2 NCC Water sol. dietary fiber (gm)" SN2IPECT = "SNS2 NCC Pectin (gm)" SN2ISTAR = "SNS2 NCC Starch (gm)" SN2IASPR = "SNS2 NCC Aspartame (mg)" SN2ITRYP = "SNS2 NCC Tryptophan (gm)" SN2ITHRE = "SNS2 NCC Threonine (gm)" SN2IISOL = "SNS2 NCC Isoleucine (gm)" SN2ILEUC = "SNS2 NCC Leucine (gm)" SN2ILYSI = "SNS2 NCC Lysine(gm)" SN2IMETH = "SNS2 NCC Methionine (gm)" SN2ICYST = "SNS2 NCC Cystine (gm)" SN2IPHAL = "SNS2 NCC Phenylalanine (gm)" SN2ITYRO = "SNS2 NCC Tyrosine (gm)" SN2IVALI = "SNS2 NCC Valine (gm)" SN2IARGI = "SNS2 NCC Arginine (gm)" SN2IHIST = "SNS2 NCC Histidine (gm)" SN2IALAN = "SNS2 NCC Alanine (gm)" SN2IASPA = "SNS2 NCC Aspartic Acid (gm)" SN2IGLUT = "SNS2 NCC Glutamic Acid (gm)" SN2IGLYC = "SNS2 NCC Glycine (gm)" SN2IPROL = "SNS2 NCC Proline (gm)" SN2ISERI = "SNS2 NCC Serine (gm)" SN2ISACC = "SNS2 NCC Saccharin (mg)" SN2IAPRO = "SNS2 NCC Animal Protein (gm)" SN2IVPRO = "SNS2 NCC Vegetable Protein (gm)" SN2IOXAA = "SNS2 NCC Oxalic Acid (mg)" SN2IPHYA = "SNS2 NCC Phytic Acid (mg)" ; RUN;