Exclude value from analysis

[Rhonda Boorman]

This will be a simple one for you guys...I'm still a SPSS novice.
I've been given a data set for analysis with values on a rating scale of 1 to 6.  However 6 value = not applicable.  I thought I could include a line in my syntax that excludes cases with value 6 from my analysis (basic e.g. descriptive, ANOVA), but haven't been successful yet.  Any suggestions?

Thanks

Rhonda


Rhonda Boorman
Email: [hidden email]

[Marta Garcia-Granero]

Hi Rhonda

Use:

MISSING VALUES "yourvar" (6).

Use it once before all the statistical analysis. To switch it off use:

MISSING VALUES "yourvar" ().

Regards,
Marta Garcia-Granero

> I've been given a data set for analysis with values on a rating scale of 1 to 6.  However 6 value = not applicable.  I thought I could include a line in my syntax that excludes cases with value 6 from my analysis (basic e.g. descriptive, ANOVA), but haven't been successful yet.  Any suggestions?

[Matthew Reeder]

Can't just filter by it?

  USE ALL.
COMPUTE filter_$=(varname <> 6).
VARIABLE LABEL filter_$ 'Filter'.
VALUE LABELS filter_$  0 'Not Selected' 1 'Selected'.
FORMAT filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE .

  Then when you're done...

  FILTER OFF .
  EXECUTE .



Rhonda Boorman <[hidden email]> wrote:
  This will be a simple one for you guys...I'm still a SPSS novice.
I've been given a data set for analysis with values on a rating scale of 1 to 6. However 6 value = not applicable. I thought I could include a line in my syntax that excludes cases with value 6 from my analysis (basic e.g. descriptive, ANOVA), but haven't been successful yet. Any suggestions?

Thanks

Rhonda


Rhonda Boorman
Email: [hidden email]



---------------------------------
Pinpoint customers who are looking for what you sell.