Question 1

The dataset is related to a cake-baking contest between various participants.

1. Construct a Library called "BAKERY" using SAS programming code and not the Library Wizard.
2. Write the SAS code to import data from the Excel file "cake_list"in to the library "BAKERY" that was created in (Question 1.1).
3. Use the printing procedure to view the permanent SAS data set that you have created in (Question 1.2). The data set should be outputted as a Portable Document Format document.

Question 2

In "Question 1" you have created a SAS data set and have imported it into the library called Bakery. Use the SAS dataset you have imported for the following questions.

2.1 Use SAS code to produce the following descriptive statistics for the variables PresentScore and TasteScore. All the results produced should only have 2 decimals places after the comma.

• Number of Observations
• Arithmetic mean
• Maximum
• Minimum

2.2 Add the title as follows

• Summary presentation of Presentation and Taste Scores

Dataset "Cake_list" (provided below)

Variables	Description
Lastname	The participants Last name or Surname
Age	The Age of the Participant
PresentScore	The actual score for the presentation of the Cake
TasteScore	The taste score received for the Participants Cake
Layers	The amount of layers the Cake had.
Flavour	The type of flavour of the cake that was baked

LASTNAME AGE PRESENTSCORE TASTESCORE FLAVOUR LAYERS Orlando 27 93 80 Vanilla Ramey 32 84 72 Rum N Goldston 46 68 75 Vanilla Roe 38 79 73 Vanilla 2 Larsen 23 77 84 Chocolate Davis 51 86 91 Spice Strickland 19 82 79 Chocolate 1 Nguyen 57 77 84 Vanilla Hildenbrand 33 81 83 Chocolate Byron 62 72 87 Vanilla N Sanders 26 56 79 Chocolate Jaeger 43 66 74 Davis 28 69 75 Chocolate 2 Conrad 69 85 94 Vanilla 1 Walters 55 67 72 Chocolate 2 Rossburger 28 78 81 Spice 2 Matthew 42 81 92 Chocolate 2 Becker 36 62 83 Spice 2 Anderson 27 87 85 Chocolate Merritt 62 73 84 Chocolate 1