计算机代写 LWYVA185) with the permission from SAS Australia to use and publish for te

UNSW Business School/
Information Systems and Technology Management
Solutions to SAS VA Workbook 2 Practices and Activities
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

Lab Workshop:
Compiled/Modified By Date SAS Visual Analytics Jacky Mo Feb. 2022 SAS Viya for Learners
All the lab workshops on SAS VA will help the students to learn and gain experience in data preparation; data exploration; creating reports; and constructing dashboard.
Reference:
This workshop material is extracted from SAS® Visual Analytics Fast Track (LWYVA185) with the permission from SAS Australia to use and publish for teaching purpose at the University of Wales.
File Name:
SAS Lab Manual – Solutions to SAS VA Workbook 2 Practices and Activities
Copyright:
This lab workshop material is created for the Business Analytics courses, offered by the School of Information Systems and Technology Management, the University of Wales, Sydney, Australia
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

Solutions to Lesson 4
Solutions to Practices
1. Creating a Simple Report
a. Open the browser and sign in to SAS Viya. SAS Drive is displayed by default.
b. Open the VA1- Practice4.1 report from the Courses/YVA185/Basics/Practices (HR) folder.
1) In the upper left corner, click (Show list of applications) and select Explore and Visualize. SAS Visual Analytics appears.
2) Click All Reports.
3) Navigate to the Courses/YVA185/Basics/Practices (HR) folder. 4) Double-click the VA1- Practice4.1 report to open it.
c. Create a geo coordinate map, to the left of the bar chart.
1) In the left pane, click Objects.
2) Drag the Geo coordinate object, from the Geographic group, to left side of the canvas.
d. Modify options for the geo map.
1) In the right pane, click Options.
2) In the Object group, for the Name field, enter Average Profit by Country. 3) For the Title field, enter Average Profit by Country.
4) In the Legend group, for the Visibility field, select Off.
e. Assign data items to the specified roles.
1) In the right pane, click Roles.
2) For the Geography role, select AddEmployee Country.
3) For the Color role, select AddAverage Profit.
4) For the Data tip values role, select Add  Number of Employees and click OK.
The updated geo map should resemble the following:
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

f. In the upper right corner of the geo map, click (Maximize) and then answer the questions.
Which country has the highest average profit? The lowest?
Germany (DE) has the highest average profit. Denmark (DK) has the lowest average profit.
• In the detail table below the geo map, click the Average Profit column twice to sort in descending order.
• In the detail table below the geo map, click the Average Profit column again to sort in ascending order.
Which country has the highest number of employees? The lowest?
United States (US) has the highest number of employees. Denmark (DK) has the lowest number of employees.
• In the detail table below the geo map, click the Number of Employees column twice to sort in descending order.
• In the detail table below the geo map, click the Number of Employees column to sort in ascending order.
• In the upper right corner of the geo map, click (Restore).
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

g. Create a dual axis bar-line chart at the bottom of the canvas.
1) In the left pane, click Objects.
2) Drag the Dual axis bar-line chart object, from the Graphs group, to the bottom of the canvas.
3) In the right pane, click Roles.
4) For the Category role, select AddAnniversary Month.
5) For the Measure (bar) role, select AddNumber of Employees. 6) For the Measure (line) role, select AddAverage Profit.
h. Modify options for the dual axis bar-line chart.
1) In the right pane, click Options.
2) In the Object group, for the Name field, enter Employees and Profit by Anniversary Month.
3) For the Title field, enter Employees and Profit by Anniversary Month.
4) In the Line group, select Markers.
i. In the dual axis bar-line chart, on the horizontal axis, right-click Anniversary Month and
select Sort  Anniversary Month: Ascending to sort the bars. The dual axis bar-line chart should resemble the following:
j. In the upper right corner of the dual axis bar-line chart, click (Maximize). In which month were most employees hired?
Answer: January
• In the detail table below the dual axis bar-line chart, click the Number of Employees column twice to sort in descending order.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

Which anniversary month contains employees that generate the highest average profit?
Answer: July
• In the detail table below the dual axis bar-line chart, click the Average Profit column twice to sort in descending order.
• In the upper right corner of the dual axis bar-line chart, click (Restore).
k. Save the report. 2. Working with Pages
a. Open the browser and sign in to SAS Viya. SAS Drive is displayed by default.
b. Open the VA1- Practice4.2a report from the Courses/YVA185/Basics/Practices (HR)
1) In the upper left corner, click (Show list of applications) and select Explore and
Visualize. SAS Visual Analytics appears.
2) Click All Reports.
3) Navigate to the Courses/YVA185/Basics/Practices (HR) folder. 4) Double-click the VA1- Practice4.2a report to open it.
c. Set the Viewer Customization level so that users cannot change the data or the type of chart used in the report.
1) In the right pane, click Options.
2) Use the drop-down list, on the top of the Options pane, to select the report.
3) In the Viewer Customization group, for Capability level, select Simple edits. Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

This option enables viewers to make changes that will not alter the original intent of the report. Users who view the report can sort data and change minor display options, but they cannot change the data or the type of chart used in the report.
d. Add a new page to the report and rename pages.
1) In the upper left corner of the report, next to Page 1, click (New page). 2) Double-click the Page 2 heading to make it editable.
3) Enter Profit Analysis and press Enter.
4) Click Page 1 to make it active.
5) Double-click the Page 1 heading to make it editable. 6) Enter Employee Analysis and press Enter.
e. Create a bar chart on the Profit Analysis page.
1) If necessary, click the Profit Analysis tab to make the page active. 2) In the left pane, click Objects.
3) Drag the Bar chart object, from the Graphs group, to the canvas.
4) In the right pane, click Roles.
5) For the Category role, select AddGroup.
6) For the Measure role, select Number of EmployeesTotal Profit.
f. Specify Total Profit by Group as the name of the bar chart.
1) In the right pane, click Options.
2) In the Object group, for the Name field, enter Total Profit by Group. 3) For the Title field, enter Total Profit by Group.
g. In the bar chart, on the vertical axis, right-click Group and select Sort  Group: Ascending to sort the bars.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The bar chart should resemble the following:
h. In the upper right corner of the bar chart, click (Maximize) and then answer the questions.
Which group produces the highest total profit?
Answer: Outdoors
• In the detail table below the bar chart, click the Total Profit column twice to sort in descending order.
Which group produces the lowest total profit?
Answer: Temporary
• In the detail table below the bar chart, click the Total Profit column to sort in ascending order.
• In the upper right corner of the bar chart, click (Restore).
i. Save the report.
j. In the upper left corner, click (View report) to view the report.
k. On the Profit Analysis page, sort the bars by Total Profit in descending order and show data
1) At the top of the report, click the Profit Analysis tab to make the page active, if necessary.
2) Right-clickthebarchartandselectSortTotalProfit:Descending. Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

3) Right-click the bar chart and select LabelsData labels. The bar chart should resemble the following:
The Viewer Customization level enables viewers to modify simple options, like modifying the sort direction and changing labels.
l. In the upper right corner, click (Menu) and select Close to close the report. 3. Working with Prompts and Actions
a. Open the browser and sign in to SAS Viya. SAS Drive is displayed by default.
b. Open the VA1- Practice4.2b report from the Courses/YVA185/Basics/Practices (HR)
1) In the upper left corner, click (Show list of applications) and select Explore and
Visualize. SAS Visual Analytics appears.
2) Click All Reports.
3) Navigate to the Courses/YVA185/Basics/Practices (HR) folder. 4) Double-click the VA1- Practice4.2b report to open it.
c. Add a report prompt that uses a button bar to select the employee type.
1) In the upper right corner, click (Menu) and select Expand report controls.
The report prompt area is shown at the top of the report.
2) In the left pane, click Objects.
3) Drag the Button bar object, from the Controls group, to the Drop a data item or control
to create a report prompt area.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

4) In the right pane, click Roles.
5) For the Category role, select AddEmployee Status.
d. Modify options for the button bar.
1) In the right pane, click Options.
2) In the Object group, for the Name field, enter Employee Status Selector. 3) For the Title field, select Custom title.
4) For the Title field, enter Select an employee status:.
The button bar should resemble the following:
e. Add actions between objects on the Employee Analysis page.
1) If necessary, click the Employee Analysis page to make it active.
2) In the canvas, click the geo map to select it.
3) In the right pane, click Actions.
4) In the Object Links group, select Average Profit by Job Title (the bar chart).
5) Verify that (Filter) is selected.
6) Select Employees and Profit by Anniversary Month (the dual axis bar-line chart).
7) Verify that (Filter) is selected.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The Actions pane should resemble the following:
8) In the canvas, click the bar chart to select it.
9) In the right pane, click Actions, if necessary.
10) In the Object Links group, select Employees and Profit by Anniversary Month (the dual axis bar-line chart).
11) Click (Filter) and select Linked selection.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The Actions pane should resemble the following:
f. On the Profit Analysis page, add a rank to the list table to show the top five employees by Total Profit.
1) Click the Profit Analysis page to make it active.
2) In the canvas, click the list table to select it.
3) In the right pane, click Ranks.
4) IntheRankspane,selectNewrankAllvisiblecategories. 5) Verify that Top count is specified.
6) For the Count field, enter 5.
7) For the By field, verify that Total Profit is specified.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The Ranks pane should resemble the following:
The list table should resemble the following:
g. Save the report.
h. View the report and answer the questions.
1) In the upper left corner, click (View report) to view the report. 2) Answer the questions.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

Which job title has the highest average profit among active employees in Australia?
Answer: Sales Rep. II
• At the top of the report, click the Employee Analysis tab to make the page active.
• In the Employee Status Selector (report prompt), select Active.
• In the geo map, click the AU coordinate.
For SA, which active sales representative had the highest total profit generated for the Indoor Sports group?

• At the top of the report, click the Profit Analysis tab to make the page active.
• In the Employee Status Selector (report prompt), select Active, if necessary.
• In the Company Selector (page prompt), select SA.
• In the bar chart, click the Indoor Sports bar.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

For , how many active sales representatives sold items for the Racket Sports group?
One employee ( )
• At the top of the report, click the Profit Analysis tab to make the page active, if necessary.
• In the Employee Status Selector (report prompt), select Active, if necessary.
• In the Company Selector (page prompt), select .
• In the bar chart, click the Racket Sports bar.
i. In the upper right corner, click (Menu) and select Close to close the report. 4. Working with Hidden Pages and Page Links
a. Open the browser and sign in to SAS Viya. SAS Drive is displayed by default.
b. Open the VA1- Practice4.2c report from the Courses/YVA185/Basics/Practices (HR)
1) In the upper left corner, click (Show list of applications) and select Explore and
Visualize. SAS Visual Analytics appears.
2) Click All Reports.
3) Navigate to the Courses/YVA185/Basics/Practices (HR) folder. 4) Double-click the VA1- Practice4.2c report to open it.
c. Hide Page 3 and rename the page as Employee Details.
1) At the top of the report, click the Page 3 tab to make the page active.
2) Click (Options) and select Hide page.
3) Double-click the Page 3 heading to make it editable. 4) Enter Employee Details and press Enter.
d. Modify options for the hidden page, Employee Details.
1) In the right pane, click Options.
2) In the General group, for the Window width (percentage) field, enter 75. 3) For the Window height (percentage) field, enter 75.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The Options pane should resemble the following:
Add a page prompt to the Employee Details page that uses a slider control to select a range of years of service.
1) On the Employee Details page, click (Options) and select Expand page controls.
2) In the left pane, click Objects.
3) Drag Slider, from the Controls group, to the Drop a data item or control to create a page prompt area.
4) In the right pane, click Roles.
5) For the Measure/Date role, select Add  Years of Service. Modify options for the slider control.
1) In the right pane, click Options.
2) In the Object group, for the Name field, enter Years of Service Selector. 3) For the Title field, select Custom title.
4) For the Title field, enter Select a range of years:.
5) In the Slider group, select Act on aggregated data in filtered objects. 6) In the Minimum field, enter 0.
7) In the Maximum field, enter 45.
8) For the slider control, use the circles to select the entire range of years.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The slider control should resemble the following:
g. Add a page link from the bar chart on the Employee Analysis page to the Employee Details page.
1) At the top of the report, click the Employee Analysis tab to make the page active. 2) In the canvas, click the bar chart to select it.
3) In the right pane, click Actions.
4) On the Actions pane, expand Page Links, if necessary.
5) Click Employee Details.
The Actions pane should resemble the following:
h. Save the report.
i. View the report and answer the questions.
1) In the upper left corner, click (View report) to view the report. 2) Answer the following questions:
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

How many employees retired in Italy with the Sales Rep. III job title?
Two employees ( and Scoditti)
• At the top of the report, click the Employee Analysis tab to make the page active, if necessary.
• In the Employee Status Selector (report prompt), select Retired.
• In the geo map, click the IT coordinate.
• In the bar chart, double-click the Sales Rep. III bar.
The list table contains all of the employees that meet these criteria.
• Click Close to close the Employee Details hidden window.
Management has decided to start promotions with active employees in the United States with the Sales Rep. I job title. Of the active employees with 25 or more years of service, how many generate a total profit more than $200,000?
Five employees
• At the top of the report, click the Employee Analysis tab to make the page active, if necessary.
• In the Employee Status Selector (report prompt), select Active.
• In the geo map, click the US coordinate.
• In the bar chart, double-click the Sales Rep. I bar.
• In the Years of Service Selector, click the circle on the left, enter 25 as the value, and press Enter.
• Click the circle on the right, enter 45 as the value, and press Enter.
• In the list table, click the Total Profit heading twice to sort in
descending order.
• Click Close to close the Employee Details hidden window.
j. In the upper right corner, click (Menu) and select Close to close the report.
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

5. Working with Report-Level and Graph-Level Display Rules
a. Open the browser and sign in to SAS Viya. SAS Drive is displayed by default.
b. Open the VA1- Practice4.3 report from the Courses/YVA185/Basics/Practices (HR) folder.
1) In the upper left corner, click (Show list of applications) and select Explore and Visualize. SAS Visual Analytics appears.
2) Click All Reports.
3) Navigate to the Courses/YVA185/Basics/Practices (HR) folder. 4) Double-click the VA1- Practice4.3 report to open it.
c. Add a report-level display rule for job title.
1) In the right pane, click Rules.
2) In the Display Rules pane, click New rule.
a) In the Rule window, enter Sales Rep I as the first value. b) On the left of the value, click (Select a style).
c) Select Deep blue.
d) Click (Add) and enter Sales Rep II.
e) On the left of the value, click (Select a style).
f) Select Deep blue.
g) Click (Add) and enter Sales Rep III.
h) On the left of the value, click (Select a style). i) Select Deep blue.
j) Click (Add) and enter Sales Rep IV.
k) On the left of the value, click (Select a style).
l) Select Deep blue.
m) Click (Add) and enter Temp. Sales Rep.
n) On the left of the value, click (Select a style).
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

o) Select Deep orange.
p) Click (Add) and enter Trainee.
q) On the left of the value, click (Select a style).
r) Select Deep orange.
s) Click (Add) and enter Purchasing Agent I.
t) On the left of the value, click (Select a style). u) Select Deep orange.
v) Click (Add) and enter Purchasing Agent III. w) On the left of the value, click (Select a style).
Copyright © 2021, the School of ISTM, UNSW Sydney, Australia, USA. ALL RIGHTS RESERVED.

The bar chart should resemble the following:
d. Add three expression display rules to the bar chart on the Profit Analysis page. 1) Click the Profit Analysis page to make it active.
2) In the canvas, click the bar chart to make it active.
3) In the right pane, click Rules.
4) In the Display Rules pane, select New ruleTotal Profit. a) For the Operator field, select < (less than). b) For the Value field 程序代写 CS代考加微信: powcoder QQ: 1823890830 Email: powcoder@163.com

Related Posts