turn on suggestions

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

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- General Programming
- /
- Significance level at 1% 5% 10%

Topic Options

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-21-2015 02:14 PM

Hi there, i would like to have the different level of significance reported in my regression results. How do i do this stata? The second question is how do i report my regression results in Excel organised format.

Accepted Solutions

Solution

04-26-2017
08:49 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-22-2015 08:35 AM - last edited on 04-26-2017 08:49 AM by ChrisHemedinger

In statistics, you decide on the significance level BEFORE you run the analysis, and then you see if the data confirms or rejects various hypotheses at that significance level. It is considered "cheating" to run an analysis and then decide on the significance level after you see the results.

That said, in many procedures the p-values are reported as numbers like 0.0432. That number is significant at the 0.05 level, but not significant at the 0.01 level. For example, the parameter estimates table in PROC REG report p-values for the hypothesis that parameters are significantly different from 0.

@ivanpersie wrote:

Hi Rick, because am replicating a previous study and they used t statistics. So i was wondering in SAS. how i tell the significance level for the t statistics rather than p value

Assuming that you know the degrees of freedom (DOF), you can use the QUANTILE function to invert the p-values to get the corresponding t-statistics:

```
data Signif;
dof = 20;
do alpha = 0.01, 0.05, 0.1;
t = quantile("t", 1-alpha, dof);
output;
end;
run;
proc print; run;
```

All Replies

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-21-2015 03:33 PM

But these are not Stata forums.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-21-2015 03:35 PM

Having no idea what "Excel organized format" might mean it is hard to answer that.

In SAS most procedures have an option of ALPHA= that control the significance level which usually defaults to 5%. How/where the option should be applied depends on the procedures. Often it goes on the procedure statement.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-21-2015 10:54 PM

Yes i would like to report significance levels at 0.01 0.05 and 0.1 in the Proc reg statement. Is that possible

Solution

04-26-2017
08:49 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-22-2015 08:35 AM - last edited on 04-26-2017 08:49 AM by ChrisHemedinger

In statistics, you decide on the significance level BEFORE you run the analysis, and then you see if the data confirms or rejects various hypotheses at that significance level. It is considered "cheating" to run an analysis and then decide on the significance level after you see the results.

That said, in many procedures the p-values are reported as numbers like 0.0432. That number is significant at the 0.05 level, but not significant at the 0.01 level. For example, the parameter estimates table in PROC REG report p-values for the hypothesis that parameters are significantly different from 0.

@ivanpersie wrote:

Hi Rick, because am replicating a previous study and they used t statistics. So i was wondering in SAS. how i tell the significance level for the t statistics rather than p value

Assuming that you know the degrees of freedom (DOF), you can use the QUANTILE function to invert the p-values to get the corresponding t-statistics:

```
data Signif;
dof = 20;
do alpha = 0.01, 0.05, 0.1;
t = quantile("t", 1-alpha, dof);
output;
end;
run;
proc print; run;
```

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-22-2015 08:26 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-23-2015 05:53 AM

Assuming that you know the degrees of freedom (DOF), you can use the QUANTILE function to invert the p-values to get the corresponding t-statistics:

data Signif;

dof = 20;

do alpha = 0.01, 0.05, 0.1;

t = quantile("t", 1-alpha, dof);

output;

end;

run;

proc print; run;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

04-22-2015 09:14 AM

Your significance levels are 0.01, 0.05, and 0.1. Your p-value is what you report.

IN comparing the p-value to a significane level you can determine if a result is significant.

As Rick explained above, the significance level is chosen ahead of time. 0.05 is commonly used in medicine, while 0.2 might be great in marketing.