SPSSX Discussion

Fw: R: Filter

Classic

List

Threaded

2 messages Options

Rhonda Boorman

Fw: R: Filter

Unfortunately, this still excludes those extra 3 cases from my data set.

Rhonda

----- Original Message -----
From: "Luca Meyer" <[hidden email]>
To: <[hidden email]>
Sent: Friday, February 15, 2008 4:30 PM
Subject: R: Filter

> Can this help?
>
> data list free /ID (F3.0).
> begin data
> 100
> 194
> 200
> 300
> 432
> end data.
> list.
>
> compute filter_$=(ID<>194 AND ID<>432).
> filter by filter_$.
> list.
>
> Luca
>
> Mr. Luca MEYER
> Market research, data analysis & more
> www.lucameyer.com - Tel: +39.339.495.00.21
>
>
> -----Messaggio originale-----
> Da: SPSSX(r) Discussion [mailto:[hidden email]] Per conto di
> Rhonda Boorman
> Inviato: venerdì 15 febbraio 2008 3.00
> A: [hidden email]
> Oggetto: Filter
>
> When I ran the following syntax to exclude 2 cases from analysis, a total
> 5
> cases were selected. The 3 new cases appear as dots in the filter column,
> not as 0 or 1.
> I suspect it is the result of some previous command I have input because
> the
> 3 cases are id 97 98 and 99, my missing data codes which I was examining
> ages ago.
> Can someone tell me what I have done, and how I can fix it?
>
> USE ALL.
>
> COMPUTE filter_$=(ID ~= 432 & ID ~= 194).
>
> VARIABLE LABEL filter_$ 'ID ~= 432 & ID ~= 194 (FILTER)'.
>
> VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
>
> FORMAT filter_$ (f1.0).
>
> FILTER BY filter_$.
>
> EXECUTE .
>
> Regards
>
> Rhonda
>
> =======
> 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
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.20.5/1279 - Release Date:
> 14/02/2008
> 18.35
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.20.5/1279 - Release Date:
> 14/02/2008
> 18.35
>
> =====================
> 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

ViAnn Beadle

Re: R: Filter

The problem is that you've defined values as missing. Unless you use the
MISSING function any to explicitly select those cases, the COMPUTE will set
the results to MISSING when any variable within the expression is missing.
If you want cases with those values included in your set of cases, just
redefine them to be not missing.

To remove the missing values, either remove them in the data editor's
variable view or run this command:

MISSING VALUES ID().

To keep them missing but include them in your filtered cases, change your
COMPUTE to this:

compute filter_$=(ID<>194 AND ID<>432 OR MISSING(ID)).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Rhonda Boorman
Sent: Thursday, February 14, 2008 11:48 PM
To: [hidden email]
Subject: Fw: R: Filter

Unfortunately, this still excludes those extra 3 cases from my data set.

Rhonda

----- Original Message -----
From: "Luca Meyer" <[hidden email]>
To: <[hidden email]>
Sent: Friday, February 15, 2008 4:30 PM
Subject: R: Filter

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

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