Filtering Cells with a Characteristic in SPSS

[chukks]

I want to filter empty cells from a particular field (variable) while leaving filled cells intact. How do I do this?

[Bruce Weaver]

One typically filters out entire cases (rows) based on the values of one or more variables (fields).*  Perhaps you could give a small example of what you want to do?


* Example:

COMPUTE f = { some condition involving one or more variables }.
USE ALL.
FILTER BY f. /* use only cases where the condition is true.

* Your analyses here.

USE ALL.
FILTER OFF. /* Turn off the filter.

chukks wrote

I want to filter empty cells from a particular field (variable) while leaving filled cells intact. How do I do this?

[Melissa Ives]

If you want to exclude the filled cells...
Compute filter=(sysmis(varname)).
If you want to exclude the blank cells...
  Compute filter=not (sysmis(varname)).
For either...
  Filter by filter.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of chukks
Sent: Wednesday, July 03, 2013 12:54 AM
To: [hidden email]
Subject: [SPSSX-L] Filtering Cells with a Characteristic in SPSS

I want to filter empty cells from a particular field (variable) while leaving filled cells intact. How do I do this?



--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Filtering-Cells-with-a-Characteristic-in-SPSS-tp5720979.html
Sent from the SPSSX Discussion mailing list archive at 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

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

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