topic Re: proc report not missing value? in SAS Programming

proc report not missing value?

ybz12003 — Tue, 20 Feb 2018 16:22:23 GMT

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;

Re: proc report not missing value?

Reeza — Tue, 20 Feb 2018 17:02:23 GMT

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;

Re: proc report not missing value?

andreas_lds — Tue, 20 Feb 2018 17:03:38 GMT

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.

Re: proc report not missing value?

ybz12003 — Tue, 20 Feb 2018 17:11:12 GMT

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;

Re: proc report not missing value?

ybz12003 — Tue, 20 Feb 2018 17:14:44 GMT

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.

Re: proc report not missing value?

Reeza — Tue, 20 Feb 2018 18:35:16 GMT

@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 🙂