proc import file$=\text{'}$~$/$my$\_$shared$\_$file$\_$links$/$michaelweinberg$0/$ExamData$/$covid$-$daily.xlsx$\text{'}$

out$=$covid replace dbms$=$xlsx;

run;

Create a new dataset, with the U$.$S$.$ Territories eliminated. They have the following FIPS codes: $72,78,69$ and $60,$ for Puerto Rico, the U$.$S$.$ Virgin Islands, the Northern Mariana Islands and American Samoa, respectively. $(30$ points$)$

Using PROC FREQ, generate a table that shows how many reports of covid information each state submitted. Every combination of a date and a state is one submission. $(35$ points$)$

Complete the following step using three of the four SAS commands: PROC MEANS, PROC TABULATE, PROC REPORT, PROC SQL

Generate a table that for each state shows the state name, and the mean, median and maximum new cases. $(35$ points for each command, for a total of $105$ points$)$

Sort the covid dataset, sending output to a new dataset, with new cases as the primary key from the highest value to the lowest. Indicate in your comments which state and which day had the highest number of new cases. $(30$ points$)$

For extra credit, redo Step $3,$ but with the numeric values formatted with commas and nothing to the right of the decimal point. $(10$ for each command, for a total of $30$ points$).$

Note: Sample output is attached with this formatting. Your output does not need to look exactly like it$.$ To do the formatting with PROC MEANS, you may have to send the output to a new dataset, and then print that dataset.