Question: Write a SAS program to print the following using the permanent data set HW1. (i)For each region, how many salesman are in each state, what
Write a SAS program to print the following using the permanent data set HW1.
(i)For each region, how many salesman are in each state, what are the advertising expenses for each state (in ascending order), and what is the total advertising expenses for the region.
(ii) How many states were visited 1,2,3,4, and 5 times by their regional manager?
The following is a data set we need to use in this question.
| Obs | state | region | visits | salesman | sale | expenses |
|---|---|---|---|---|---|---|
| 1 | Delaware | Northeast | 1 | 1 | 120000 | 1000 |
| 2 | Maine | Northeast | 2 | 1 | 300000 | 1000 |
| 3 | New Hampshire | Northeast | 2 | 2 | 290000 | 1000 |
| 4 | Rhode Island | Northeast | 1 | 1 | 180000 | 1000 |
| 5 | Vermont | Northeast | 2 | 2 | 280000 | 1000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
