Selecting Records

[Brock-15]

Hi all,

Is it possible to select records using a convention similar to SQL, where
you can say field in (xxx,xxx,xxx)?

I find myself filtering on the multiple values in the same field all of the
time Year = 1999 | Year = 2000 | Year=2001 all of the time.

If you are asking why not just do less than or greater than to create a
range, the field I am using is a string field.

Thanks,

Brock

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

[Brock-15]

Thanks!  I had not thought of the ANY function.  Shame on me.

- Brock

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

[Valerie Guille-2]

Hello everybody,

I am hoping that someone could help me.
I have a RM ANOVA w/ 4 repeated treatments (Placebo, E2, Buspirone and
Combined) and 2 repeated region (TG and TR)
I am interested in all comparison w/i treatment and w/i region but I am
also interested in one particular comparison: i.e TG_placebo vs TR_E2
I couldn't figure out what the syntax command is in SPSS and I am
wondering if someone could help me. My syntax is the following:


GLM
  TG_Placebo TR_Placebo TG_Busp TR_Busp TG_E2 TR_E2 TG_Combined
TR_combined
  /WSFACTOR = ttt 4 Polynomial region 2 Polynomial
  /METHOD = SSTYPE(3)
  /EMMEANS = TABLES(OVERALL)
  /EMMEANS = TABLES(ttt) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(region) COMPARE ADJ(BONFERRONI)
  /EMMEANS = TABLES(ttt*region)COMPARE(ttt)
  /EMMEANS = TABLES(ttt*region)COMPARE(region)
  /PRINT = ETASQ HOMOGENEITY
  /CRITERIA = ALPHA(.05)
  /WSDESIGN = ttt region ttt*region .


Thanks in advance,

Sincerely yours,

Val

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