Date:         Wed, 9 Jul 2003 10:27:09 -0500
Reply-To:     Gary Ross <gary_ross@MGIC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gary Ross <gary_ross@MGIC.COM>
Organization: http://extra.newsguy.com
Subject:      Re: PROC SUMMARY Failure
Content-Type: text/plain; charset=us-ascii

Ian Whitlock wrote:
>
> Kevin,
>
> This code executed fine for me under 8.2 (os=xp pro) with most hotfixes.
>
> data country ;
>    do x = 1 to 5 ;
>       do y = 1 to 5 ;
>          output ;
>       end ;
>    end ;
> run ;
>
> proc summary data=Country missing nway order=freq;
>    class x y ;
>    output out=Country;
> run;
>
> Do you get the same error message with the above code?
>
> IanWhitlock@westat.com
> -----Original Message-----
> From: Kevin Myers [mailto:WHMyers@CABLEONE.NET]
> Sent: Tuesday, July 08, 2003 4:43 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: PROC SUMMARY Failure
>
> Howdy Folks,
>
> As some of you may recall, using PROC SUMMARY in the following way used to
> work up through early V8.2 at least.  Note that there is no VAR statement,
> and the input data set has no numeric variables.  I have used this method
> many times over the years in order to obtain a simple list of all
> combinations of class variable values:
>
> proc summary data=Country missing nway order=freq;
>    class IHSCountryCode DSCountryId CountryName CountryAbbr;
>    output out=Country;
>    run;
>
> However, I now receive the following error message (SAS 8.2 with all?
> hotfixes under Win 2K):
>
> ERROR: Neither the PRINT option nor a valid output statement has been given.
>
> This or some similar message used to be produced under equivalent
> circumstances when using PROC MEANS, but NOT when using PROC SUMMARY
> (despite what the docs might lead you to believe to the contrary).  Has
> someone changed this PROC SUMMARY behavior on purpose???  If so, this is
> going to break LOTS of existing programs!!!
>
> If anyone can see some stupid mistake that I'm making, or has any
> information regarding this apparant change in behavior, I'd really
> appreciate it.  Thanks!
>
> s/KAM

It also ran fine on unix solaris v8.2 with all the latest hotfixes
installed. Is it possible "Country" is a view?