Date:         Fri, 27 Feb 2009 08:46:42 +0530
Reply-To:     Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Anindya Mozumdar <anindya.lugbang@GMAIL.COM>
Subject:      Re: Macro quoting again!
Comments: To: mpajoh@odot.org
In-Reply-To:  <OFC2D28068.DF8B17E7-ON86257569.006ABA91-86257569.006BED80@fd9ns01.okladot.state.ok.us>
Content-Type: text/plain; charset=ISO-8859-1

I did not get a problem with the original code, yet I have modified it
to put quotes around t3 which should remove your warning -

title1 "Project(s) with ZERO ESTIMATE for a payitem";
%macro nodata(t3);
       call execute("title2 c=green ""&t3"";");
%mend nodata;
data _null_;
       if _n_ eq 1 and eof then do;
               %nodata(There are NO project(s) with ZERO ESTIMATE.);
               stop; end;
       call execute('proc print data=sashelp.class ;');
               call execute('run;');
  stop;
  set sashelp.class end=eof;
run;

Regards,
Anindya

On Fri, Feb 27, 2009 at 1:06 AM, Masoud Pajoh <mpajoh@odot.org> wrote:
> Here is a simplified code.
>
> title1 "Project(s) with ZERO ESTIMATE for a payitem";
> %macro nodata(t3);
>        call execute("title2 c=green &t3.;");
> %mend nodata;
> data _null_;
>        if _n_ eq 1 and eof then do;
>                %nodata(There are NO project(s) with ZERO ESTIMATE.);
>                stop; end;
>        call execute('proc print data=zeroes ;')
>                call execute('run;');
>   stop;
>   set zeroes end=eof;
> run;
>
> Although it does what I want it to, it gives the following:
>
> NNOTE: CALL EXECUTE generated line.
> 1    + title1 "Project(s) with ZERO ESTIMATE";
> 2    + title2 c=green There are NO project(s) with ZERO ESTIMATE.;
> WARNING: The TITLE statement is ambiguous due to invalid options or
> unquoted text.
>
> How can this be corrected?
>
> Thanks;
> Masoud
>