Date:         Tue, 7 Oct 2008 09:07:08 -0500
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Help extracting data
Comments: To: Ratna <ratna.tobing@GMAIL.COM>
Content-Type: text/plain; charset="iso-8859-1"

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