As an analytics developer, you need to produce a different type of output such as Number of crime incidents per zip code, Maximum number of crime incidents, and mean number of crime incidents. You will also use ODS interface to display the output in graphical format.
Step 1: Create a SAS script and read the data from the SQL Table(FinalProjectDataSet – attached)
Step 2: Use PROC NPAR1WAY or any other proc and calculate number of crime incidents per zip code, mean score, Std Dev
Step 3: Determine the police officer count based on the following the logic (image attached).
Step 4: Use ODS interface and generate all the output in graphical format
You need to submit following things as a part of submission.
Output screenshot
SAS Scripts
Sample Solution
