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

[P.van Groenestijn]

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

[vlad simion]

hi,

have you tried OMS?

something like:

OMS

 /SELECT TABLES

 /IF COMMANDS = ["Generalized Linear Models"]

     SUBTYPES = ["Parameter Estimates"]

 /DESTINATION FORMAT = SAV NUMBERED = TableNumber_

  OUTFILE = "pestimates".

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.

OMSEND.

get file='pestimates'.

in the SUBTYPES command you can specify what table you wish to export and in the DESTINATION FORMAT the format you wish to export to

hth,

vlad 

On Mon, Jul 30, 2012 at 4:54 PM, P.van Groenestijn <[hidden email]> wrote:

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: <a href="tel:[phone]" value="[phone]" target="_blank">024-3612035
fax: <a href="tel:[phone]" value="[phone]" target="_blank">024-3612351
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