BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
acironin
Calcite | Level 5

Hello,

 

When I run proc syslin and include stest, the test result output includes: Num DF, Den DF, F Value, Pr>F. These are useful, but I also need the specific numerator (Model MS) and denominator (Error MS) values that are used to calculate the F-value (=num/denom). How can I get these numerator and denominator values displayed?

 

Thank you very much in advance.

Best regards,

Can (John)

 

PS: FYI, the stest code and the out I get are below:

STEST rco1.rco2LAG1=0, rco1.rco2LAG2=0, rco1.rco2LAG3=0, rco1.rco2LAG4=0;

SAS Output

Num DF Den DF F Value Pr > F
4 1705473 19.22 0.0001
1 ACCEPTED SOLUTION

Accepted Solutions
dw_sas
SAS Employee

Hi Can,

 

Although PROC SYSLIN does not directly provide the numerator and denominator values associated with the F statistic, you can add the PRINT option to the STEST statement to obtain the intermediate computations.  Matrix multiplication in SAS/IML can then be used to compute the numerator of the F statistic.  The denominator is computed as the number of restrictions*system weighted MSE, where the number of restrictions is equal to the Numerator DF, and the system weighted MSE is part of the printed output of the procedure.  Please see the following documentation link for additional details:

 

http://support.sas.com/documentation/cdl/en/etsug/68148/HTML/default/viewer.htm#etsug_syslin_syntax1...

 

I hope this helps!

DW

View solution in original post

3 REPLIES 3
dw_sas
SAS Employee

Hi Can,

 

Although PROC SYSLIN does not directly provide the numerator and denominator values associated with the F statistic, you can add the PRINT option to the STEST statement to obtain the intermediate computations.  Matrix multiplication in SAS/IML can then be used to compute the numerator of the F statistic.  The denominator is computed as the number of restrictions*system weighted MSE, where the number of restrictions is equal to the Numerator DF, and the system weighted MSE is part of the printed output of the procedure.  Please see the following documentation link for additional details:

 

http://support.sas.com/documentation/cdl/en/etsug/68148/HTML/default/viewer.htm#etsug_syslin_syntax1...

 

I hope this helps!

DW

acironin
Calcite | Level 5
Thank you very much for the response, DW, I really appreciate it.
Best regards,
Can
dw_sas
SAS Employee

I'm glad the information helped, Can!

 

Best Regards,

DW

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!

Discussion stats
  • 3 replies
  • 1756 views
  • 1 like
  • 2 in conversation