Is there a simple way to transpose the output of proc report in version 9.4? I have a simple proc report output that I have to generate several times for different individuals. It's a table with 4 columns and 2 rows. However, for the sake of fitting it nicely into my report, I would like to know if there is a way I can manipulate proc report to transpose this table to be 2 columns and 4 rows, like the attached photo. DATA have; input rate pooled goal cad sig; datalines ; 0.71 1.09 0.70 1.2 3 ; run; proc report data=have missing nowd headskip headline split='\' /*Set the color/text style elements for the table*/ style(report)={rules=none frame=hsides borderspacing=0} style(header)={borderwidth=0 borderspacing=0 background=CXE1E1E1 foreground=black font_face=arial font_weight=bold font_size=9pt } style(column)={borderwidth=0 borderspacing=0 background=CXEDEDED foreground=black font_face=arial font_size=9pt }; /*Identify the variables that will appear/are referenced in the table, and create any headers that span more than one variable*/ column sig rate pooled goal cad ; /*Create header labels for each variable, set column widths and alignment*/ define rate / order center "Facility SIR" style(column)=[width=.72in vjust=middle]; define pooled / display center "Group Pooled SIR" style(column)=[width=.8in vjust=middle] ; define goal / display "HHS 2020 Goal" center style(column)=[width=.72in vjust=middle]; define cad / display "Need to Prevent" center style(column)=[width=.72in vjust=middle]; define sig / display noprint; compute rate; if sig="1" then call define(_col_,"style", "style=[font_size=10pt fontweight=bold color=gray]"); else if sig="2" then call define(_col_,"style", "style=[font_size=10pt fontweight=bold color=red]"); else if sig="3" then call define(_col_,"style", "style=[font_size=10pt fontweight=bold color=green]"); else if sig="4" then call define(_col_,"style", "style=[font_size=10pt fontweight=bold color=black]"); endcomp; run;
... View more
