knowledge-database (beta)

Current group: comp.soft-sys.sas

Re: how to create a new dataset deduct from a old data set

Re: how to create a new dataset deduct from a old data set  
Sigurd Hermansen
From:Sigurd Hermansen
Subject:Re: how to create a new dataset deduct from a old data set
Date:22 Jan 05 01:40:10 GMT
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.
   

Copyright © 2006 knowledge-database   -   All rights reserved