Date: Mon, 14 May 2007 01:05:43 -0700
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Re: dealing with library name?
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,
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.