PROC FREQ for Fisher EXACT

[SAS_John]

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

[Reeza · Accepted solution]

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

[SAS_John]

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