SAS Assignment
Tasks On Canvas you will find six files, a mix of csv, txt and SAS formatted files. This information has been modified from data sourced from www.ncdc.noaa.gov. The files contain information on storm Events for 2019. See the image on the last page for guidance on the relationship between the tables. A data dictionary has also been provided on Canvas. Use this information complete the following Tasks using SAS coding, with the goal of exploring the following: Question: What impact did storm events have in 2019? To assist you in answering this research question, you will need to complete at least the tasks listed on the following page using SAS code: 1. Produce a bar graph that shows the total number of injuries for each month (that allows you to compare direct and indirect) for each month. Ensure the graph is clearly labelled and has an informative title. (2.5 marks) 2. Include any other relevant analysis of this data (only) to assist you to understand the impact storm events had in 2019. Should contain at least one column from each file. Recommended to use as many columns possible. (7 marks) General requirements. All solutions must be prepared with SAS Code. Units should be converted to metric where used. All outputs need to be clearly labelled and detailed enough to be understood without having to read the main body of the report. Data sourced from: https://www.ncdc.noaa.gov/ Accessed 22 September 2020 Note some fields and tables have been modified for the purpose of this assignment. ( Event ID Episode ID Damage ) ( Episode ID Event ID Locations ) ( Detail Fatalities Episode ID PK Descriptions ) ( Episode ID Event ID Event ID Episode ID Event ID PK Tornadoes ) EVENT_ID,EPISODE_ID,DAMAGE_PROPERTY,DAMAGE_PROPERTY_UNIT,DAMAGE_CROP,DAMAGE_CROP_UNIT 791304,132253,0,K,0,K 791319,132263,0,K,0,K 791320,132264,0,K,0,K 791321,132264,0,K,0,K 791322,132264,0,K,0,K 791323,132264,0,K,0,K 791324,132265,0,K,0,K 791325,132265,0,K,0,K 791326,132265,0,K,0,K 791368,132272,0,K,0,K 795809,132272,0,K,0,K 795813,132272,0,K,0,K 795818,132272,0,K,0,K 795822,132272,0,K,0,K 791482,132288,0,K,0,K 791484,132288,0,K,0,K 791578,132299,,,0,K 791579,132299,,,0,K 791580,132299,,,0,K 791581,132299,,,0,K 791582,132299,,,0,K 791583,132299,0,K,0,K 791649,132306,0,K,0,K 791650,132307,0,K,0,K 802120,132315,0,K,0,K 791875,132325,,,0,K 792052,132325,0,K,0,K 792061,132325,0,K,0,K 792069,132325,0,K,0,K 792073,132325,0,K,0,K 792075,132325,0,K,0,K 792172,132325,0,K,0,K 792178,132325,0,K,0,K 792180,132325,0,K,0,K 792183,132325,0,K,0,K 792185,132325,0,K,0,K 792192,132325,0,K,0,K 792197,132325,0,K,0,K 792199,132325,0,K,0,K 792202,132325,0,K,0,K 792682,132325,0,K,0,K 792685,132325,0,K,0,K 792687,132325,0,K,0,K 792690,132325,500,K,0,K 792692,132325,,,0,K 792694,132325,,,0,K 792696,132325,,,0,K 792701,132325,0,K,0,K 792703,132325,0,K,0,K 792705,132325,0,K,0,K 792707,132325,0,K,0,K 791767,132327,0,K,0,K 791770,132327,0,K,0,K 791771,132327,0,K,0,K 791772,132327,0,K,0,K 791773,132327,0,K,0,K 791778,132327,0,K,0,K 794327,132327,0,K,0,K 794335,132327,0,K,0,K 794341,132327,0,K,0,K 794343,132327,0,K,0,K 791876,132347,0,K,0,K 791898,132349,0,K,0,K 791912,132353,1,K,0,K 791923,132353,0,K,0,K 791924,132357,2,K,0,K 791943,132362,0,K,0,K 791996,132374,0,K,0,K 792028,132380,0,K,0,K 792030,132380,0,K,0,K 792031,132380,0,K,0,K 792032,132380,0,K,0,K 792034,132380,0,K,0,K 792036,132380,0,K,0,K 792037,132380,0,K,0,K 792040,132380,0,K,0,K 792041,132380,0,K,0,K 792085,132386,0,K,0,K 792082,132387,10,K,0,K 792092,132389,1,K,0,K 792094,132389,0,K,0,K 792096,132389,5,K,0,K 792097,132389,1,K,0,K 792098,132389,1,K,0,K 792099,132389,5,K,0,K 792100,132389,2,K,0,K 792101,132389,1,K,0,K 792103,132389,2,K,0,K 792107,132389,1,K,0,K 792110,132389,1,K,0,K 792113,132389,50,K,0,K 792114,132389,0,K,0,K 792115,132392,0,K,0,K 792116,132392,0,K,0,K 792157,132398,0,K,0,K 792170,132398,0,K,0,K 792173,132398,0,K,0,K 792176,132402,0,K,0,K 792190,132407,0,K,0,K 792201,132408,0,K,0,K 792203,132410,0,K,0,K 792207,132410,0,K,0,K 792208,132410,0,K,0,K 792204,132411,0,K,0,K 792206,132411,0,K,0,K 792209,132411,0,K,0,K 792210,132411,0,K,0,K 792212,132411,0,K,0,K 792213,132411,0,K,0,K 792215,132411,0,K,0,K 792216,132411,0,K,0,K 792217,132411,0,K,0,K 792218,132411,0,K,0,K 792219,132411,0,K,0,K 792220,132411,0,K,0,K 795195,132411,0,K,0,K 792214,132413,0,K,0,K 792222,132415,0,K,0,K 792223,132415,0,K,0,K 792224,132415,0,K,0,K 792225,132415,0,K,0,K 792226,132415,0,K,0,K 795196,132415,0,K,0,K 792248,132418,0,K,0,K 792249,132418,0,K,0,K 792250,132418,0,K,0,K 792251,132418,0,K,0,K 792967,132425,3,K,0,K 792971,132425,1.5,K,0,K 792635,132426,0.5,K,0,K 792636,132426,6,K,0,K 792637,132426,4,K,0,K 792645,132426,4,K,0,K 792957,132426,1,K,0,K 792354,132429,0,K,0,K 792442,132429,0,K,0,K 792444,132429,0,K,0,K 792357,132434,,,, 792358,132434,,,, 792359,132434,,,, 792360,132434,,,, 792361,132434,,,, 792362,132434,,,, 792363,132434,,,, 792364,132434,,,, 792365,132434,,,, 792366,132434,,,, 792367,132434,,,, 792368,132434,,,, 792369,132434,,,, 792370,132434,,,, 792371,132434,,,, 792372,132434,,,, 792373,132434,,,, 792374,132434,,,, 792375,132434,,,, 792376,132434,,,, 792377,132434,,,, 792378,132434,,,, 792379,132434,,,, 792380,132434,,,, 792381,132435,,,, 792382,132435,,,, 792383,132435,,,, 792384,132435,,,, 792385,132435,,,, 792386,132435,,,, 792387,132435,,,, 792388,132435,,,, 792389,132435,,,, 792390,132435,,,, 792391,132435,,,, 792392,132435,,,, 792393,132435,,,, 792394,132435,,,, 792395,132435,,,, 792396,132435,,,, 792397,132435,,,, 792398,132435,,,, 792466,132440,0,K,0,K 792469,132440,0,K,0,K 792608,132471,0,K,0,K 793142,132477,10,K,0,K 793143,132477,10,K,0,K 793144,132477,10,K,0,K 793145,132477,10,K,0,K 793146,132477,5,K,0,K 793147,132477,5,K,0,K 793148,132477,5,K,0,K 793149,132477,5,K,0,K 793150,132477,5,K,0,K 792652,132478,15,K,0,K 792653,132478,10,K,0,K 792654,132478,10,K,0,K 792662,132478,20,K,0,K 792890,132478,35,K,0,K 792898,132478,15,K,0,K 792899,132478,25,K,0,K 792907,132478,25,K,0,K 792910,132478,15,K,0,K 792913,132478,15,K,0,K 792916,132478,15,K,0,K 792918,132478,15,K,0,K 792919,132478,20,K,0,K 792921,132478,10,K,0,K 792922,132478,10,K,0,K 792925,132478,5,K,0,K 792655,132480,0,K,0,K 792656,132480,10,K,0,K 792657,132480,0,K,0,K 792658,132480,0,K,0,K 792659,132481,0,K,0,K 792660,132481,0,K,0,K 792663,132482,0,K,0,K 792664,132482,0,K,0,K 792665,132483,0,K,0,K 792666,132483,0,K,0,K 792667,132484,0,K,0,K 792668,132484,0,K,0,K 792679,132488,0,K,0,K 792680,132488,0,K,0,K 792699,132488,0,K,0,K 792678,132489,0,K,0,K 792683,132490,0,K,0,K 792688,132490,0,K,0,K 792697,132491,0,K,0,K 792698,132491,0,K,0,K 793017,132491,0,K,0,K 793018,132491,0,K,0,K 792708,132492,0,K,0,K 792709,132492,0,K,0,K 792710,132493,0,K,0,K 792711,132493,0,K,0,K 792712,132493,0,K,0,K 792713,132493,0,K,0,K 792714,132493,0,K,0,K 792715,132493,0,K,0,K 792718,132494,0,K,0,K 792719,132494,0,K,0,K 792716,132495,0,K,0,K 792717,132495,0,K,0,K 792734,132499,0,K,0,K 792736,132499,0,K,0,K 792737,132499,0,K,0,K 792739,132499,0,K,0,K 792740,132499,0,K,0,K 792741,132499,0,K,0,K 792743,132499,0,K,0,K 792744,132499,0,K,0,K 792745,132499,0,K,0,K 792746,132499,0,K,0,K 792748,132499,0,K,0,K 792749,132499,0,K,0,K 792750,132499,0,K,0,K 792751,132499,0,K,0,K 792752,132499,0,K,0,K 792753,132499,0,K,0,K 792754,132499,0,K,0,K 792755,132499,0,K,0,K 792757,132499,0,K,0,K 792758,132499,0,K,0,K 792759,132499,0,K,0,K 792760,132499,0,K,0,K 792792,132507,,,, 792793,132507,,,, 792794,132507,,,, 792795,132507,,,, 792796,132509,75,K,0,K 792829,132510,0,K,0,K 792830,132510,0,K,0,K 792831,132510,0,K,0,K 792832,132510,0,K,0,K 792833,132510,0,K,0,K 792834,132510,0,K,0,K 792822,132511,0,K,0,K 792823,132511,0,K,0,K 792824,132511,0,K,0,K 792825,132511,0,K,0,K 792826,132511,0