Use SAS code to answer the following questions using MYCOVID19 data. Submit the SAS code as a txt file and a pdf or doc file for the report. Only include

necessary tables or graphs from the SAS output in the report. DO NOT INCLUDE ALL SAS OUTPUT IN THE REPORT ECO520 Midterm Project Topic: COVID19 Data in Wisconsin by Census Tract (25 points total) Wisconsin COVID-19 data by census tract boundary All data are laboratory-confirmed cases of COVID-19 that we freeze once a day to verify and ensure that we are reporting accurate information. The number of people with positive/negative test results includes only Wisconsin residents who had their results reported electronically to DHS. Here are descriptions of the variables in the data Variable Name GEOID State CENSUS_TRACT COUNTY DATE POSITIVE NEGATIVE DEATHS HOSP_YES HOSP_NO AREA_LAND AREA_WATER POPULATION POP_LT18 POP_65P HOUS_NO_VEH ADULT_LIMITED_ENGLISH ADULT_SPANISH_LENG POP_BELOWPOV POP_DISABILITY POP_MEDICAD POP_MEDICARE POP_HEALTHINS HOUS_NOSMARTPHN HOUS NOINTERNET Variable Description Geographic ID State Census Tract Number County Name Last Date of Report Number of Positive on COVID19 Test Number of Negative on COVID19 Test Number of Deaths by COVID19 Number of Hospitalized by COVID19 Number of Not Hospitalized by COVID19 Land Area Size Water Area Size Total Population Percent of Population that is Less Than 18 Years Percent of Population that is 65 Years and Over Percent of households with no vehicle available Percent of adults 18 years and over who have limited English ability Percent of adults 18 years and over who speak Spanish and have limited English ability Percent of Population whose income in the past 12 months is below poverty level Percent of Population with a Disability Percent of Population with Medicaid/Means-Tested Public Coverage Percent of Population with Medicare Coverage Percent of Population with No Health Insurance Coverage Percent of Households that Have No Smartphone Percent of Households with No Internet Access Here is the SAS code to load the data into your SAS program filename webdat url "https://bigblue.depaul.edu/jlee141/econdata/eco520/COVID19_WI22.csv"; proc import datafile=webdat out = COVID19 DBMS = CSV replace; run ; run ; /*Select 500 randomly selected census tracts in WI using YourDePaulID */ proc surveyselect data= COVID19 method=srs seed Your De PaulID N=500 out= MYCOVID19 ; run; proc contents data=MYCOVID19 ; run ; 1. Data Steps (2 points) 1) Create the following variables (the recommended variable names in parentheses). ● ● ● The percent of POSITIVE by POPULATION: Pct POSITIVE = 100* POSTIVE/POPULATION The percent of DEATH by POPULATION: Pct DEATH = 100*DEATHS/POPULATION The percent of HOSP_YES by POSITIVE: Pct_HOSP_POSITIVE= 100*HOSP_YES/POSITIVE The percent of POSITIVE results by TOTAL TESTS: Pct_POSTIVE_TEST = 100* POSITIVE / (NEGATIVE+POSITIVE) A category variable for the size of census tract by POPULATION (SIZE_CLASS). Let's define the size of the census tract: if population is less than 2000, then SIZE CLASS =1, if 2000 <= POPULATION < 5000 then SIZE CLASS 2, and SIZE_CLASS = 3 if the POPULATION >= 5000. Remove any observations that have missing or zero for GEOID or POPULATION. = Data Set Name Member Type Engine Created Last Modified Protection Data Set Type Label Data Representation Encoding The SURVEYSELECT Procedure DATA V9 Selection Method Simple Random Sampling Input Data Set Random Number Seed Sample Size Selection Probability Sampling Weight Output Data Set WORK.MYCOVID19 10/17/2023 17:57:18 10/17/2023 17:57:18 COVID19 2124308 500 0.359195 2.784 MYCOVID19 The CONTENTS Procedure SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX IA64 utf-8 Unicode (UTF-8) Observations 500 Variables 26 0 Indexes Observation Length 224 Deleted Observations 0 NO Compressed Sorted NO Data Set Page Size Number of Data Set Pages First Data Page 1 1 Max Obs per Page 584 Obs in First Data Page 500 Number of Data Set Repairs 0 Filename Release Created Host Created Inode Number Access Permission Owner Name 131072 File Size File Size (bytes) /saswork/SAS_workCB87000081CD_odaws02-usw2.oda.sas.com/SAS_work1F7B000081CD_odaws02-usw2.oda.sas.com/mycovid 19.sas7bdat 9.0401M7 Linux 2663537 rw-r--r-- u63571857 256KB 262144 Engine/Host Dependent Information # Type 12 ADULT_LIMITED_ENGLISH Num 13 ADULT_SPANISH_LENG Num 6 AREA_LAND Num 7 AREA_WATER Num 4 CENSUS_TRACT Num 5 COUNTY Char 25 DEATHS Num 26 Date Variable Alphabetic List of Variables and Attributes Len Format 8 BEST12. BEST32. Informat 8 BEST12. 8 BEST 12. 8 BEST12. 8 BEST12. BEST32. BEST32. BEST32. BEST32. $9. BEST32. $24. BEST32. BEST12. BEST32. 9 $9. 8 BEST12. 24 $24. 8 BEST12. 8 8 BEST12. BEST32. 2 GEOID 24 HOSP_NO 23 HOSP_YES Char Num Num Num Variable # 12 ADULT_LIMITED_ENGLISH Num 13 ADULT_SPANISH_LENG Num 6 AREA_LAND Num 7 AREA_WATER Num 4 Num 5 COUNTY Char 25 DEATHS Num Char Num Num Num Num Num Num Char Num Num Num Num Num Num Num Num Num Num Char Alphabetic List of Variables and Attributes Type Len Format Informat 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 9 $9. $9. 8 BEST12. CENSUS_TRACT 26 Date 2 | GEOID 24 HOSP_NO 23 HOSP_YES 20 HOUS_NOINTERNET 19 HOUS_NOSMARTPHN 11 HOUS_NO_VEH 1 ID NEGATIVE POPULATION 22 8 10 POP_65P 14 POP BELOWPOV 15 POP_DISABILITY 18 POP_HEALTHINS 9 POP LT18 16 POP_MEDICAD 17 POP_MEDICARE 21 POSITIVE 3 State BEST32. $24. $24. BEST 12. BEST32. BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. BEST32. 8 BEST12. 4 $4. $4. BEST32. 8 BEST12. 8 BEST12. BEST32. BEST 12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST12. BEST32. 8 BEST 12. 8 BEST12. BEST32. BEST32. $11. 11 $11. 24/nstudent note : i have the code and answers also you just need to seed it with my ID and give it back run the code with my id and give it back