Determine the Number of Violent Crimes by Year

On the SAS tab, click Tasks.

In the Tasks window, select 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.

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(),TIMEAMPM12.)).