topic PROC FREQ for Fisher EXACT in Statistical Procedures

PROC FREQ for Fisher EXACT

SAS_John — Thu, 25 May 2017 17:14:32 GMT

proc freq data=FISHER; 
	by AEDECOD; 
	where TRTAN in (0,2);
	table TRTAN*EVENT/exact; 
	ods output FishersExact=F1PT(where=(Name1='XP2_FISH'));
run;

Hi,

When I run the above code, it gave me the following message in log "No statistics are computed for TRTAN * EVENT because TRTAN has less than 2 nonmissing levels". Is any way I can get the P-value?

Thanks a lot!

John

Re: PROC FREQ for Fisher EXACT

Reeza — Thu, 25 May 2017 17:17:34 GMT

This seems contradicting to me, is it correctly pulling the data you expect?

where TRTAN in (0,2);

No statistics are computed for TRTAN * EVENT because TRTAN has less than 2 nonmissing levels

Re: PROC FREQ for Fisher EXACT

SAS_John — Thu, 25 May 2017 17:32:18 GMT

Thanks Reeza for the reply. I recheck the table. So the "Where TRTAN in (0, 2)" should be "Where TRTAN in (0, 81)". Then it is ok now