2.
3 Solutions 2-39
1. Accessing and Investigating Data
a. Open the browser and sign in to SAS Viya. SAS Drive is displayed by default.
b. In the upper left corner, click (Show list of applications) and select Explore and
Visualize. SAS Visual Analytics appears.
c. Open the VA1- Practice2.1 report in the Courses/YVA185/Basics/Practices (HR) folder.
1) Click All Reports.
2) Navigate to the Courses/YVA185/Basics/Practices (HR) folder.
3) Double-click the VA1- Practice2.1 report to open it.
d. View the Data pane and answer the questions.
1) Verify that you are editing the report.
2) In the left pane, click Data.
3) Answer the following questions:
How many unique values does Company have? Job Title?
Answer: Company has 12 distinct values. Job Title has nine distinct values.
View the list of Category data items on the Data pane.
Copyright © 2020, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED.
2-40 Lesson 2 Preparing Data Using SAS® Data Studio
What is the type (or classification) of Employee ID?
Answer: Employee ID is classified as a measure data item.
View the list of measure data items on the Data pane.
e. View the list table of all data items on Page 1 and answer the questions.
1) If necessary, click the Page 1 tab at the top of the canvas.
The list table should resemble the following:
2) Scroll through the columns and answer the following questions:
What is the case of Employee Country?
Answer: Employee Country is lowercase.
Copyright © 2020, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED.
2.3 Solutions 2-41
Which employee represents sales over the internet or through the catalog?
Answer: Internet/Catalog Sales
Which data item can be used to determine whether an employee is active (currently
employed) or retired (formerly employed)?
Answer: If Employee Termination Date is missing, the employee is active
(currently employed). If Employee Termination Date is not missing, the
employee is retired (formerly employed).
f. View the crosstab of Department and Job Title on Page 2 and answer the question.
1) Click the Page 2 tab at the top of the canvas.
Copyright © 2020, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED.
2-42 Lesson 2 Preparing Data Using SAS® Data Studio
2) View the crosstab and answer the following question:
Which department contains the missing job title?
Answer: Stock & Shipping
g. Create an auto chart of Company (on the right side of the crosstab) and answer the
questions.
1) In the left pane, click Data.
2) Drag Company from the Data pane to the right side of the canvas.
Copyright © 2020, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED.
2.3 Solutions 2-43
What is the largest company, based on the number of employees? The smallest?
Answer: Orion USA is the largest company (120 employees). Logistics is the
smallest company (one employee).
• Place your cursor over the bars to see the frequency.
h. View the measure details (from the Data pane) and answer the questions.
1) In the left pane, click Data.
2) Click (Actions) and select View measure details.
The Measure Details table shows the minimum, maximum, average, and sum for each
measure.
Copyright © 2020, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED.
2-44 Lesson 2 Preparing Data Using SAS® Data Studio
What is the minimum total profit generated by an employee? The maximum? The
average? The total profit generated by all employees?
Answer: The minimum total profit generated by an employee is 11.10.
The maximum total profit generated by an employee is 19,146,779.62.
The average total profit generated by employees is 109,148.07.
The total profit generated by all employees is 70,727,947.65.
3) Click Close.
i. Save the report.
Copyright © 2020, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED.
