QUESTION 2: The following information is the description of the admin.diamonds dataset.
Variables:
- CARAT: Size of diamond (carat weight)
- COLOR: Color of diamond (D - almost clear white, Z - colorless, Y - light yellow)
- CLARITY: Clarity of diamond (FL - flawless, VSI - very slightly imperfect, SI - slightly imperfect, IPF - imperfect)
- CUT: Cut of diamond (EXCELLENT, VERY GOOD, GOOD)
- PRICE: Price of diamond (USD)
- ORIGIN: Diamond's country of origin (RUSSIA, BOTSWANA, AUSTRALIA, SOUTH AFRICA)
a) Write a PROC SQL query that will produce the same output as the given PROC steps.
SAS approach:
```
data russiadiamond;
set admin.diamonds;
where origin = "RUSSIA";
keep carat color cut price;
run;
proc sort data = russiadiamond;
by descending price;
run;
```
SQL approach:
```
proc sql;
create table russiadiamond as
select carat, color, cut, price
from admin.diamonds
where origin = "RUSSIA"
order by price desc;
quit;
```
Create a macro variable named Shape and use it in place of the value "EXCELLENT" in the variable CUT. Create a macro variable named Min and set it to a value of 20000. Use the macro variables in your PROC Print to filter the data only for excellent diamonds with a price of at least 20000.