I'm getting an expected result when I run the following code. The first three (non-hidden) columns are group variables so I was expecting the output to only print the first value of the group variable on the first row of the report. However, it's repeating the value for all of the rows (i.e., "age at first service" is on rows 1-5 instead of just row 1). Notice, the first three (hidden) columns are being used just to order the data in the output and create sub groups. Proc print and sample report attached here. Note, I removed the actual data (statistics) for proprietary reasons. Thanks. proc report data=supp.d12a_supp nowd missing out=outtest; column cat_order grp_order grp_order2 cat_char grp_char grp_char2 last_mod,stat; define cat_order / group order=data noprint; define grp_order / group order=data noprint; define grp_order2 / group order=data noprint; define cat_char / group "" format=$60. left; define grp_char / group "" format=$25. left; define grp_char2 / group "" format=$25. left; define last_mod / group across "" order=data format=$20. Center style(header)={Just=C}; define stat / "" sum format=DecimalFmt. style(column)=[tagattr="format:%quote(#,##0.0)"] right; run;
... View more
