| 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 |
|---|
|
| In-Reply-To: | <38408619-48a8-406e-82e6-42803d54c624@a39g2000pre.googlegroups.com> |
|---|
| 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.
PROC SQL;
SELECT *
FROM DATASET1 AS A FULL JOIN DATASET2 AS B
ON A.ID = B.ID;
QUIT;
On Fri, Dec 4, 2009 at 2:01 AM, siyuan li <lisiyuan0753@gmail.com> wrote:
> hi,all,
> 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;
> run;
> 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;
> quit;
> but it does not work.can someone help me.
>
| 
