drop a row of data

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

drop a row of data

Rodrigo Briceño-2
Dear SPSS users. How can I drop a row of data from a SPSS file? what I
want is to drop the whole row for which my id=001080962163.
Thanks for your help!

--
Rodrigo Briceño
Economist
[hidden email]
SKYPE: rbriceno1087

=====================
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: drop a row of data

GauravSrivastava
use this
select if (id<>001080962163).
exe.

Regards,
Gaurav


On Thu, Dec 13, 2012 at 12:06 AM, Rodrigo Briceño <[hidden email]> wrote:
Dear SPSS users. How can I drop a row of data from a SPSS file? what I
want is to drop the whole row for which my id=001080962163.
Thanks for your help!

--
Rodrigo Briceño
Economist
[hidden email]
SKYPE: rbriceno1087

=====================
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: drop a row of data

Maguin, Eugene
In reply to this post by Rodrigo Briceño-2
Just like you would delete a row in excel or a word table or access: select row by putting the cursor on the row number, left click, press 'delete' key or edit menu --> clear.

Gene Maguin

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Rodrigo Briceño
Sent: Wednesday, December 12, 2012 1:37 PM
To: [hidden email]
Subject: drop a row of data

Dear SPSS users. How can I drop a row of data from a SPSS file? what I want is to drop the whole row for which my id=001080962163.
Thanks for your help!

--
Rodrigo Briceño
Economist
[hidden email]
SKYPE: rbriceno1087

=====================
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: drop a row of data

Martha Hewett
In reply to this post by Rodrigo Briceño-2
In the data editor, find that row using edit/find.  Then highlight the entire row by clickin in the left margin.  Delete the row using edit/clear.

Martha Hewett
  | 
Director of Research | 612.335.5865
Center for Energy and Environment
212 Third Avenue North, Suite 560 | Minneapolis, MN 55401
(cell) 612.839.2358 | (fax) 612.335.5888 | www.mncee.org




On Wed, Dec 12, 2012 at 12:36 PM, Rodrigo Briceño <[hidden email]> wrote:
Dear SPSS users. How can I drop a row of data from a SPSS file? what I
want is to drop the whole row for which my id=001080962163.
Thanks for your help!

--
Rodrigo Briceño
Economist
[hidden email]
SKYPE: rbriceno1087

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



This e-mail transmission and any attachments accompanying it may contain confidential and/or proprietary information and is intended only for the person or entity to whom it was originally addressed. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or other use of this information is strictly prohibited. Any unauthorized interception of this transmission is illegal. If you have received this transmission in error, please notify the sender by reply e-mail, and then destroy all copies of this transmission
Reply | Threaded
Open this post in threaded view
|

Re: drop a row of data

Bruce Weaver
Administrator
In reply to this post by GauravSrivastava
If ID is a string variable (the leading zeros make me suspicious), you'll need to enclose the ID code in quotes.

GauravSrivastava wrote
use this
select if (id<>001080962163).
exe.

Regards,
Gaurav


On Thu, Dec 13, 2012 at 12:06 AM, Rodrigo Briceño <[hidden email]>wrote:

> Dear SPSS users. How can I drop a row of data from a SPSS file? what I
> want is to drop the whole row for which my id=001080962163.
> Thanks for your help!
>
> --
> Rodrigo Briceño
> Economist
> [hidden email]
> SKYPE: rbriceno1087
>
> =====================
> 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
>
--
Bruce Weaver
bweaver@lakeheadu.ca
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.
Reply | Threaded
Open this post in threaded view
|

Re: drop a row of data

Rodrigo Briceño-2
In reply to this post by GauravSrivastava
Thanks Gaurav. I forgot to mention that I wanted to that with syntaxis!

2012/12/12 I Am Gaurav <[hidden email]>:

> use this
> select if (id<>001080962163).
> exe.
>
> Regards,
> Gaurav
>
>
> On Thu, Dec 13, 2012 at 12:06 AM, Rodrigo Briceño <[hidden email]>
> wrote:
>>
>> Dear SPSS users. How can I drop a row of data from a SPSS file? what I
>> want is to drop the whole row for which my id=001080962163.
>> Thanks for your help!
>>
>> --
>> Rodrigo Briceño
>> Economist
>> [hidden email]
>> SKYPE: rbriceno1087
>>
>> =====================
>> 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
>
>



--
Rodrigo Briceño
Economist
[hidden email]
SKYPE: rbriceno1087

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