Removing a row with blank cells of a string variable

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Removing a row with blank cells of a string variable

fevziesen
I have 100 rows and 10 variables.

one of variables is a string variable. I want to remove the rows which have blank value.

 
Reply | Threaded
Open this post in threaded view
|

Re: Removing a row with blank cells of a string variable

Bruce Weaver
Administrator
See examples of SELECT IF in the "fine manual" (FM).


fevziesen wrote
I have 100 rows and 10 variables.

one of variables is a string variable. I want to remove the rows which have blank value.
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

PLEASE NOTE THE FOLLOWING: 
1. My Hotmail account is not monitored regularly. To send me an e-mail, please use the address shown above.
2. The SPSSX Discussion forum on Nabble is no longer linked to the SPSSX-L listserv administered by UGA (https://listserv.uga.edu/).
Reply | Threaded
Open this post in threaded view
|

Re: Removing a row with blank cells of a string variable

fevziesen
In reply to this post by fevziesen
I have looked many examples. my aim is only to drop variables which have no value or missing. I wanna choose only variables which have any value..
Reply | Threaded
Open this post in threaded view
|

Re: Removing a row with blank cells of a string variable

fevziesen
This post was updated on .
like this :

Reply | Threaded
Open this post in threaded view
|

Re: Removing a row with blank cells of a string variable

Maguin, Eugene
In reply to this post by fevziesen
Compute blank=0.
If (char.length(TargetStringVariable) eq 0) blank=1.
Select if (blank eq 0).
Execute.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of fevziesen
Sent: Tuesday, January 22, 2013 2:37 PM
To: [hidden email]
Subject: Removing a row with blank cells of a string variable

I have 100 rows and 10 variables.

one of variables is a string variable. I want to remove the rows which have blank value.






--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Removing-a-row-with-blank-cells-of-a-string-variable-tp5717580.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

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: Removing a row with blank cells of a string variable

fevziesen
thanks so much, this is what I need..