Date: Thu, 22 Mar 2012 11:32:55 -0400
Reply-To: Jim Groeneveld <jim.1stat@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jim Groeneveld <jim.1stat@YAHOO.COM>
Subject: SQL Count peculiarity
Does anyone know anything about the following oddity?
The SAS SQL documentations presents its aggregate functions
and says that COUNT, FREQ and N are interchangeable.
However, nothing is less true as the following log snippet shows:
MPRINT(CROSSREF): SELECT N(*) INTO : NofRows FROM AnyTable;
ERROR: * used for a function other than COUNT.
Of course, the only example where all rows are counted uses COUNT.
And COUNT does NOT cause an error (I didn't try FREQ).
Regards - Jim.
Jim Groeneveld, Netherlands