Regression output along the lines of stata's outreg v2

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

altonjim1
Posts: 2
Joined: Thu Aug 20, 2015 4:22 pm

Regression output along the lines of stata's outreg v2

Postby altonjim1 » Thu Aug 20, 2015 4:31 pm

I am using spss version 22 to perform regressions using the regression command. I would like to export the results to excel in a format similiar to that produced by the outregv2 command from Stata. So far I have found the OMS command I am able to output results to excel but not in a particularly useful format.

Here is my code so far
OMS
/DESTINATION FORMAT = XLSX OUTFILE = '
/workdata/testomsregoutput.xlsx' VIEWER = NO. OMS
/SELECT MODELS
/IF COMMANDS = ['Regression'] SUBTYPES = ['Coefficients']
/DESTINATION FORMAT = SAV
/Columns SEQUENCE == ['Regression'] OUTFILE = 'workdata/regression_coefficients.sav'.

REGRESSION /STATISTICS COEFF R
/DEPENDENT num_cb_csrs_month_dd /METHOD=ENTER num_repairs_month_dd.
/statistics coeff
/DEPENDENT num_cb_csrs_month_dd
/method = enter num_repairs_month_dd num_grease_start_month_dd num_debris_start_month_dd.
OMSEND.

I have attached an example image with the formatting I am looking for. It includes the following: 1. estimated coeficients with astrisks showing level of significance. 2. Below the estimated coeficients standard errors in parantheses. 3. If possible an r squared value at the bottom. 4. From there I would like to have a new column for the next regression I run.


Example outreg2 output: http://statadaily.ikonomiya.com/wp-cont ... esult1.jpg
JonPedersen
Posts: 117
Joined: Wed May 25, 2011 7:07 am
Contact:

Re: Regression output along the lines of stata's outreg v2

Postby JonPedersen » Wed Aug 26, 2015 12:45 pm

Hi,
Well, outreg v2 is a user submitted command in Stata, but as far as I know nothing simlilar has been written for SPSS. It is not impossible to write a similar command, though, and it would be quite useful. Jon Peck may of course do it in his copious spare time, I guess.
Best
Jon
altonjim1
Posts: 2
Joined: Thu Aug 20, 2015 4:22 pm

Re: Regression output along the lines of stata's outreg v2

Postby altonjim1 » Wed Sep 02, 2015 7:22 pm

Hi Jon,

Thanks for your response. With some guidance I might be able to implement just such a command. Is there a way I can reach out to Jon Peck directly?

Best,

Matt
statman
Administrator
Posts: 2721
Joined: Tue Jun 12, 2007 12:08 pm
Location: Florida, USA

Re: Regression output along the lines of stata's outreg v2

Postby statman » Thu Sep 03, 2015 6:30 pm

Contact him through this forum (You might have to register)

Code: Select all

https://www.ibm.com/developerworks/community/forums/html/category?id=33333333-0000-0000-0000-000000000302

Who is online

Users browsing this forum: No registered users and 1 guest

cron