Date:         Sun, 8 Mar 2009 21:13:50 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: little (more) help with proc sql
Comments: To: tammie.j@DOT.HN

Tammie,

Given your sample data, or better a sample dataset that has some of the
missing values you refer to, provide a third file that shows the resulting
file you want to get from the sample datasets.

Art
--------
On Mon, 9 Mar 2009 01:32:30 +0200, tammie <tammie.j@DOT.HN> wrote:

>this does not work if Data A and Data B also bring in new variables
(works fine
>without height,weight,position and origin)
>
>what's an easy way to collapse this in Proc Sql ?
>
>I need only 1 distinct value for all rows but a value can not be missing
>
>data a;input temp1 value2 height weight;
>datalines;
>100222 5 180 80
>100222 6 190 90
>;;;;
>run;
>data b;input temp1 value2 position origin;
>datalines;
>100222 7 1 5
>100222 6 1 5
>100222 7 2 5
>999222 7 2 5
>;;;;
>run;
>proc sql;
>create table match as
>      select  * from a
>      outer union corresponding
>      select  * from b
>      ;
>quit;
>data _null_;set ;put(_all_)(=) ;run;