Date:         Wed, 17 Dec 2008 15:43:47 -0200
Reply-To:     Paulo Rodrigo <rodrigo_paulo@YAHOO.COM.BR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paulo Rodrigo <rodrigo_paulo@YAHOO.COM.BR>
Subject:      Re: log - why this error on sort?
Comments: To: Adriano Rodrigues <adriano@gpp.com.br>
In-Reply-To:  <007a01c960a0$079997b0$16ccc710$@com.br>
Content-Type: text/plain; charset=ISO-8859-1

Adriano,
  Curious error (for me). For the proc sort you can add the force option.
E.g.:

proc sort data=asian force;
by home away year month;
run;
  Are the variables home and away the same size in both datasets ?

-- 
Att: Paulo R. Herculano
SAS Consultant
+55-11-9226 6618
Skål Thunar!!

On Wed, Dec 17, 2008 at 9:34 PM, Adriano Rodrigues <adriano@gpp.com.br>wrote:

> Hi all,
>
>
>
> Does warning have relation with error? Any advice here?
>
>
>
>
>
> 1509  proc sort data=asian;
>
> 1510  by home away year month;
>
> 1511  run;
>
>
>
> NOTE: Input data set is already sorted, no sorting done.
>
> NOTE: PROCEDURE SORT used (Total process time):
>
>      real time           0.00 seconds
>
>      cpu time            0.00 seconds
>
>
>
>
>
> 1512
>
> 1513  data all;
>
> 1514  merge all2 asian;
>
> 1515  by home away year month;
>
> 1516  run;
>
>
>
> WARNING: Multiple lengths were specified for the BY variable Home by input
> data sets. This may cause unexpected results.
>
> WARNING: Multiple lengths were specified for the BY variable Away by input
> data sets. This may cause unexpected results.
>
> ERROR: BY variables are not properly sorted on data set WORK.ASIAN.
> *****>>>
> why this error??
>
>
>
> Thanks in advance!
>
> Adriano
>