|
not tested
proc sql;
create table newtable as
select * from oldtable
where d_dx >= d_s27 and
d_dx <= d_dx7;
quit;
----- Original Message -----
From: Ratna
To: SAS-L@LISTSERV.UGA.EDU
Sent: Monday, October 06, 2008 10:45 AM
Subject: Help extracting data
Hi all,
I am a beginner SAS user and have the following sample of data:
ID d_dx7 d_s27 dx d_dx
1 9/22/2003 6/11/2003 9940 9/29/2003
1 9/22/2003 6/11/2003 9941 9/29/2003
2 10/8/2002 5/30/2002 9941 10/15/2002
2 10/8/2002 5/30/2002 59780 6/7/2002
2 10/8/2002 5/30/2002 59780 10/15/2002
2 10/8/2002 5/30/2002 59780 10/31/2002
3 3/27/2001 9/15/2000 340 9/15/1998
3 3/27/2001 9/15/2000 340 10/11/2000
3 3/27/2001 9/15/2000 340 10/16/2000
3 3/27/2001 9/15/2000 529 1/29/1990
3 3/27/2001 9/15/2000 5920 9/10/1999
3 3/27/2001 9/15/2000 5920 9/22/1999
3 3/27/2001 9/15/2000 5920 1/6/2006
3 3/27/2001 9/15/2000 5921 9/24/1999
3 3/27/2001 9/15/2000 5921 9/27/1999
3 3/27/2001 9/15/2000 5990 5/4/1997
3 3/27/2001 9/15/2000 9941 3/17/2001
3 3/27/2001 9/15/2000 9941 4/2/2001
3 3/27/2001 9/15/2000 9941 4/3/2001
4 4/28/2003 6/21/2001 7810 11/18/1996
4 4/28/2003 6/21/2001 7810 11/25/1996
4 4/28/2003 6/21/2001 7810 12/2/1996
4 4/28/2003 6/21/2001 7810 12/10/1996
4 4/28/2003 6/21/2001 7810 1/6/1997
4 4/28/2003 6/21/2001 9940 5/5/2003
4 4/28/2003 6/21/2001 9940 5/6/2003
This is probably an easy question, but how do I extract dx where d_dx is
between d_serum27 and d_dx7?
TIA
Ratna
| 
