I need help with this

Refer to the data set Insurancexls. The description of the variables in the dataset is as follows: ID = Customer ID GENDER = I if male; 0 if female AGE = Age of the cardholder, ranging from to 21 to 82 years old TRANSACTION = Amount of credit card purchase during the last six months (Thousand RM) RESPOND : 1 if offer is accepted; 0 if offer is not accepted MEMBERSHIP = Length of credit card membership (Years) LOCATION : 1 if Kuala Lumpur; 2 if Selangor; 3 if other states a) Use PROC IMPORT to convert the insurancexls to a permanent SAS data set. b) Produce the following cross-tabulation tables with the appropriate frequencies and percentages. Respond to the offer Location Did Not Accept Kuala Lumpur Sclangcr Other States Total Respond to the offer Did Not Accept ' Accept c) Create a data set that contains only those who accepted the offer and then drop the variable RESPOND. Then, use appropriate procedure to answer the following questions: i. How many is in the sample? ii. What is the minimum, maximum, median and mean age of the sample? iii. How many percent is from Kuala Lumpur? iv. On the average, how much did they spend using their credit cards during the last six months? (1) From the data set created in (d) above, select only females, who were below 30 years of age and spent more than RMSOOO during the last six months. Print only their ID, age and spending. e) Produce an appropriate table to compare the average transaction of the respondents based on location and gender. Format the transaction values with comma and dollar sign. \f\f\f\f