That helped group the graphs. For the Data table, how do I group the code below by sales, highest to lowest: PROC REPORT DATA=salesByProductByDate NOWD; COLUMN ('Sales' year month) product,(sales); DEFINE year / GROUP STYLE (header)={background=lightgreen}; DEFINE month / GROUP STYLE (header)={background=lightgreen}; DEFINE product / ACROSS ' ' STYLE(header)={background=lightyellow}; DEFINE sales / SUM STYLE(header)={background=lightyellow} FORMAT=DOLLAR15.2; BREAK AFTER year /SUMMARIZE DOL DUL; RBREAK AFTER/SUMMARIZE; COMPUTE AFTER year; CALL DEFINE('year','style','style=Header{pretext="SubTotal " tagattr="Type:String"}'); ENDCOMP; COMPUTE AFTER; CALL DEFINE('year','style','style=Header{pretext="Grand Total " tagattr="Type:String"}'); ENDCOMP; RUN; It only goes by month 1-12, the sales are different each month and I want to have the top selling month at the top (for each year) and the lowest selling month at the bottom. I tried grouping that and the data table disappears when I run it, without errors/warnings.
... View more
