11 chapter 3: getting started with tasks 3.1 introduction to tasks and wizards 3.2 creating a...
TRANSCRIPT
11
Chapter 3: Getting Started with Tasks
3.1 Introduction to Tasks and Wizards3.1 Introduction to Tasks and Wizards
3.2 Creating a Frequency Report
3.3 Generating HTML, PDF, and RTF Output
3.4 Creating a Graph
2
Objectives Define a SAS Enterprise Guide task and wizard. Name one method of accessing tasks in
SAS Enterprise Guide. State the functions of common features in the task
dialog boxes.
2
3
What Is a Task?A task is a specific type of analysis, report, or data manipulation that you can perform against data in a project.
A task is typically referenced by its description.
3
44
5
3.01 QuizSelect the Tasks menu in your SAS Enterprise Guide session. Which tasks might be the most helpful in working with your data?
5
6
Associating a Task with DataTasks are usually associated with a particular data source in the project.
6
1.Highlight the data in the Project Tree.
2. Selecta task.
7
Associating a Task with DataTasks can also be selected from the menu in the Data Grid.
7
8
Tasks: Selection PaneEach task dialog box follows a similar format that includes a Selection pane that lists the options available for that task.
8
Selection Pane
9
Tasks: DataSelect Data to assign variables to Task roles. Task roles define how the data is used to create the task result.
9
Help is displayedwhen a Task role
is selected.
10
Tasks: Titles and FootnotesSelect Titles to add descriptive titles and footnotes.
10
Type customtitles or
footnotes.
11
Tasks: PropertiesTask properties can be modified to rename the task, examine task attributes, and modify the output format.
11
12
Task WizardsSelected tasks have a wizard format that can be used to set up the task results quickly.
12
13
Working with Tasks
13
Task code, log, output data, and results are available for viewing and further analysis through tabs and menus.
14
Working with Tasks
14
Tasks can be refreshed or modified from either the Project Tree, Process Flow, or the Results tab.
1515
1616
Chapter 3: Getting Started with Tasks
3.1 Introduction to Tasks and Wizards
3.2 Creating a Frequency Report3.2 Creating a Frequency Report
3.3 Generating HTML, PDF, and RTF Output
3.4 Creating a Graph
17
Objectives Access the One-Way Frequencies task. Generate a one-way frequency report and bar chart.
17
18
Business ScenarioOrion management wants a report that counts the number of products offered for each category.
18
19
One-Way Frequencies TaskThe One-Way Frequencies task can be used to generate frequency counts, percentages, graphs, and statistical tests to analyze the distribution of your data.
19
2020
21
3.02 Multiple Choice PollHighlight any data source in the project and select Tasks Describe One-Way Frequencies. Which task role requires a variable assignment?
a. Analysis variables
b. Frequency count
c. Group analysis by
21
22
3.02 Multiple Choice Poll – Correct AnswerHighlight any data source in the project and select Tasks Describe One-Way Frequencies. Which task role requires a variable assignment?
a. Analysis variables
b. Frequency count
c. Group analysis by
22
23
One-Way Frequencies: Task RolesThe One-Way Frequencies task produces a one-way frequency report for each variable included in the Analysis variables role.
.
23
24
One-Way Frequencies: Task RolesThe Group analysis role can be used to produce separate frequency reports for each unique value of a variable.
24
2525
26
3.03 QuizOpen the One-Way Frequencies task again by selecting Tasks Describe One-Way Frequencies. In the Tasks Roles window, select Help and read the description for the Frequency count role.
How many variables can be assigned to this role?
26
27
3.03 Quiz – Correct AnswerOpen the One-Way Frequencies task again by selecting Tasks Describe One-Way Frequencies. In the Tasks Roles window, select Help and read the description for the Frequency count role.
How many variables can be assigned to this role?
1
27
28
One-Way Frequencies: Additional OptionsUse additional options to customize the report or create a data set with frequencies and percentages.
28
29
Generating a One-Way Frequency Report
Orion managers want a report that summarizes the number of products offered for each category.
29
3030
Chapter 3: Getting Started with Tasks
3.1 Introduction to Tasks and Wizards
3.2 Creating a Frequency Report
3.3 Generating HTML, PDF, and RTF Output3.3 Generating HTML, PDF, and RTF Output
3.4 Creating a Graph
31
Objectives List output format options. Compare the advantages of each output format.
31
32
Business ScenarioOrion management wants to publish, in an HTML format on the intranet, the frequency report for product categories.
32
33
Task Output FormatsBy default, SAS Enterprise Guide produces task results in SAS Report format. However you can also choose to generate HTML, PDF, RTF, or text output.
33
34
SAS Report FormatThe SAS Report format enables you to combine multiple task results into a single report. This report can be viewed in SAS applications or exported as HTML, XML, or PDF files.
34
Banner image
Bar Chart task
One-WayFrequencies task
SummaryStatistics task
3535
36
3.04 Multiple Answer PollWhich output formats would you like to use in your work?
a. HTML
b. PDF
c. RTF
d. SAS Report
e. Text
36
37
3.05 QuizWhat are some advantages of each format?
37
38
3.05 Quiz – Correct AnswerWhat are some advantages of each format? HTML can be easily viewed by anyone who has a
browser. RTF can be included and edited in common word
processors. PDF is a good choice for printing and sharing static
copies of the report. SAS Report format is useful when you combine task
results or create reports to be viewed in other SAS applications.
Text is simple and familiar if you use the SAS Display Manager.
38
39
Summary of Output Formats
39
HTML RTF PDF SAS Report
Text
Software required for viewing outside of SAS Enterprise Guide
Any browser (Internet Explorer)
Any word processor(Microsoft Word)
Adobe Reader
Other SAS applications
Any text viewer (Notepad)
Ability to combine results into a single document
Yes (Tools HTML Document)
No
(Only with code)
No
(Only with code)
Yes (File New Report)
No
(Only with code)
Ability to edit results in viewing software
No Yes No Yes Yes
Results formatted for printing
No Yes Yes Yes Yes
40
Default Output FormatThe default output format can be set under Tools Options Results General. Custom options can also be set for each of the output formats.
40
41
Overriding the Default Output FormatThe properties of individual tasks can be modified to override the default format and produce other types of results.
41
42
Modifying Output Format
This demonstration illustrates modifying the properties of a task to produce HTML, PDF, RTF, or text output.
42
4343
Chapter 3: Getting Started with Tasks
3.1 Introduction to Tasks and Wizards
3.2 Creating a Frequency Report
3.3 Generating HTML, PDF, and RTF Output
3.6 Creating a Graph3.6 Creating a Graph
44
Objectives Name the types of graphs supported in
SAS Enterprise Guide. State the differences among the output formats that
are supported in SAS Enterprise Guide. Create a bar chart.
44
45
Business ScenarioTo better understand the demographics of the Orion Star customers, management wants to see a comparison of average customer age by country.
45
46
Graphs Using SAS Enterprise Guide
46
47
Types of GraphsThe Graph menu includes all of the advanced graph tasks as well as the wizards.
47
48
Output Formats for GraphsDifferent graph formats enable you to produce interactive and non-interactive results.
48
ActiveX andJava, bothinteractiveand image files
GIF, JPG,and PNG
EnhancedMetafile(EMF)
4949
50
3.08 Multiple Answer PollWhich types of graphs would you like to use to display your data?
a. Bar chart
b. Pie chart
c. Line plot
d. Scatter plot
e. Surface plot
f. Map
g. Other
50
51
Bar Chart WizardThe Bar Chart wizard enables you to do the following:
1.select and filter the data
2.assign variables to roles
3.customize appearance
4.set titles and footnotes
51
5252
53
3.09 QuizAn example of a graph created with the Bar Chart wizard is shown below. What would you like to modify to further enhance the display?
53
54
3.09 Quiz – Correct AnswerPossible modifications include the following:rounding values to the nearest dollarchanging the output formatadding more descriptive axis labelschanging the shapeof the barsusing fewer reference lines
54
55
Bar Chart: Advanced ViewTo make further enhancements to the graph, you might need to open the task in Advanced View, which gives you access to additional options that are not available in the wizard.
After you run a task in Advanced View, you cannot switch back to the wizard.
55
56
Bar Chart Task: Advanced ViewThe Advanced View of the Bar Chart task includes additional options, such as changing bar shape, formatting data values, and modifying reference lines.
56
5757
58
Setup for the Poll1. Open any data source in the project and select
Graph Bar Chart Wizard….
2. In step 2, choose any column for the Bars role and select Finish.
3. In the Project Tree or Process Flow, right-clickon the Bar Chart task icon and select Open Open in Advanced View….
58
59
3.10 Multiple Choice PollWhich item from the Selection pane enables you to define custom colors for each of the bars?
a. Bar Chart
b. Bars
c. Layout
d. Advanced
59
60
3.10 Multiple Choice Poll – Correct AnswerWhich item from the Selection pane enables you to define custom colors for each of the bars?
a. Bar Chart
b. Bars
c. Layout
d. Advanced
60
61
Bar Chart Task: Final Results
61
62
Creating a Bar Chart
This demonstration illustrates howto use the Bar Chart task to create a graph.
62