IBM Support

SPSS Command Syntax to delete variables that contain only missing values

Troubleshooting


Problem

I'm using SPSS for Windows and I have a data file with thousands of variables. I'm looking for a way I can automatically or programatically delete all string variables which are blank throughout the entire dataset. In other words, if there are 1000 respondents, then I want to delete all the string variables which are blank for all the 1000 records. I suppose it would be nice to have a way to do this for the numeric or non-string variables as well. Is there any way to do this without scripting?

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"18.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

69466

Document Information

More support for:
IBM SPSS Statistics

Software version:
18.0

Document number:
421655

Modified date:
16 April 2020

UID

swg21481480

Manage My Notification Subscriptions