1. Read the data contained in the earthquakestxt i, document directly from the data le using formatted input into a permanent SAS data set called earthquakes using the following information: Column Var'able number I Variable Label Name where the data begins , Magnitude , magnitude 1 Numeric Recorded Depth (km) Numeric degdistance Distance (degrees) Numeric latitude Latitude Numeric longitude Longitude Numeric Location Where location Earthquake was 40 Character Reported When the date Earthquake Occurred Hints: 0 You will need to specify which variables are character variables and which are numeric 0 You may need to specify the length of the location variable 0 You will need to use the appropriate date informat for date 2. The degdistance variable is measured in degrees. One degree is approximately 111.2 kilometers. Create a new variable called distance using the degdistance variable that gives the distance in kilometers. 3. Create a new variable called hemisphere based on the latitude variable by using the following Missing Value specications: 4. Print the resulting dataset. Suppress the observation column. Format the date variable to appear MM-DD-YYYY (ex: 06-07-1998). Add a relevant title. 5. Sort the dataset by the magnitude variable in descending order. Save the sorted dataset as a temporary dataset called earthquakes_srtd. 6. Use the sorted dataset from Problem 5 to print the magnitude, location, and date of the top 10 most powerful (by magnitude) earthquakes in the northern hemisphere. Suppress the observation column. Format the date variable to appear MM-DD-YYYY (ex: 06-07-1998). Add a relevant title. Use the labels given in the table in Problem 1. Hints: 0 You only need to print three columns: magnitude, location, and date 0 You will need to use a WHERE statement 0 Your resulting output should only have 10 observations 0 magnitude should be in descending order