Date:         Wed, 31 Jul 2002 15:03:28 -0600
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: select cases from Oracle database
Comments: To: peter.crawford@DB.COM
Content-Type: text/plain; charset=iso-8859-1

  create oracle_subset as
   select * from oracle_table
    where member_code in( &want )
   ;
quit;




the "create" might be better as
  create table oracle_subset as
   select * from oracle_table
    where member_code in( &want )
   ;


apologies for multi-post !!





Datum:         29/07/2002 17:27
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    "Wang, George" <gwang@OXHP.COM>

Betreff:       select cases from Oracle database
Nachrichtentext:

Hello,

I need select cases from an Oracle database based on member code.  I
have
already had an SAS dataset that contains member code.  The member code
is
TEXT formatted in both SAS dataset and Oracle database, such as A001,
A002,
H003,.......  Each time I need about 50 to 100 members.  Each member
hasReceived: from SLCDOM-MTA by firsthealth.com
        w
mutiple reocrds.  I can use FORMAT function to select them after I
retrieve
all of records from Oracle, but it both takes longer time and occupies
a
large space.  Are there any simple ways, such as macro, to retrieve
records
from the Oracle?   Thanks in advance for any help.

George





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender
und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in
this
e-mail is strictly forbidden.






--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail
irrtümlich erhalten haben, informieren Sie bitte sofort den Absender
und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If
you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in
this
e-mail is strictly forbidden.





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den
Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie
die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.