I have a dataset with columns like: | ||||
displayColumn | _2014_15 | _2014_15b | _2015_16 | _2015_16b |
Demo Row | 1 | 0.5 | 2 | 0.34 |
I'm trying to display the data set like this with proc report. Please advise. | ||||
displayColumn | 2014-15 | 2015-16 | ||
displayColumn | _2014_15 | _2014_15b | _2015_16 | _2015_16b |
Demo Row | 1 | 0.5 | 2 | 0.34 |
Starting data
proc sql;
CREATE TABLE have (
displaycolumn varchar2,
col1 int,
col2 DECIMAL(10,2),
col3 int,
col4 DECIMAL(10,2)
);
insert into have (displaycolumn, col1, col2, col3, col4) values ("demo column", 1, .5, 2, .75);
quit;
I have the display
proc report data=have;
column displaycolumn col1 col2 col3 col4;
define displaycolumn / group;
define col1 / analysis sum '2014-15' format=comma9.;
define col2 / analysis sum '2015-16' format=percent8.1;
define col3 / analysis sum '2014-15 %' format=comma9.;
define col4 / analysis sum '2015-16 %' format=percent8.1;
run;
Hi:
proc report data=sashelp.class;
column ('Top Header' ('One Header' name sex) ('Other Header' age height weight));
run;
Hope this helps,
Cynthia
You can add extra headers over groups of columns in the COLUMN statement.
Extra headers will solve it. I'm searching for an example of extra headers.
Hi:
proc report data=sashelp.class;
column ('Top Header' ('One Header' name sex) ('Other Header' age height weight));
run;
Hope this helps,
Cynthia
Thanks your solution is easy.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.