The following table has demographic, height, and weight data collected from nine individuals participating in a weight loss program. Use SAS data or input statement (“cards” or “datalines”) to create...

I have supplemental material also if you are able to complete the assignment.


The following table has demographic, height, and weight data collected from nine individuals participating in a weight loss program. Use SAS data or input statement (“cards” or “datalines”) to create a SAS dataset named “Diab” (copy and paste the data to a SAS program editor). Copy and paste the SAS program and log. *FOR QUESTION 2D File/chs762m32014brfssvariablelabel-gwhtmwpc (1).docx 2014 BRFSS Variable Names and Labels ADDEPEV2 = 'EVER TOLD YOU HAD A DEPRESSIVE DISORDER' ALCDAY5 = 'DAYS IN PAST 30 HAD ALCOHOLIC BEVERAGE' ASACTLIM = 'ACTIVITIES LIMITED DUE TO ASTHMA DURING PAST 12 MONTHS' ASATTACK = 'ASTHMA DURING PAST 12 MONTHS' ASBIADVC = 'OFFERED ADVICE ABOUT WHAT LEVEL OF DRINKING IS HARMFUL OR RISKY?' ASBIALCH = 'ASKED DURING CHECKUP IF YOU DRINK ALCHOHOL' ASBIBING = 'ASKED WHETHER YOU DRANK [5 FOR MEN /4 FOR WOMEN] OR MORE ALCOHOLIC DRINKS ON AN OCCASION?' ASBIDRNK = 'ASKED IN PERSON OR BY FORM HOW MUCH YOU DRINK?' ASBIRDUC = 'WERE YOU ADVISED TO REDUCE OR QUIT YOUR DRINKING?' ASDRVIST = 'URGENT ASTHMA TREATMENT DURING PAST 12 MONTHS' ASERVIST = 'EMERGENCY ASTHMA CARE DURING PAST 12 MONTHS' ASINHALR = 'TIMES USED ASTHMA INHALER DURING AN ATTACK IN PAST 30 DAYS' ASNOSLEP = 'SLEEP DIFFICULTY DUE TO ASTHMA DURING PAST 30 DAYS' ASRCHKUP = 'ROUTINE ASTHMA CARE DURING PAST 12 MONTHS' ASTHMA3 = 'EVER TOLD HAD ASTHMA' ASTHMAGE = 'AGE AT ASTHMA DIAGNOSIS' ASTHMED3 = 'DAYS USED PRESCRIBED PREVENTATIVE ASTHMA MED IN PAST 30 DAYS' ASTHNOW = 'STILL HAVE ASTHMA' ASYMPTOM = 'ASTHMA SYMPTOMS DURING PAST 30 DAYS' AVEDRNK2 = 'AVG ALCOHOLIC DRINKS PER DAY IN PAST 30' BLDSTOOL = 'EVER HAD BLOOD STOOL TEST USING HOME KIT' BLDSUGAR = 'HOW OFTEN CHECK BLOOD FOR GLUCOSE' BLIND = 'BLIND OR DIFFICULTY SEEING' CADULT = 'ARE YOU 18 YEARS OF AGE OR OLDER?' CARERCVD = 'SATISFIED WITH CARE RECEIVED' CASTHDX2 = 'HLTH PRO EVER SAID CHILD HAS ASTHMA' CASTHNO2 = 'CHILD STILL HAVE ASTHMA?' CCLGHOUS = 'DO YOU LIVE IN COLLEGE HOUSING?' CELLFON2 = 'IS THIS A CELLULAR TELEPHONE?' CHCCOPD1 = '(EVER TOLD) YOU HAVE (COPD) CHRONIC OBSTRUCTIVE PULMONARY DISEASE, EMPHYSEMA OR CHRONIC BRONCHITIS?' CHCKIDNY = '(EVER TOLD) YOU HAVE KIDNEY DISEASE?' CHCOCNCR = '(EVER TOLD) YOU HAD ANY OTHER TYPES OF CANCER?' CHCSCNCR = '(EVER TOLD) YOU HAD SKIN CANCER?' CHECKUP1 = 'LENGTH OF TIME SINCE LAST ROUTINE CHECKUP' CHILDREN = 'NUMBER OF CHILDREN IN HOUSEHOLD' CHKHEMO3 = 'TIMES CHECKED FOR GLYCOSYLATED HEMOGLOBIN' CNCRAGE = 'AGE TOLD HAD CANCER' _CNCRDIFF = 'HOW MANY TYPES OF CANCER?' CNCRTYP1 = 'TYPE OF CANCER' COLGHOUS = 'DO YOU LIVE IN COLLEGE HOUSING?' CPDEMO1 = 'DO YOU HAVE A CELL PHONE FOR PERSONAL USE?' CSRVCLIN = 'PARTICIPATE IN CLINICAL TRIAL AS PART OF CANCER TREATMENT?' CSRVCTL1 = 'IS PAIN UNDER CONTROL?' CSRVDEIN = 'EVER DENIED INSURANCE COVERAGE BECAUSE OF YOUR CANCER?' CSRVDOC1 = 'WHAT TYPE OF DOCTOR PROVIDES MAJORITY OF YOUR CARE' CSRVINSR = 'DID HEALTH INSURANCE PAY FOR ALL OF YOUR CANCER TREATMENT' CSRVINST = 'INSTRUCTIONS WRITTEN OR PRINTED' CSRVPAIN = 'CURRENTLY HAVE PHYSICAL PAIN FROM CANCER OR TREATMENT?' CSRVRTRN = 'EVER RECEIVE INSTRUCTIONS FROM A DOCTOR FOR FOLLOW-UP CHECK-UPS' CSRVSUM = 'DID YOU RECEIVE A SUMMARY OF CANCER TREATMENTS RECEIVED' CSRVTRT1 = 'CURRENTLY RECEIVING TREATMENT FOR CANCER' CSTATE = 'ARE YOU A RESIDENT OF [STATE]?' CTELENUM = 'CORRECT TELEPHONE NUMBER?' CTELNUM1 = 'CORRECT PHONE NUMBER?' CVDCRHD4 = 'EVER DIAGNOSED WITH ANGINA OR CORONARY HEART DISEASE' CVDINFR4 = 'EVER DIAGNOSED WITH HEART ATTACK' CVDSTRK3 = 'EVER DIAGNOSED WITH A STROKE' DECIDE = 'DIFFICULTY CONCENTRATING OR REMEMBERING' DELAYMED = 'DELAYED GETTING MEDICAL CARE' DIABAGE2 = 'AGE WHEN TOLD DIABETIC' DIABEDU = 'EVER TAKEN CLASS IN MANAGING DIABETES' DIABETE3 = '(EVER TOLD) YOU HAVE DIABETES' DIABEYE = 'EVER TOLD DIABETES HAS AFFECTED EYES' DIFFALON = 'DIFFICULTY DOING ERRANDS ALONE' DIFFDRES = 'DIFFICULTY DRESSING OR BATHING' DIFFWALK = 'DIFFICULTY WALKING OR CLIMBING STAIRS' DISPCODE = 'FINAL DISPOSITION' DLYOTHER = 'DELAYED GETTING MEDICAL CARE OTHER RESPONSE' DOCTDIAB = 'TIMES SEEN HEALTH PROFESSIONAL FOR DIABETES' DRADVISE = 'DOCTOR ADVISED REDUCED SODIUM/SALT INTAKE' DRNK3GE5 = 'BINGE DRINKING' DRNKANY5 = 'DRINK ANY ALCOHOLIC BEVERAGES IN PAST 30 DAYS' DRNKDRI2 = 'DID YOU DRIVE AFTER HAVING TOO MUCH TO DRINK IN THE PAST 30 DAYS?' DROCDY3_ = 'COMPUTED DRINK-OCCASIONS-PER-DAY' DRVISITS = 'DOCTOR VISITS PAST 12 MONTHS' EDUCA = 'EDUCATION LEVEL' EMPLOY1 = 'EMPLOYMENT STATUS' EMTSUPRT = 'HOW OFTEN GET EMOTIONAL SUPPORT NEEDED' EXERANY2 = 'EXERCISE IN PAST 30 DAYS' EYEEXAM = 'LAST EYE EXAM WHERE PUPILS WERE DILATED' FALL12MN = 'HAD FALL PAST TWELVE MONTHS' FALLINJ2 = 'INJURED IN FALL' FEETCHK = 'TIMES FEET CHECK FOR SORES/IRRITATIONS' FEETCHK2 = 'HOW OFTEN CHECK FEET FOR SORES OR IRRITATIONS' FLSHTMY2 = 'WHEN RECEIVED MOST RECENT SEASONAL FLU SHOT/SPRAY' FLUSHOT6 = 'ADULT FLU SHOT/SPRAY PAST 12 MOS' FMONTH = 'FILE MONTH' GENHLTH = 'GENERAL HEALTH' HADHYST2 = 'HAD HYSTERECTOMY' HADMAM = 'HAVE YOU EVER HAD A MAMMOGRAM' HADPAP2 = 'EVER HAD A PAP TEST' HADSGCO1 = 'WAS LAST TEST A SIGMOIDOSCOPY OR COLONOSCOPY' HADSIGM3 = 'EVER HAD SIGMOIDOSCOPY/COLONOSCOPY' HAVARTH3 = 'TOLD HAVE ARTHRITIS' HEIGHT3 = 'REPORTED HEIGHT IN FEET AND INCHES' HHADULT = 'NUMBER OF ADULTS IN HOUSEHOLD' HIVTST6 = 'EVER TESTED HIV' HIVTSTD3 = 'MONTH AND YEAR OF LAST HIV TEST' HLTHCVR1 = 'PRIMARY HEALTH INSURANCE COVERAGE' HLTHPLN1 = 'HAVE ANY HEALTH CARE COVERAGE' HOWLONG = 'HOW LONG SINCE LAST MAMMOGRAM' HPLSTTST = 'HOW LONG SINCE YOUR LAST HPV TEST?' HPVADSHT = 'NUMBER OF HPV SHOTS RECEIVED' HPVADVC2 = 'EVER HAD THE HPV VACCINATION?' HPVTEST = 'HAVE YOU EVER HAD AN HPV TEST?' HTIN4 = 'COMPUTED HEIGHT IN INCHES' HTM4 = 'COMPUTED HEIGHT IN METERS' IDATE = 'INTERVIEW DATE' IDAY = 'INTERVIEW DAY' IMFVPLAC = 'WHERE DID YOU GET YOUR LAST FLU SHOT/VACCINE?' IMONTH = 'INTERVIEW MONTH' INCOME2 = 'INCOME LEVEL' INSULIN = 'NOW TAKING INSULIN' INTERNET = 'INTERNET USE IN THE PAST 30 DAYS?' IYEAR = 'INTERVIEW YEAR' LADULT = 'ARE YOU 18 YEARS OF AGE OR OLDER?' LANDLINE = 'DO YOU ALSO HAVE A LANDLINE TELEPHONE?' LASTDEN3 = 'LAST VISITED DENTIST OR DENTAL CLINIC' LASTPAP2 = 'HOW LONG SINCE LAST PAP TEST' LASTSIG3 = 'TIME SINCE LAST SIGMOIDOSCOPY/COLONOSCOPY' LASTSMK2 = 'INTERVAL SINCE LAST SMOKED' LENGEXAM = 'HOW LONG SINCE LAST BREAST PHYSICAL EXAM' LONGWTCH = 'HOW LONG WATCHING SALT/SODIUM INTAKE' LSATISFY = 'SATISFACTION WITH LIFE' LSTBLDS3 = 'TIME SINCE LAST BLOOD STOOL TEST' LSTCOVRG = 'TIME SINCE LAST HAD HEALTH CARE COVERAGE' MARITAL = 'MARITAL STATUS' MAXDRNKS = 'MOST DRINKS ON SINGLE OCCASION PAST 30 DAYS' MEDBILL1 = 'CURRENTLY HAVE HEALTH CARE BILLS' MEDCOST = 'COULD NOT SEE DR. BECAUSE OF COST' MEDICARE = 'DO YOU HAVE MEDICARE?' MEDSCOST = 'COULD NOT GET MEDICINE DUE TO COST' MENTHLTH = 'NUMBER OF DAYS MENTAL HEALTH NOT GOOD' MSCODE = 'METROPOLITAN STATUS CODE' NOCOV121 = 'WITHOUT HEALTH CARE COVERAGE PAST 12 MONTHS' NUMADULT = 'NUMBER OF ADULTS IN HOUSEHOLD' NUMHHOL2 = 'HOUSEHOLD TELEPHONES' NUMMEN = 'NUMBER OF ADULT MEN IN HOUSEHOLD' NUMPHON2 = 'RESIDENTIAL PHONES' NUMWOMEN = 'NUMBER OF ADULT WOMEN IN HOUSEHOLD' PAINACT2 = 'HOW MANY DAYS HARD TO DO USUAL ACTIVITIES IN PAST 30 DAYS' PCPSAAD2 = 'HAS A HEALTH PROFESSIONAL EVER TALKED WITH YOU ABOUT THE ADVANTAGES OF THE PSA TEST?' PCPSADI1 = 'HAS A HEALTH PROFESSIONAL EVER TALKED WITH YOU ABOUT THE DISADVANTAGES OF THE PSA TEST?' PCPSARE1 = 'HAS A DOCTOR EVER RECOMMENDED THAT YOU HAVE A PSA TEST?' PCPSARS1 = 'WHAT WAS THE MAIN REASON YOU HAD THIS PSA TEST?' PDIABTST = 'HAD A TEST FOR HIGH BLOOD SUGAR IN PAST THREE YEARS' PERSDOC2 = 'MULTIPLE HEALTH CARE PROFESSIONALS' PHYSHLTH = 'NUMBER OF DAYS PHYSICAL HEALTH NOT GOOD' PNEUVAC3 = 'PNEUMONIA SHOT EVER' POORHLTH = 'POOR PHYSICAL OR MENTAL HEALTH' PREDIAB1 = 'EVER BEEN TOLD YOU HAVE PRE-DIABETES OR BORDERLINE DIABETES' PREGNANT = 'PREGNANCY STATUS' PROFEXAM = 'EVER HAD BREAST PHYSICAL EXAM BY DOCTOR' PSATEST1 = 'EVER HAD PSA TEST' PSATIME = 'TIME SINCE LAST PSA TEST' PVTRESD1 = 'PRIVATE RESIDENCE?' PVTRESD2 = 'DO YOU LIVE IN A PRIVATE RESIDENCE?' QLACTLM2 = 'ACTIVITY LIMITATION DUE TO HEALTH PROBLEMS' QLHLTH2 = 'HOW MANY DAYS FULL OF ENERGY IN PAST 30 DAYS' QLMENTL2 = 'HOW MANY DAYS DEPRESSED IN PAST 30 DAYS' QLSTRES2 = 'HOW MANY DAYS FELT ANXIOUS IN PAST 30 DAYS' QSTLANG = 'LANGUAGE IDENTIFIER' QSTVER = 'QUESTIONNAIRE VERSION IDENTIFIER' RCHISLA1 = 'ETHNICITY OF CHILD' RCSBIRTH = 'BIRTH DATE OF CHILD' RCSBRAC1 = 'RACE OF CHILD' RCSGENDR = 'GENDER OF CHILD' RCSRACE1 = 'RACE OF CHILD (MULTIPLE POSSIBLE)' RCSRLTN2 = 'RELATIONSHIP TO CHILD' RENTHOM1 = 'OWN OR RENT HOME' RMVTETH3 = 'NUMBER OF PERMANENT TEETH REMOVED' RRATWRK2 = 'HOW DO YOU FEEL YOU WERE TREATED AT WORK COMPARED TO PEOPLE OF OTHER RACES IN PAST 12 MONTHS?' RRCLASS2 = 'HOW DO OTHER PEOPLE USUALLY CLASSIFY YOU IN THIS COUNTRY?' RRCOGNT2 = 'HOW OFTEN DO YOU THINK ABOUT YOUR RACE?' RREMTSM2 = 'TIMES PAST 30 DAYS FELT EMOTIONALLY UPSET BECAUSE OF TREATMENT DUE TO YOUR RACE' RRHCARE3 = 'WHEN SEEKING HEALTH CARE PAST 12 MONTHS, WAS EXPERIENCE WORSE, SAME, BETTER THAN PEOPLE OF OTHER RACES?' RRPHYSM2 = 'TIMES PAST 30 DAYS FELT PHYSICAL SYMPTOMS BECAUSE OF TREATMENT DUE TO YOUR RACE' SCNTLPAD = 'HOW WERE YOU GENERALLY PAID FOR THE WORK YOU DID' SCNTLWK1 = 'HOW MANY HOURS PER WEEK DID YOU WORK' SCNTMEL1 = 'TIMES PAST 12 MONTHS WORRIED/STRESSED ABOUT HAVING ENOUGH MONEY TO BUY NUTRITIOUS MEALS?' SCNTMNY1 = 'TIMES PAST 12 MONTHS WORRIED/STRESSED ABOUT HAVING ENOUGH MONEY TO PAY YOUR RENT/MORTGAGE?' SCNTPAID = 'HOW ARE YOU GENERALLY PAID FOR THE WORK YOU DO' SCNTVOT1 = 'DID YOU VOTE IN THE LAST PRESIDENTIAL ELECTION?' SCNTWRK1 = 'HOW MANY HOURS PER WEEK DO YOU WORK' SEATBELT = 'HOW OFTEN USE SEATBELTS IN CAR?' SEQNO = 'ANNUAL SEQUENCE NUMBER' SEX = 'RESPONDENTS SEX' SHINGLE2 = 'HAVE YOU EVER HAD THE SHINGLES OR ZOSTER VACCINE?' SLEPTIM1 = 'HOW MUCH TIME DO YOU SLEEP' SMOKDAY2 = 'FREQUENCY OF DAYS NOW SMOKING' SMOKE100 = 'SMOKED AT LEAST 100 CIGARETTES' STATERES = 'RESIDENT OF STATE' STOPSMK2 = 'STOPPED SMOKING IN PAST 12 MONTHS' SXORIENT = 'SEXUAL ORIENTATION OR GENDER IDENTITY' TETANUS = 'RECEIVED TETANUS SHOT SINCE 2005?' TRNSGNDR = 'DO YOU CONSIDER YOURSELF TO BE TRANSGENDER?' USEEQUIP = 'HEALTH PROBLEMS REQUIRING SPECIAL EQUIPMENT' USENOW3 = 'USE OF SMOKELESS TOBACCO PRODUCTS' VETERAN3 = 'ARE YOU A VETERAN' WEIGHT2 = 'REPORTED WEIGHT IN POUNDS' WHRTST10 = 'LOCATION OF LAST HIV TEST' WTCHSALT = 'WATCHING SODIUM OR SALT INTAKE' WTKG3 = 'COMPUTED WEIGHT IN KILOGRAMS' _AGE65YR = 'REPORTED AGE IN TWO AGE GROUPS CALCULATED VARIABLE' _AGE80 = 'IMPUTED AGE VALUE COLLAPSED ABOVE 80' _AGEG5YR = 'REPORTED AGE IN FIVE-YEAR AGE CATEGORIES CALCULATED VARIABLE' _AGE_G = 'IMPUTED AGE IN SIX GROUPS' _AIDTST3 = 'EVER BEEN TESTED FOR HIV CALCULATED VARIABLE' _ALTETH2 = 'ADULTS AGED 65+ WHO HAVE HAD ALL THEIR NATURAL TEETH EXTRACTED' _ASTHMS1 = 'COMPUTED ASTHMA STATUS' _BMI5 = 'COMPUTED BODY MASS INDEX' _BMI5CAT = 'COMPUTED BODY MASS INDEX CATEGORIES' _CASTHM1 = 'CURRENT ASTHMA CALCULATED VARIABLE' _CHISPNC = 'CHILD HISPANIC, LATINO/A, OR SPANISH ORIGIN CALCULATED VARIABLE' _CHLDCNT = 'COMPUTED NUMBER OF CHILDREN IN HOUSEHOLD' _CLLCPWT = 'FINAL CHILD WEIGHT: LAND-LINE AND CELL-PHONE DATA' _COL10YR = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A COLONOSCOPY IN THE PAST 10 YEARS' _CPRACE = 'PREFERRED CHILD RACE CATEGORIES' _CRACE1 = 'CHILD NON-HISPANIC RACE INCLUDING MULTIRACIAL' _CRCREC = 'RESPONDENTS AGED 50-75 WHO HAVE FULLY MET THE USPSTF RECOMMENDATION' _DENVST2 = 'ADULTS WHO HAVE VISITED A DENTIST, DENTAL HYGENIST OR DENTAL CLINIC WITHIN THE PAST YEAR' _DRDXAR1 = 'RESPONDENTS DIAGNOSED WITH ARTHRITIS' _DRNKDY4 = 'COMPUTED NUMBER OF DRINKS OF ALCOHOL BEVERAGES PER DAY' _DRNKMO4 = 'COMPUTED TOTAL NUMBER DRINKS A MONTH' _DUALCOR = 'DUAL PHONE USE CORRECTION FACTOR' _DUALUSE = 'DUAL PHONE USE CATEGORIES' _EDUCAG = 'COMPUTED LEVEL OF EDUCATION COMPLETED CATEGORIES' _EXTETH2 = 'RISK FACTOR FOR HAVING HAD PERMANENT TEETH EXTRACTED' _FLSHOT6 = 'FLU SHOT CALCULATED VARIABLE' _FOBTFS = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A BLOOD STOOL TEST WITHIN THE PAST 3 YEARS AND A SIGMOIDOSCOPY WITHIN THE PAST 5 YEARS' _FS5YR = 'RESPONDENTS AGED 50-75 WHO HAVE HAD A SIGMOIDOSCOPY WITHIN THE PAST 5 YEARS' _HCVU651 = 'RESPONDENTS