proc sql sas

Level 2 Creating a Table by Defining Its Structure and Adding Data a. Create a table named grion.xewards with four columns: 2. . Purchased- a numeric column, formatted to be nine characters wide, including commas and two decimal places . Year- a numeric column, formatted to be four characters wide with no decimal places . Level- a character column, which holds the value Silver, Gold, or Platinum . Award -a character column (maximum of 50 characters) b. Add six rows of data to the grion.rewards table, and then write a query to display the contents of the Rewards table. The results should resemble the following: PROC SQL Output Purchased Year Level Award fi ffffFNfffiififfffiffff 20000 2012 Silver 25% Discount on one item over $25 300.00 2012 Gold 15% Discount on one order over S50 500 00 2012 Platinum 10% Discount on all 2012 purchases 225.00 2013 Silver 25% Discount on one item over $50 35000 2013 Gold 15% Discount on one order over $100 60000 2013 Platinum 10% Discount on all 2013 purchases