 | Kingfisher: Check out the SQL SELECT statement. I'd suggest
proc sql; create table new as select id, dx, case, .... from old ; quit;
Note that you will not be able to use numbers or digit strings as column variable names. If you are working with an existing SAS dataset, all of the variable names will begin with an alphabetic character or an underscore. Sig
-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kingfisher Sent: Friday, January 21, 2005 8:03 PM To: SAS-L@LISTSERV.UGA.EDU 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.
|
|