Using proc report to transpose a table

[brokenpc1]

Hi everyone,

I am relatively new to using proc report to generate reports. I am now stuck with a report that requires transposing multiple columns and would really appreciate your help.

The original dataset I have in SAS is like the following:

Ideally, I would like to make a report in the following way:

If we ignore the format, I have two questions regarding this report:

1. How do I put the vehicle type at the top of sales/cost/profit?

2. How do I group by manager name?

Thank you very much for your help.

[Tom · Accepted solution]

Use a comma in the COLUMN statement.

column region manager vehicle,(sales cost profit);

REGION and MANAGER are GROUP variables.  Vehicle an ACROSS variable.   

define region / group;
define manager / group;
define vehicle / across;

[brokenpc1]

Thank you Tom, this is very helpful.