Date:         Mon, 2 Oct 2006 20:48:19 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Macro will execute ,if value is not null,other wise end
Comments: To: kuladeep.m@gmail.com
In-Reply-To:  <d44d467b0610021339m5b0f6565g8536d0837a0e0017@mail.gmail.com>
Content-Type: text/plain; format=flowed

Well atleast your getting a descent error message now.

Have you defined macro %AFO, if not then there is your problem whe you call
the macro &List in the %Length statement it will try to run the macro.  If
you dont want it to run then you will need to use a execute time quoting
function like %SuperQ which will let the macro var &List resolve but not any
further macro calls.

Toby Dunn

When everything is coming at you all at once, your in the wrong lane.

A truly happy person is someone who can smile and enjoy the scenery on a
detour.





From: "Kuladeep Mittapalli" <kuladeep.m@gmail.com>
To: "toby dunn" <tobydunn@hotmail.com>
CC: SAS-L@listserv.uga.edu
Subject: Re: Macro will execute ,if value is not null,other wise end
Date: Mon, 2 Oct 2006 15:39:12 -0500

Hi Toby,

Thank you so much for your nice reply,
But when i gave the below statement,the program is not executing,its hangup
Its showing following message :

would you please tell what should i do?


Apparent invocation of macro AFO not resolved.

Thanks


On 10/2/06, toby dunn <tobydunn@hotmail.com> wrote:
>
>Kuladeep ,
>
>Replace This :
>%IF &LIST EQ %THEN %GOTO IEND;
>
>With :
>
>%IF ( %Length( &LIST ) = 0 ) %THEN %GOTO IEND;
>
>
>
>
>Toby Dunn
>
>When everything is coming at you all at once, your in the wrong lane.
>
>A truly happy person is someone who can smile and enjoy the scenery on a
>detour.
>
>
>
>
>
>From: Kuladeep Mittapalli <kuladeep.m@GMAIL.COM>
>Reply-To: Kuladeep Mittapalli <kuladeep.m@GMAIL.COM>
>To: SAS-L@LISTSERV.UGA.EDU
>Subject: Macro will execute ,if value is not null,other wise end
>Date: Mon, 2 Oct 2006 15:06:48 -0500
>
>Hi,
>I have following code,when i tried to execute ,am getting error.would you
>please inform,what i did wrong ..It is kind of very urgent..would you
>please
>inform
>
>*
>
>PROC* *SQL* NOPRINT;
>
>CREATE TABLE NO_BENEFICIARY AS
>
>SELECT
>
>INITIATIVE_ID FORMAT *4.
>*
>
>,COUNT(DISTINCT MEMBER_ID) AS TOTAL FORMAT *5.
>*
>
>FROM FINAL
>
>WHERE PT_BENEFICIARY_ID IS NULL
>
>GROUP BY INITIATIVE_ID;*QUIT*;*RUN*;
>
>*PROC* *SQL* NOPRINT;
>
>%LET LIST=;
>
>SELECT '%AFO(INIT ="'!! TRIM(COMPRESS(PUT(INITIATIVE_ID,*4.*)))
>
>!!'",COUNT="'!! TRIM(PUT(TOTAL,*5.*)) !!'");'
>
>INTO :LIST
>
>SEPARATED BY ' '
>
>FROM NO_BENEFICIARY;*QUIT*;*RUN*;
>*
>
>%MACRO* NOBENE(LIST=);
>
>%IF &LIST EQ %THEN %GOTO IEND;
>
>%*email_parms*(EM_TO="kuladeep.mittapalli@caremark.com",
>
>EM_SUBJECT="TEST--TEST--TEST--Following Memberids doesn't have
>Beneficiary_ids",
>
>EM_MSG="Following Memberids does not have Beneficiary_ids(Recipient_ids :
>&LIST.)";
>
>%IEND:;
>*
>
>%MEND*;
>
>%*NOBENE*(LIST=&LIST);
>
>
>
>
>
>error :
>
>Required operator not found in expression: &LIST EQ
>
>
>
>Thanks in adva*nce*
>
>
>