I'm trying to run a proc report on a dataset that can have missing values (valid) in two columns (x & y), both of which are grouped. Is there a way to NOT show missing values from x, but to still show missing values from y in the report? The missing option either shows all of them or takes them all away, which I don't want.
Example:
title BOLD HEIGHT=4 'US'; proc report data=us.rates missing; columns x y date,(n pctn) ; define x/ group 'x' width = 5; define y / group 'y' width = 3; define dumcol / computed 'x'; define date / across order = internal; define n / format =8. 'COUNT'; define pctn / "%" format = percent7.1; rbreak after / summarize; compute dumcol / char length = 10; if _BREAK_ = '_RBREAK_' then dumcol = 'Total'; else dumcol = put(x,$10.); endcomp; run; title;
... View more