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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!