Date:         Mon, 14 May 2007 01:05:43 -0700
Reply-To:     celiacai@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         celiacai@GMAIL.COM
Organization: http://groups.google.com
Subject:      Re: dealing with library name?
Comments: To: sas-l@uga.edu
In-Reply-To:  <1179129210.612052.5720@y80g2000hsf.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

On May 14, 5:53 pm, Aqua_cool_dude <atul.5...@gmail.com> wrote:
> Also for the query
>
> proc sql;
>   create table &out_ds as
>    select * from A, B, &in_ds
>     where A.cusip6=B.cusip6=&in_ds..cusip6
>         and A.date=B.date;
> you will get a warning, indicating that cusip6 column is referenced
> multiple times, first instance would be used.(this is due to the fact
> that select * would mean select A.cusip6, B.cusip6,
> &in_ds.cusip6.......)
>
> Regards,
> Atul
> mailto:Atul.TRIPA...@suncorp.com.au

Hi Atul,

I think the cusip6 is alright, since if I don't use macro, there won't
be any problem. I have the variable cusip6 in dataset A,B and &in_ds
and I just want to match them....

The full query would be too long and not so relavant (?) and here's
the the part with problem.

celia