topic Re: Proc means for data that meet two criteria in SAS Procedures

Proc means for data that meet two criteria

ljljlj — Wed, 21 Oct 2020 15:52:05 GMT

Hello, I need to use proc means only for rows that meet two criteria. For example:

pre post dif

1 0 -1

0 4 4

3 2 -1

0 0 0

5 5 0

I'd like to run proc means and exclude the 4th row.

I've tried using "where A ne 0 and B ne 0" and where "A ne 0 or B ne 0" and neither provide the correct output. Any help would be greatly appreciated!

Unsuccessful code:

proc means data=ABC mean sum;

var pre post dif;

where pre ne 0 and post ne 0;

run;

proc means data=ABC mean sum;

var pre post dif;

where pre ne 0 or post ne 0;

run;

Re: Proc means for data that meet two criteria

PaigeMiller — Wed, 21 Oct 2020 16:17:18 GMT

I'd like to run proc means and exclude the 4th row.

	where not (pre eq 0 and post eq 0);

Alternatively

where (pre ne 0) or (post ne 0);

Your last code works for me.

Re: Proc means for data that meet two criteria

ballardw — Wed, 21 Oct 2020 16:15:39 GMT

Provide example output for a given input set and describe why it is incorrect, especially for that second proc means code as @PaigeMiller indicates.