Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Home
- /
- Analytics
- /
- Stat Procs
- /
- 95% confidence intervals

Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

🔒 This topic is **solved** and **locked**.
Need further help from the community? Please
sign in and ask a **new** question.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 09-06-2018 01:43 PM
(4215 views)

Using SAS 9.4

I did a proc freq: to return my descriptive and pvalue statistics. When I run it, it returns:

SAS Output

Statistic DF Value ProbChi-SquareLikelihood Ratio Chi-SquareMantel-Haenszel Chi-SquarePhi CoefficientContingency CoefficientCramer's VWARNING: 100% of the cells have expected counts lessthan 5. Chi-Square may not be a valid test.

SAS Output

Statistic DF Value ProbChi-SquareLikelihood Ratio Chi-SquareMantel-Haenszel Chi-SquarePhi CoefficientContingency CoefficientCramer's VWARNING: 100% of the cells have expected counts lessthan 5. Chi-Square may not be a valid test.

336 | 519.2845 | <.0001 |

336 | 204.4836 | 1.0000 |

1 | . | . |

1.6532 | ||

0.8556 | ||

0.8266 |

Fisher's Exact TestTable Probability (P)

<.0001 |

Monte Carlo Estimate for the Exact TestPr <= P99% Lower Conf Limit99% Upper Conf Limit Number of SamplesInitial Seed

0.0338 |

0.0291 |

0.0385 |

10000 |

30061001 |

Sample Size = 190 |

For my confidence intervals, they are default at 95%. Does SAS automatically convert my CIs to 99% if the pvalue is less than that level? If so, is their any way to return it at the 95% CI level as the rest of my results are at the 95% CI level? Thank you

code for my proc freq:

proc freq data = RAW.PRESENTS_04SEPT2018 (where=(used_recommendation ne 'N/A'));

tables insurance_status_at_testing*hh_inc_med/list missing nocum;

title 'Insurance status at testing pvalue';

exact fisher /mc;

run;

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

You probably didn't set it in the right place.

Try this:

```
proc freq data = sashelp.heart ;
tables status*chol_status/list missing nocum;
exact fisher /mc
```**alpha=0.05**;
run;

@GS2 wrote:

What if alpha=0.05 does not work I guess should have been my question. I tried to set that and it still report it as a 99% CI

3 REPLIES 3

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Default is Alpha=0.05 (95% confidence interval)

use the ALPHA= option to set the desired level on the TABLES statement. If you want a 99% interval use ALPHA=0.01.

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

You probably didn't set it in the right place.

Try this:

```
proc freq data = sashelp.heart ;
tables status*chol_status/list missing nocum;
exact fisher /mc
```**alpha=0.05**;
run;

@GS2 wrote:

**Don't miss out on SAS Innovate - Register now for the FREE Livestream!**

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.