Date:         Tue, 2 Dec 2003 09:04:01 -0500
Reply-To:     "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fehd, Ronald J. (PHPPO)" <rjf2@CDC.GOV>
Subject:      Re: Print number of record only
Comments: cc: mmxell <docdoc1357@TIPGOD.COM>
Content-Type: text/plain; charset="us-ascii"

> From: mmxell [mailto:docdoc1357@TIPGOD.COM]
> The "n" option of PROC PRINT will display the number of
> record at the end of the dataset listing.  How can I modify
> the statement and print the number of record without printing
> the listing of the dataset?

where do you want to print the number of records?

%Let Library = Library;
%Let MemName = ntty0308;

TITLE "Nobs(&Library..&MemName.)";

%Let Library = %upcase(&Library.);
%Let MemName = %upcase(&MemName.);

PROC Sql;select LibName, MemName, Nobs
         from Dictionary.Tables
         where     LibName eq "&Library."
               and MemName eq "&MemName."
        ;quit;

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2@cdc.gov

Efficiency is intelligent laziness. -David Dunham