 | Kingfisher,
data old ;
input id dx :$1. case ;
cards ;
1 a 4
2 b 5
3 c 6
4 a 1
5 c 3
6 b 3
;
data skip ;
input id dx :$1. ;
cards ;
1 a
4 a
6 b
;
data new ;
merge old skip(in = skip) ;
by id dx ;
if skip then delete ;
run ;
Ian Whitlock
=================
Date: Sat, 22 Jan 2005 09:03:29 +0800
Reply-To: Kingfisher
Sender: "SAS(r) Discussion"
From: Kingfisher
Organization: HiNetNews
Subject: how to create a new dataset deduct from a old data set
I have a question of how to create a new dataset deduct from a old data set
If I have a original dataset :
id dx case
1 a 4
2 b 5
3 c 6
4 a 1
5 c 3
6 b 3
Now, I want to delete part of the data which contain the feature :
id dx
1 a
4 a
6 b
How can I do that ? I am expecting a new dataset which looks like:
id dx case
2 b 5
3 c 6
5 c 3
Please remember this is just a sample. I am actually managing a huge
dataset. Do tell me just delete those id=1 ro 4 or 6.
Thanks for any help.
|
|
