DATA Step, Macro, Functions and more

Proc Report with 2 Missing Variables

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Proc Report with 2 Missing Variables

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;


Accepted Solutions
Solution
‎02-06-2018 02:31 PM
Super User
Posts: 13,292

Re: Proc Report with 2 Missing Variables

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)?

View solution in original post


All Replies
Super Contributor
Super Contributor
Posts: 266

Re: Proc Report with 2 Missing Variables

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

Occasional Contributor
Posts: 10

Re: Proc Report with 2 Missing Variables

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?

Solution
‎02-06-2018 02:31 PM
Super User
Posts: 13,292

Re: Proc Report with 2 Missing Variables

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)?

Occasional Contributor
Posts: 10

Re: Proc Report with 2 Missing Variables

This worked, thank you!!!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 79 views
  • 0 likes
  • 3 in conversation