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
/DESTINATION FORMAT = XLSX OUTFILE = '
/workdata/testomsregoutput.xlsx' VIEWER = NO. OMS
/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.
/method = enter num_repairs_month_dd num_grease_start_month_dd num_debris_start_month_dd.
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