DATA Step, Macro, Functions and more

proc report not missing value?

Reply
Super Contributor
Posts: 394

proc report not missing value?

Hello:

 

I would like to only PROC REPORT the non-missing value.  But it didn't work when I remove the missing option below.  How to fix it?

 

proc report data=test list headline headskip missing;
	column Class name component product;
	define Class /group width=150 left;
	define name /group width=150 left; 
	define component /group width=150 left;
	define product /group width=150 left; 
run;
Super User
Posts: 23,323

Re: proc report not missing value?

Add a WHERE statement to filter out what you want to exclude.

 


ybz12003 wrote:

Hello:

 

I would like to only PROC REPORT the non-missing value.  But it didn't work when I remove the missing option below.  How to fix it?

 

proc report data=test list headline headskip missing;
	column Class name component product;
	define Class /group width=150 left;
	define name /group width=150 left; 
	define component /group width=150 left;
	define product /group width=150 left; 
run;

 

Valued Guide
Posts: 523

Re: proc report not missing value?

Sorry, i don't work for the NSA and can't look into your computer to see the data you used, and i - shame on me - even can't read your mind, so i don't have any idea what you expected to get from running proc report.

Super Contributor
Posts: 394

Re: proc report not missing value?

Posted in reply to andreas_lds

proc report data=test list headline headskip missing;
column Class name component product;
define Class /group width=150 left;
define name /group width=150 left;
define component /group width=150 left;
define product /group width=150 left;
run;

Super Contributor
Posts: 394

Re: proc report not missing value?

It would be annoying if I have to put where state in each define column cause every time I would like to change different variable names.

Super User
Posts: 23,323

Re: proc report not missing value?


ybz12003 wrote:

It would be annoying if I have to put where state in each define column cause every time I would like to change different variable names.


Cleaning up the data before reporting is a pretty standard step and there are multiple ways to specify that you want all variables of a type to have non missing. Those approaches should be within your current skill set. 

 

You also haven't really shown what you want or have so we're going off your code so far, general questions get general answers. The drill hasn't changed Smiley Happy

Ask a Question
Discussion stats
  • 5 replies
  • 96 views
  • 0 likes
  • 3 in conversation