Date: Fri, 2 Mar 2007 11:50:40 -0500
Reply-To: "Aspinall, Clifford G" <clifford.g.aspinall@PFIZER.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Aspinall, Clifford G" <clifford.g.aspinall@PFIZER.COM>
Subject: Re: How to create multiple macros using Into : operator ??
In-Reply-To: A<c2192a610703020824h3895e2d4xd7987ce1aca545e0@mail.gmail.com>
Content-Type: text/plain; charset="us-ascii"
Depends on what you want as your final result but if you are looking for
a distinct list of all pt and itt values then put distinct in front of
pt (select distinct pt, itt).
SQL can't tell what you want from (select pt, distinct itt) - it doesn't
know if you want each pt value from each row in the original data and
somehow merge that with all of the distinct values of itt regardless of
pt or something else. Since it can't determine what you want, it gives
you an error.
Cliff
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
SAS_learner
Sent: Friday, March 02, 2007 11:24 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to create multiple macros using Into : operator ??
Hello guys,
I am trying to rewrite some part of code in sql for example but I don
not
get what is wrong with SQL code , by the way in the process of writing
code
I have noticed that I can't use distinct in second part of sql
statement
like
proc sql ;
select pt , distinct ( itt) .................
quit ;
at this point SAS complains about distinct part why ??
Thanks for help
----------------------------------------------------------------------
LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.
| 
