Description
InstructionsYou must download and use the datasets provided with this exam!Google Folder link: https://drive.google.com/drive/folders/1oZkEREo2Yz…
Unformatted Attachment Preview
Question 1
3 pts
Problem 1. Your director asks a report of number of customers from each age group
(use CUSTOMERS Download CUSTOMERStable).
Part a. Use SAS Studio and create the report for him. Your report should look like the
following, which consists of two lines of titles and and your name in the second title line.
The numbers in your table/report should be different since you are analyzing a different
data set.
Question 2
1 pts
Problem 1. Part b. Use the report you created in part a to answer the following two
questions.
Which age group has the least number of customers?
Group of answer choices
15-30 years
31-45 years
46-60 years
61-75 years
Question 3
1 pts
Problem 1. Part b. How many customers are in the age group you identified in the
previous question? [Please enter an integer in the blank space such as 111]
Question 4
2 pts
Problem 2. Part a. Your director asks for a visual representation of the frequency of customers from each
country (use CUSTOMERS table). Use SAS Studio and create a pie chart for him.
i.
Your chart should look like the following but should not be the same since you are analyzing
a different data set
ii.
Put labels outside of the slices
iii.
Set the title of the chart as Frequency of Customers by Country
iv.
Provide the screenshot of your pie chart.
Question 5
1 pts
Problem 2. Part b. Use the pie chart you created in part a to answer the following three
questions.
Which country has the second highest frequency of customers? [Multiple answers may
be correct]
Group of answer choices
US
CA
IL
DE
Question 6
1 pts
Problem 2. Part b. How many customers are from US? [Please enter an integer in the
blank space such as 111]
Question 7
1 pts
Problem 2. Part b. Which country has the lowest frequency of customers? [Multiple
answers may be correct]
Group of answer choices
TR
ZA
IL
AU
Flag question: Question 8
Question 8
2 pts
Problem 3. Part a. Your director wants a list of products provided by US suppliers
(use PRODUCTS Download PRODUCTStable)
i.
Use SAS Studio and generate a list of products; include only Product_ID, Product_Name
and Supplier_Country in the result.
ii.
Provide a screenshot of your partial list showing those products. Make sure to display the
total number of rows on the top (see below screenshot for an example of the rows and
columns).
Question 9
3 pts
Problem 3. Part b. Use the list you generated in part a to answer the fill in the blank
question.
The list has_________ rows and___________ columns.
(Please enter an integer in each of the two blank spaces, such as 111)
Question 10
2 pts
Problem 4. Part a. The director wants to know what products have their name
containing Child or Kid.
Use SAS Studio to filter the PRODUCTS data set for products with product name
containing Child or Kid; include Product_ID, Product_Name, and Supplier_Country in the
result.
Provide the screenshot of your list of products. Make sure to show the total number of
rows on the top (see below screenshot for an example on required row and column
information).
Question 11
3 pts
Problem 4. Part b. Use the list you generated in part a to answer the fill in the blank
question.
The list has__________ rows and _________ columns. The products in this list come
from_________ different supplier countries.
(Please enter an integer in each of the three blank spaces, such as 111. The last blank
asks for the number of different supplier countries)
Question 12
3 pts
Problem 5. Part a. Use ORDERS Download ORDERSdata set and write a SAS program to compute
a new column called Invoice_Price, which is the sum of Total Retail Price, Shipping, and tax. Tax is
8% of the total retail price, i.e., 0.08*Total_Retail_Price. The program should use Data Step starting with
a DATA line and a SET line.
Format Invoice_Price using the DOLLAR format. In the result, include order ID and the
newly calculated Invoice_Price column. Provide a screenshot of the partial list
showing order_ID and Invoice_Price. Make sure to show the total number of rows on
the top and sort the rows using ascending Invoice_Price by clicking on the column
heading.
Save the screenshot of your partial list in a file named as problem5. Then, attach the file as the
answer to this question by clicking Browse Local Files button.
Upload
Question 13
2 pts
Problem 5. Part b. Use the list you generated in part a to answer the fill in the blank
question.
The list has_________ rows.
(Please enter an integer in each of the two blank spaces, such as 111)
The invoice price of the first product in the list or the product at the top of the list
is__________ .
(Please enter a number with two decimal places, such as 111.11)
Question 14
2 pts
Problem 6. Part a. Use PRODUCTS and ORDERS data sets to create a query that shows
the total profit for all products including those with no profit. In the result, include
Product_Name and Total_Profit. So, each row of the list shows the name of a product and the total profit
from that product.
Provide a screenshot of the partial list. Make sure to show the total number of rows on
the top and sort the rows using descending Total_Profit by clicking on the column
heading.
Save the screenshot of your partial list in a file named as problem6. Then, attach the file
as the answer to this question by clicking Browse Local Files button.
Question 15
3 pts
Problem 6. Part b. Use the list you generated in part a to answer the fill in the blank
question.
The list has__________ rows or products.
(Please enter an integer in each of the three blank spaces, such as 111)
For the 8th product from the top of the list, its name is__________.
(Please enter the exact product name)
For the 8th product from the top of the list, its total profit is__________ .
(Please enter a number with two decimal places, such as 111.11)
Question 16
2 pts
Problem 7. Part a. Use PRODUCTS and ORDERS data sets to create a query that shows
the total profit for all products with total profit below $15 (i.e. ,
Purchase answer to see full
attachment
