|Date: ||Fri, 4 Dec 2009 08:03:12 -0600|
|Reply-To: ||Craig Johnson <cjohns38@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Craig Johnson <cjohns38@GMAIL.COM>|
|Subject: ||Re: proc sql jion problem|
|Content-Type: ||text/plain; charset=ISO-8859-1|
The abbreviation of A and B may be the issue if you don't put the AS but
then again maybe it's just because you are giving an example. Below is what
I would do.
FROM DATASET1 AS A FULL JOIN DATASET2 AS B
ON A.ID = B.ID;
On Fri, Dec 4, 2009 at 2:01 AM, siyuan li <email@example.com> 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.