Date: Fri, 4 Dec 2009 14:15:06 +0100
Reply-To: js8765 <js8765@GOOGLEMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: js8765 <js8765@GOOGLEMAIL.COM>
Subject: Re: proc sql jion problem
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
It would be helpful to know what exactly you mean by "does not work".
What errors are you getting in the log, or is the output not as you wanted?
Anyway, if you are merging two data sets where only some of the values
match, then the following code should help:
select coalesce(a.id, b.id) as ID, col1, col2, ...
on a.id = b.id
order by id;
By the way, join is spelt "join" not "jion", maybe that's why it's not
siyuan li wrote:
> here has two data sets a and b. they have a varible which is id,
> I have the code like that:
> data merge1;
> merge a b;
> by id;
> the problem is I want to use the proc sql language to achieve the
> result that like the merge language .
> I try to write that:
> proc sql;
> select * from a full jion b
> on a.id=b.id;
> but it does not work.can someone help me.