Microsoft Word - Fall 2020 MSCR 533 Quiz 1.docx 3 Q2. Pleasedothefollowing: -First,downloadtheExcelfileQuiz1q2.xlsfromCanvas....

This is coding using SAS. Please provide answers in a word document to include all coding.Please see attached files with dataset and question


Microsoft Word - Fall 2020 MSCR 533 Quiz 1.docx 3 Q2.Pleasedothefollowing: -First,downloadtheExcelfileQuiz1q2.xlsfromCanvas. -Next,inSAS,importthedatafromtheExcelfileintoatemporarySASdatasetnamedquiz1q2(no needtowriteanycodeforthispart,unlessyoureallywantto!) -Inthespaceonthenextpage,writeawell-formattedanddocumentedSASprogramwhichdoes thefollowing: • Examinesthecontentsofthetemporarydatasetquiz1q2.[Notethatthevariablesubjectidisan identifierforeachsubject;treatmentrepresentsthetreatmentgroupthateachsubjectwasin; genderisacategoricalvariablerepresentingthesexofeachsubjectinthedataset,with0 representingmales,and1representingfemales;theremainingvariablesarecontinuous variables]. • Createsnumericaldescriptivestatisticsforeachvariableinthequiz1q2dataset.Makesure youuseappropriateproceduresforcategoricalandcontinuousvariables.Youdonotneedto analyzesubjectid. • Createsapermanentdatasetnamedmodified_quiz1q2whichcontainsallthevariablesand observationsfromthetemporaryquiz1q2datasetaswellasthefollowingtwonewvariables: o avariablenamedcopper_below_medianwhichisequalto1ifthevariablecopperis belowitsmedianvalueandwhichisequalto0ifcopperisgreaterthanorequaltothe medianvalue. o avariablenamedsexwhichisequalto‘male’ifthevariablegenderisequalto0,and equalto‘female’ifthegenderis1. *Besuretoaccountformissingvaluesappropriatelywhencreatingnewvariables. • Verifiesthatthenewvariablescopper_below_medianandsexwerecreatedproperlyusing stepsotherthanPROCPRINT. • Producesahistogramforthevariableselenium. • Produces side-by-side boxplots for males and females for the copper variable. Remembertobeefficientinyourprogramming–avoidredundantsteps,anduseasingledatastep insteadofmultipledatastepsunlessthatisnotpossible. 4 Space for your Q2 Code(or, alternatively, replace this page with a printout of your code). Sheet1 subjectidcopperseleniumtreatmentgenderprotein 11.7872202.1959 21.1667312.17322 3181203.7401 41.2698204.07974 51.44115302.55962 71.1178203.30176 81.43101301.98436 91.19102203.01644 100.83126204.44766 111.99127203.20376 121.99106302.05856 130.87392304.53712 141.11105203.90978 1588303.88836 161.43117204.14904 181.6992213.19893 201.3102302.51272 211.34120212.80994 221.8580212.59126 231.63100312.07858 241.2288201.94586 251.7120312.15446 26116201.89245 281.693202.7986 291.2581311.94432 302.05105302.93034 311.87129302.7454 321.887302.43082 331.33125302.95456 341.78120303.08994 351.32109302.36922 361.0450212.61688 381.08106302.13528 391.66104212.51356 401.5102302.94952 411.6897213.77622 421.19125302.40534 431.9875312.34584 441.73123312.68464 Sheet3