Where statement in proc means

yael — Wed, 29 Mar 2017 06:28:12 GMT

Hello,

I have the following code:

proc means data=sasuser.sasfile010916 mean median std min max;
where firmdefi=1 and firmdefi=2;
var equity TAssets Sales;
class firmdefi;
run;

The log indicate NOTE: No observations were selected from data set SASUSER.SASFILE010916.

There is data that relate to firmdefi 1 or 2 and I do not understand what is my mistake?

Thanks for any help!!!

Re: Where statement in proc means

Astounding — Wed, 29 Mar 2017 06:33:17 GMT

Logically, it is not possible for FIRMDEFI to equal 1 and 2 at the same time. Instead of using AND, your WHERE statement could switch to OR. Alternatively:

where firmdefi in (1, 2);

topic Re: Where statement in proc means in Statistical Procedures

Where statement in proc means

Re: Where statement in proc means