GEE Help

[samuelsr]

I have a data where patients are followed up for three years and each patient
will have three PID and the follow us is the same for all (1,2,3-
12m,24m,36m).

The data could be analyzed till 400 patients but when I include the whole
data it says "There are at least two records with the same values for the
subject and within-subject variables. No output will be displayed.
Execution of this command stops". I am close to my dead line and I need
desperate help guys, I tried to find Duplicates in SPSS and to avail, I
don't know what to look for. I USE V20. and very new to GEE,



Any help is appreciated.


Thanks



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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

[Bruce Weaver]

You'll increase the likelihood of getting some good help if you provided a
small listing (15 or 20 records) showing the variables used in your model
(including the ID variable) and if you showed us your code.

For the LIST command, you want something like this:

LIST VARIABLES = {varlist} CASES FROM 1 TO 20.

Replace {varlist} with your ID variable and all variables used in your
model.  

HTH.




samuelsr wrote

> I have a data where patients are followed up for three years and each
> patient
> will have three PID and the follow us is the same for all (1,2,3-
> 12m,24m,36m).
>
> The data could be analyzed till 400 patients but when I include the whole
> data it says "There are at least two records with the same values for the
> subject and within-subject variables. No output will be displayed.
> Execution of this command stops". I am close to my dead line and I need
> desperate help guys, I tried to find Duplicates in SPSS and to avail, I
> don't know what to look for. I USE V20. and very new to GEE,
>
>
>
> Any help is appreciated.
>
>
> Thanks
>
>
>
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (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





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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

[Art Kendall]

Although I have not used the GEE procedure, the message sound like you have
one or more cases that are duplicate.

try something like this. untested.

Sort case by PID year, t1 to t3.
 do if
   (pid   eq lag(PID))  and
   (year eq lag(year)) and
   (t1     eq lag(t1))    and
   (t2     eq lag(t2))    and
   (t3     eq lag(t3))    .
print // PID year, t1 to t3.
end if.
execute.

then go into data view and scroll down to the PID.



-----
Art Kendall
Social Research Consultants
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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

[MLIves]

Hi samuelsr,
I'm farily new to GEE, but I got the same kind of message when using the subcommand
/REPEATED SUBJECT=ClientID SORT=YES CORRTYPE=INDEPENDENT
Since ClientID alone (as in your case) does not uniquely identify a record.
I no longer got the message using:
  /REPEATED SUBJECT=ClientID WITHINSUBJECT=<follow-up period indicator varname> SORT=YES CORRTYPE=INDEPENDENT

List gurus, (new related question)

That was great, but my boss wants the parameters by that <follow-up period indicator varname> (only 2 levels for this dataset) and I don't get those parameter values or any descriptives by <follow-up period indicator varname> unless I put that variable in as a factor (which had been done for earlier analyses of this dataset).

Since I am being asked to get this done yesterday, I don't have time to research the answers to the following questions and hope this list can provide some guidance:

Which is the usual/expected way to assess change over time using GEE?
Is there a way to get parameters or at least descriptives by InterviewType in the following (<DV> is the current dependent variable)?
What is the difference in how SPSS handles the Follow-up period variable when it is a within-subject indicator vs. as a factor?

* Generalized Estimating Equations.
GENLIN <DV> BY Gender NonWhite Retained (ORDER=DESCENDING) WITH Age
  /MODEL Gender NonWhite Retained Age INTERCEPT=YES
 DISTRIBUTION=NORMAL LINK=IDENTITY
  /CRITERIA SCALE=MLE PCONVERGE=1E-006(ABSOLUTE) SINGULAR=1E-012 ANALYSISTYPE=3(WALD) CILEVEL=95
    LIKELIHOOD=FULL
  /EMMEANS TABLES=Gender SCALE=ORIGINAL
  /EMMEANS TABLES=NonWhite SCALE=ORIGINAL
  /EMMEANS TABLES=Retained SCALE=ORIGINAL
  /REPEATED SUBJECT=ClientID WITHINSUBJECT=InterviewType SORT=YES CORRTYPE=INDEPENDENT
    ADJUSTCORR=YES COVB=ROBUST
  /MISSING CLASSMISSING=EXCLUDE
  /PRINT CPS DESCRIPTIVES MODELINFO FIT SUMMARY SOLUTION.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of samuelsr
Sent: Monday, September 02, 2019 8:25 AM
To: [hidden email]
Subject: [SPSSX-L] GEE Help

I have a data where patients are followed up for three years and each patient will have three PID and the follow us is the same for all (1,2,3- 12m,24m,36m).

The data could be analyzed till 400 patients but when I include the whole data it says "There are at least two records with the same values for the
subject and within-subject variables. No output will be displayed.
Execution of this command stops". I am close to my dead line and I need desperate help guys, I tried to find Duplicates in SPSS and to avail, I don't know what to look for. I USE V20. and very new to GEE,



Any help is appreciated.


Thanks



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
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

________________________________

This correspondence contains proprietary information some or all of which may be legally privileged; it is for the intended recipient only. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this correspondence and completely dispose of the correspondence immediately. Please notify the sender if you have received this email in error. NOTE: Messages to or from the State of Connecticut domain may be subject to the Freedom of Information statutes and regulations.

=====================
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