topic Re: Proc Report with 2 Missing Variables in SAS Programming

Proc Report with 2 Missing Variables

akordula — Tue, 06 Feb 2018 16:05:56 GMT

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;

Re: Proc Report with 2 Missing Variables

HB — Tue, 06 Feb 2018 16:52:21 GMT

I would think you would need to code the "missing" values differently. Perhaps a '999' in one data set and a '.' in the other.

Re: Proc Report with 2 Missing Variables

akordula — Tue, 06 Feb 2018 18:01:04 GMT

That would work for me, but then I would need to exclude 999 from the count, percentage etc. Is there a way to exclude a certain value?

Re: Proc Report with 2 Missing Variables

ballardw — Tue, 06 Feb 2018 19:26:35 GMT

Have you tried removing MISSING from the Proc statement and adding it to DEFINE options for Y (and any other variables that may want missing to appear)?

Re: Proc Report with 2 Missing Variables

akordula — Tue, 06 Feb 2018 19:31:11 GMT

This worked, thank you!!!