In earlier releases, you could also work with the RIDGEREG macro supplied with the Advanced Statistics module, as it can produce OLS regression results, and you can edit it to produce outfiles of the coefficients.

David Nichols Principal Support Statistician and Manager of Statistical Support SPSS Inc. nichols@spss.com

---------- From: Tverdek, Edward Sent: Monday, May 11, 1998 2:52 PM To: SPSSX-L@UGA.CC.UGA.EDU Subject: Re: Capturing Coefficients

James/Hector,

As of SPSS 7.5, the OUTFILE command in REGRESSION will save an SPSS matrix file that includes unstandardized regression coefficients and related variance estimates. This file won't, as far as I know, include the standardized Beta values, but it might be of some value to you anyway.

The file would be in an SPSS .sav format by default, but if you're running production-type jobs to extract different estimates now and put them in a separate database, you should be able to approximate this in SPSS for Windows. You might, for example, follow the REGRESSION specifications with a GET FILE to call up the OUTFILE matrix you've just created and save it immediately into a spreadsheet or database format with SAVE TRANSLATE. There is probably a more elegant way of doing this with the Script utility, though that's well outside of anything I can advise on.

I hope I've understood your question and that this is useful.

Ed Tverdek SPSS Technical Support

>-----Original Message----- >From: Hector E. Maletta [SMTP:hmaletta@overnet.com.ar] >Sent: Monday, May 11, 1998 2:21 PM >To: SPSSX-L@UGA.CC.UGA.EDU >Subject: Re: Capturing Coefficients > >James D. Munro wrote: >> >> Here at GSBC, we do a lot of analysis that use the beta coefficients from >>the >> regression outputs. We have this program >> >> that can scan a regression model....pick up the coefficents and constant >>into a >> database. This database allows us to do >> >> further analysis on the coefficients. This program runs on our mainframe >>and >> reads each line of the regression output - >> >> which can be rather slow when we're dealling with multiple models with >> different cuts of data. >> >> I'm wondering if there are better ways to capture the coefficient data as >>we >> are trying to move away from the mainframe >> >> system. >> >> Thanks! >> >> Jamie > > >To rephrase and generanlize the question: Is there any way for SPSS to >put regression coefficients and/or other suchlike statistical output >into spreadsheet-like files for further analysis? Not picking them >manuallyt one by one from the output window, but automatically when you >have to run a multitude of similar analyses. Also, I often find myself >needing a graph that shows the relative strength of different >(standardized) regression coefficients from one or various regression >runs: SPSS seems unable to satisfy these needs. > >Any help would be warmly acknowledged. > > >Hector Maletta >Universidad del Salvador >Buenos Aires, Argentina