ECO520 Business Analytics Tools II Homework 1 A multiple listing service's database and software is used by real estate brokers in real estate representing sellers under a listing contract to widely share information about properties with other brokers who may represent potential buyers or wish to work with a seller's broker in finding a buyer for the property or asset. The listing data stored in a multiple listing service's database is the proprietary information of the broker who has obtained a listing agreement with a property's seller. We used the sample of multiple listing service (MLS) data in class. Using the data, answer the following questions 1. Practice the examples in the video of House Price example, create SAS program file and submit that to D2L as HW1_MLS1.sas.txt. 2. Let's revisit the data and answer the following questions. All SAS commands need to be typed, saved as HW1_MLS2.sas.txt and submit to D2L. 1) Read the following cav data into SAS and create a SAS data name called "mymls". https://bigblue.depaul.edu/jlee141/econdata/housing/mls2021 sample.csv 2) Find the frequencies by ZIP code (the number of cases by Zip code). 3) Create a SAS data set called "myhw1" only including five zip codes that you are interested in. To select zip codes in SAS: Data myhw1 ; set mymls ; If ZIP = 606XX or ZIP = 600XX or .. ; a. Create a variable called the price per square feet: Price_Sqft = HPRICE / SQFT b. Create a variable called HPRICE_CLASS using conditional statement (if ....; else if; else;). Here are the class settings. D = 550000 : UPPER PRICE 4) Using the data,myhw1, you created in 3), a. Show the frequencies of BEDROOM, FIREPLACE, and GARAGE by ZIP code. b. Using PROC MEANS, find the descriptive statistics for all variables by ZIP code. c. Using SUMMARY, find the mean, median, P5, P95, min, max for HPRICE and SQFT. d. Repeat c. by ZIP code. Repeat c. by HPRICE_CLASS 5) Create the following graphs a. Scatter plot between LOG_PRICE and LOG_SQFT for each ZIP Code b. Bar Chart for BEDROOM, FIREPLACE, and GARAGE for each ZIP code