topic Re: Using proc report to transpose a table in SAS Procedures

Using proc report to transpose a table

brokenpc1 — Sun, 02 Jul 2023 17:34:37 GMT

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.

Re: Using proc report to transpose a table

Tom — Sun, 02 Jul 2023 18:07:48 GMT

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;

Re: Using proc report to transpose a table

brokenpc1 — Tue, 04 Jul 2023 13:48:50 GMT

Thank you Tom, this is very helpful.