Date:         Wed, 7 May 1997 16:38:00 +0200
Reply-To:     "Spruck, Dirk,DE,Centeon" <SPRUCK1@MSMBWME.HOECHST.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Spruck, Dirk,DE,Centeon" <SPRUCK1@MSMBWME.HOECHST.COM>
Subject:      Re: SQL and data set option IN=?
Comments: cc: "Andy E. Barnett" <barnetta@PPDI.COM>
Content-Type: text/plain; charset="us-ascii"

Andy,
 
Try:
 
proc sql;
  create table cross as
  select  coalesce( a.key, b.key ) as key, in1, in2
      from (select *, 1 as in1 from test1) as a full join (select *, 1
as in2 from test2) as b
        on a.key = b.key;
quit;
 
HTH
 
Dirk
 
>----------------------------------------------------<
> Dirk Spruck                                        <
> Biometrical Data Manager                           <
> Centeon Pharma GmbH, Marburg                       <
> Germany                                            <
> E-Mail: SPRUCK1@MSMBWME.HOECHST.COM                <
>----------------------------------------------------<
 
 ----------
From: Andy E. Barnett
To: Multiple recipients of list SAS-L
Subject: SQL and data set option IN=?
Date: Wednesday, 7. May 1997 03:33
 
Is there some way to determine whether or not a data set contributes
data
in an SQL FULL JOIN? How do I code something like:
 
proc sql;
  create table cross as
  select  coalesce( a.key, b.key ) as key, in1, in2
      from test1 ( in = in1 ) as a full join test2 ( in = in2 ) as b
        on a.key = b.key;
quit;
 
Thanks!
 
Andy Barnett
barnetta@ppdi.com
PPD Pharmaco, Inc.
RTP, NC, USA
 
Disclaimer: All opinions expressed herein are strictly my own.
 
 -------------------==== Posted via Deja News
====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet