Deleting many cases

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

Deleting many cases

The Burl
Hello Discussion Board Members,

I need to delete about 1500 cases (from about 300k). I have an identifying variable for the values I need to delete. For example, I need to delete cases# 101, 1402, 1803, etc.

My list of what needs to be removed is currently in Excel. Any tricks for writing an incredibly long SELECT IF?

Many thanks in advance!
Jon
Reply | Threaded
Open this post in threaded view
|

Re: Deleting many cases

David Wasserman
Create an SPSS data file of the cases you wish to delete.  Use match files
with the IN feature for your files of cases to be deleted, and then select
if not in the file of cases to be deleted.



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of The
Burl
Sent: October-09-14 3:35 PM
To: [hidden email]
Subject: Deleting many cases

Hello Discussion Board Members,

I need to delete about 1500 cases (from about 300k). I have an identifying
variable for the values I need to delete. For example, I need to delete
cases# 101, 1402, 1803, etc.

My list of what needs to be removed is currently in Excel. Any tricks for
writing an incredibly long SELECT IF?

Many thanks in advance!
Jon



--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Deleting-many-cases-tp5727561.
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: Deleting many cases

David Marso
Administrator
Yep!
David Wasserman wrote
Create an SPSS data file of the cases you wish to delete.  Use match files
with the IN feature for your files of cases to be deleted, and then select
if not in the file of cases to be deleted.



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of The
Burl
Sent: October-09-14 3:35 PM
To: [hidden email]
Subject: Deleting many cases

Hello Discussion Board Members,

I need to delete about 1500 cases (from about 300k). I have an identifying
variable for the values I need to delete. For example, I need to delete
cases# 101, 1402, 1803, etc.

My list of what needs to be removed is currently in Excel. Any tricks for
writing an incredibly long SELECT IF?

Many thanks in advance!
Jon



--
View this message in context:
http://spssx-discussion.1045642.n5.nabble.com/Deleting-many-cases-tp5727561.
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
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"