Programming the statistical procedures from SAS

PROC FREQ for Fisher EXACT

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

PROC FREQ for Fisher EXACT

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

 


Accepted Solutions
Solution
‎05-25-2017 01:32 PM
Super User
Posts: 18,569

Re: PROC FREQ for Fisher EXACT

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

 

 

View solution in original post


All Replies
Solution
‎05-25-2017 01:32 PM
Super User
Posts: 18,569

Re: PROC FREQ for Fisher EXACT

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

 

 

Contributor
Posts: 20

Re: PROC FREQ for Fisher EXACT

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 161 views
  • 0 likes
  • 2 in conversation