Programming the statistical procedures from SAS

PROC FREQ and non-integer frequencies

Accepted Solution Solved
Reply
Contributor
Posts: 57
Accepted Solution

PROC FREQ and non-integer frequencies

Hi,

I would like to perform Chi-square and Fisher exact test on a simple contingency table. If I use for instance the following code:

data yesno;

    input gender $ numyes total;

    response="Yes"; count=numyes;       output;

    response="No "; count=total-numyes; output;

    datalines;

  Men   0 100

  Women 45.2 100

  ;

 

proc freq data=yesno;

  weight count;

  table gender * response / chisq fisher;

run;

I obtain the following "WARNING: Fisher's exact test is not computed because of non-integer frequencies."

Do you have an idea how to proceed?

Thanking you in advance for your answer.

Best,


Accepted Solutions
Solution
‎04-30-2013 11:08 AM
Super User
Posts: 18,580

Re: PROC FREQ and non-integer frequencies

For a true comparison you need the true denominator, not 100.

View solution in original post


All Replies
Super User
Posts: 18,580

Re: PROC FREQ and non-integer frequencies

Well, the log is correct, you can't have a decimal in contingency tables, because they're counts.

Can you explain some more about what you're trying to do?

It looks like you have 2 percentages and want to compare them, so you've put them over 100. You could put it out of 1000 to remove the decimal but that can change the results.

Contributor
Posts: 57

Re: PROC FREQ and non-integer frequencies

Hi Reeza, thanks for your prompt reply. To be more precise, I try to compare two (or more) percentages. A more concrete case. I have the following percentages to compare: 7.5, 6.2, 5.3 and 9.9.

Solution
‎04-30-2013 11:08 AM
Super User
Posts: 18,580

Re: PROC FREQ and non-integer frequencies

For a true comparison you need the true denominator, not 100.

Super User
Posts: 9,775

Re: PROC FREQ and non-integer frequencies

Did you mean

weight total ;

Ksharp

Contributor
Posts: 57

Re: PROC FREQ and non-integer frequencies

Thanks a lot for your answer!

@Ksharp: it is well "weight count";

🔒 This topic is solved and locked.

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

Discussion stats
  • 5 replies
  • 639 views
  • 3 likes
  • 3 in conversation