Hi,
I have a strange behavior in proc report when using formatted across columns.
When I run proc report without the missing statement (as below), I get the correct output in that my hospitals are listed in the proper order, and then the group 'Other' catches the remaining hospitals (see below). When I use the missing statement, the 'Other' group comes first, and I would like it to come last in the list.
proc format ;
value $across_inpatient (notsorted)
'1'='H1'
'2'='H2'
'3'='H3'
'4'='H4'
Other = 'Other';
;run;
ods html;
proc report data= inpatient_join3 nowd ;
column closest_hospital tx_hospital real_separations , sum ;
define tx_hospital/ group across "Treatment Site" order=internal Center format= $across_inpatient. ;
define closest_hospital/ group order=internal format=bri_inpatient. "Closest Hospital" left;
define real_separations/ analysis sum format=comma12.0 '' center;
define sum / "Total" center format=comma12.0 center;
rbreak after / summarize ;
run;
ods html close;
Without Missing:
Closest Hospital H1 H2 H3 H4 Other
With Missing :
Closest Hospital Other H1 H2 H3 H4
How can this be fixed.
Thanks,