Date:         Mon, 25 Sep 2006 11:34:24 -0400
Reply-To:     Jack Clark <JClark@CHPDM.UMBC.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Clark <JClark@CHPDM.UMBC.EDU>
Subject:      Re: Error in Proc SQL
Comments: To: "Sridhar, Nagakumar" <nagakumar_sridhar@MERCK.COM>
Content-Type: text/plain

Kumar,

Looking at the MPRINT line from your log, it looks like the &trt_name macro
variable resolved to a blank (if &trt_name is truly a macro variable in your
code - I don't see a SYMBOLGEN statement in your log for &trt_name).  This
results in a comma to be immediately after the select statement.  I think
this is the source of the error.

A more complete section of the log may provide more information for us.


Jack Clark
Research Analyst
Center for Health Program Development and Management
University of Maryland, Baltimore County



-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sridhar, Nagakumar
Sent: Monday, September 25, 2006 11:16 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Error in Proc SQL

Hi all:
        I have the following code in proc sql and get an error which I can't
fathom and was hoping some one would enlighten me on where the problem is.

Proc sql;
   select &trt_name, total
          into :trt1-:trt&trtnum, :BigN1-:BigN&trtnum
   from sum_by;

33            select &trt_name, total           into :trt1-:trt&trtnum,
:BigN1-:BigN&trtnum    from
                              -
                              22
33   ! sum_by;    quit;
SYMBOLGEN:  Macro variable TRTNUM resolves to 3
SYMBOLGEN:  Macro variable TRTNUM resolves to 3
MPRINT(PDLC):   select , total into :trt1-:trt3, :BigN1-:BigN3 from sum_by;
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted
string,
              a numeric constant, a datetime constant, a missing value, *,
INPUT, PUT, USER.


As always, your assistance is highly appreciated.

Thanks and regards


Kumar



----------------------------------------------------------------------------
--
Notice:  This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates (which may be known
outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD
and in Japan, as Banyu - direct contact information for affiliates is
available at http://www.merck.com/contact/contacts.html) that may be
confidential, proprietary copyrighted and/or legally privileged. It is
intended solely for the use of the individual or entity named on this
message. If you are not the intended recipient, and have received this
message in error, please notify us immediately by reply e-mail and then
delete it from your system.

----------------------------------------------------------------------------
--