Date:         Mon, 25 Oct 2004 10:44:14 -0700
Reply-To:     Joep Steeman <jwmsteeman@XS4ALL.NL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Joep Steeman <jwmsteeman@XS4ALL.NL>
Organization: http://groups.google.com
Subject:      Re: group by processing
Content-Type: text/plain; charset=ISO-8859-1

Hi Stefan,

I suggest the following:

PROC SORT DATA=your_data;
  BY householdid canceldate;
RUN;


stefan.pohl@WISO.UNI-KOELN.DE (Stefan Pohl) wrote in message news:<00ed01c4ba76$af9d10b0$1b9e5f86@simurechner>...
> Hi all,
>
>  i suppose that my problem could be solved by group by-processing...
>
>  my data look like this:
>
>  contractid householdid canceldate
>  1             1                  23.11.1999
>  2             1                  30.04.2001
>  3             2                  31.05.2001
>  4             2                  01.01.2000
>
> i want to sort by canceldate within each household, so that contract 3
> appears after contract 4 for household 2.
>
> is there an easy way ? Group by processing?
>
> thank you, stefan.
>
> ---------------------------------------------------
> Dipl.-Kfm. Stefan Pohl
> Seminar f r Wirtschafts- und Sozialstatistik an der Universitaet zu
> Koeln
> Meister-Ekkehart Str. 9
> 50937 Koeln, Germany
> Tel.: +49-221-470-4514
> Fax: +49-221-470-5084
> Email: <mailto:pohl@statistik.uni-koeln.de>pohl@statistik.uni-koeln.de
>
> http://www.uni-koeln.de/wiso-fak/wisostatsem/