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

[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

[Maguin, Eugene]

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

[Martha Hewett]

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

[Bruce Weaver]

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
>

[Rodrigo Briceño-2]

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