How to export the coefficents from GLM to excel with SPSS 19.

Posted by P.van Groenestijn on Jul 30, 2012; 1:54pm
URL: http://spssx-discussion.165.s1.nabble.com/How-to-export-the-coefficents-from-GLM-to-excel-with-SPSS-19-tp5714527.html

Dear List members,

After running a GLM a would like to export all coefficients to excel, or
a SPSS datafile.

I run the following syntax:
GENLINMIXED
   /fields target= Activist_involved
   /TARGET_OPTIONS DISTRIBUTION=BINOMIAL LINK=LOGIT  reference = 0
   /FIXED EFFECTS=
Educ_HIGH_max_post_grad
female married_def divorced_separated widowed
age_def_miss age_squared_def_miss
   /random use_intercept=true subjects=CensusTract covariance_type=DIAGONAL.

When exporting this immediately to excel, I got all output of the Model
Vieweras a picture.
How can I export for example the fixed coefficients including Standard
Error, t-value, signifcance, Lower & Upper from all model terms?

Any help will be highly appreciated!

Pieter van Groenestijn
University of Nijmegen

--
RadboudUniversiteit Nijmegen
Faculteit Sociale Wetenschappen
Research Technische OndersteuningsGroep
Thomas van Aquinostraat 4.01.60
tel: [phone]
fax: [phone]
email: [hidden email]
hp: http://www.ru.nl/fsw/rtog/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD