Date:         Mon, 3 Sep 2007 15:29:50 -0300
Reply-To:     ricardosilva@SERASA.COM.BR
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ricardo G Silva <ricardosilva@SERASA.COM.BR>
Subject:      Re-arrange table
Content-Type: text/plain; charset="ISO-8859-1"

Dear Users,

I have a table with the following format:

ID      var1     var2 
1       a       s 
1       ..      ..
1       ..      ..
2       ..      ..
2       ..      .. 
2       ..      .. 
2       ..      ..
...     ..      ..
...     ..      ..
N       ..      ..

where the lenght of the ID's is variable. I would like to produce the 
following table:


ID_1    var1    var2    ID_2    var1    var2    ...     ID_N    ...
ID_1    ...     ...     ID_2    ...     ...     ...     ID_N    ...

Any hint obout how can I do this?

Thnaks in advance.


Ricardo Gonçalves Silva, M. Sc.
Tecnologia de Crédito 
SERASA S.A. 
É (11) - 6847-8889
? ricardosilva@serasa.com.br