SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ivanpersie
Fluorite | Level 6

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Rick_SAS
SAS Super FREQ

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;

 

View solution in original post

7 REPLIES 7
PaigeMiller
Diamond | Level 26

But these are not Stata forums.

--
Paige Miller
ballardw
Super User

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.

ivanpersie
Fluorite | Level 6

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

Rick_SAS
SAS Super FREQ

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;

 

ivanpersie
Fluorite | Level 6

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

Rick_SAS
SAS Super FREQ

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;

Reeza
Super User

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.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 39868 views
  • 1 like
  • 5 in conversation