Date:         Thu, 8 Sep 2011 14:56:05 -0400
Reply-To:     Tom Smith <need_sas_help@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tom Smith <need_sas_help@YAHOO.COM>
Subject:      Re: A Proc Report question
Comments: To: Mary Rosenbloom <mary.rosenbloom.sas@GMAIL.COM>
Content-Type: text/plain; charset=ISO-8859-1

Can you please help me with an example? never did it before.
Thank a lot.


On Thu, 8 Sep 2011 10:52:22 -0700, Mary Rosenbloom
<mary.rosenbloom.sas@GMAIL.COM> wrote:

>Tom,
>
>How about turning this into a macro?  First, create a second dataset with
>one observation and one variable containing a character string which has
the
>value "No Record is available".  Then, use system tools to programatically
>determine if your main dataset is empty.  If it is empty, then run a proc
>report with your one-variable dataset, if not, run the proc report with
the
>original dataset.  You would probably need two PROC REPORT specifications.
>
>Cheers,
>Mary R.
>
>On Thu, Sep 8, 2011 at 10:25 AM, Tom Smith <need_sas_help@yahoo.com>
wrote:
>
>> I am using Proc Report to get the output but the output has no data, so
>> how I can create a message in the output �No Record is available�.
>> Thanks a lot
>>