Hi, I have the following data set. data teams;
input
team $5. wins group $5.;
format
team $5.;
datalines;
TeamA 10 West
TeamA 15 West
TeamA 32 West
TeamB 2 West
TeamB 17 West
TeamB 5 West
; I am using proc report to transpose the team names and grouping them by group. I am using the following code below. proc report nowd data=teams
style(header)=[background=white];
col (group (('Teams' team),(wins)));
define group/ "Group";
define team / across style (header)=[background=lightblue] ' ' ;
define wins / "Wins";
run; When I run the code I get the following result below: West 10 . West 15 . West 32 . West . 2 West . 17 West . 5 I am trying to figure out what I am missing here, I want to group both teams by group, so that the end result would look like below. West 10 2 West 15 17 West 32 5 Any help would be greatly appreciated! Thanks!! Edited: I was able to figure it out later and wanted to keep to post for others if further reference is needed. Adding group in the line solves the problem proc report nowd data=teams
style(header)=[background=white];
col (group division (('Teams' team),(wins)));
define group/ group "Group";
define division/ group "Div";
define team / across style (header)=[background=lightblue] ' ' ;
define wins / "Wins";
run;
... View more