To determine
the number of violent crimes by year, create a bar chart.
-
On the
SAS tab,
click
Tasks, and then select
Graph
Bar Chart Wizard. The
Choose Data dialog
box appears.
-
To use the sorted data
as your input data source, select
SAS Data in Excel.
In this example, the location is
SASApp:SASDATA.SORTED_CRIME_DATA
(SASDATA.SORTED_CRIME_DATA!A1:H21).
-
For the location of
the results, select
New worksheet. By default,
the name of the new worksheet is Bar Chart Wizard. Rename this worksheet
Bar
Chart.
Click
OK.
The Bar Chart Wizard appears.
-
In the Verify Data step,
verify that SORTED_CRIME_DATA is the input data source, and then click
Next.
-
In the Assign variables
to roles step, select
Violent crime from the
Bar
height list, and then click
Next.
-
In the Specify appearance
step, click
Axis Labels. The
Axis
Labels dialog box appears. In the
Bar height field,
change the label to
Total Number of Offenses.
-
In the Specify appearance
step, select the
Use reference lines check
box, and then click
Next.
-
In the Provide a title
and footnote step, enter
Number of Violent Crimes
by Year as the title of the graph. Change the
footnote to
Updated %TRIM(%QSYSFUNC(DATE(),NLDATE20.))
at %TRIM(%SYSFUNC(TIME(),NLTIMAP20.)).
When the
Preview dialog
box appears, click
Insert All. All of the
results that were generated by the Bar Chart Wizard appear in the
new Bar Chart worksheet.
