7 Please compete in SAS using PROC SQL statement;

5. Creating a Table by Defining Its Structure and Adding Data a. Create a table named orion Rewards with four columns: 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 orion 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 200.00 2006 Silver 25% Discount on one item over S25 300.00 2006 Gold 500.00 2008 Platinum 10% Discount on all 2007 purchases 225.00 2007 Silver 25% Discount on one item over s50 350.00 2007 Gold 600.00 2007 Platinum 10% Discount on all 2008 purchases 15% Discount on one order over s50 15% Discount on one order over $100