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.
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;
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;
Thank you Tom, this is very helpful.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.