I have had preloadfmt and completerows working, but not in the style that I want. I was originally trying to get the same result, but with a single format like this: proc format;
value scoref_orig
500-501 = "500-501"
502-503 = "502-503"
504-505 = "504-505"
506-507 = "506-507"
508-509 = "508-509"
510-511 = "510-511"
512-513 = "512-513"
. = "."
0 = "0"
;
run;
title "Overall";
proc report data=temp missing completerows;
column unscorable score i bad;
define unscorable / group noprint;
define score / group "Score" format=scoref_orig. preloadfmt;
define i / analysis sum "#";
define bad / analysis sum "# Bad";
break after unscorable / ol ul summarize;
rbreak after / ol ul summarize;
run; This worked, but it preloads the entire format for both unscorable = 1 and unscorable = 0. I would like just the values of unscf to be present when unscorable = 1. If the same result could be achieved using a single format that would be ideal, but it seemed to me that splitting up the format and applying it separately might be easier to start.
... View more