Date:         Mon, 16 Dec 2002 06:01:01 -0000
Reply-To:     Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>
Subject:      new "flatten" macro

I have added a macro to my sasautos extensions to "flatten" data so that
there is only one observation per "by group".

You can link to it from this page:
http://mysite.freeserve.com/rolandrb/sasmacros/sasautos.html

...or go to it directly here:
http://mysite.freeserve.com/rolandrb/sasmacros/flatten.sas

Note that this calls two other macros, %words and %varnum.

Specifying a value for bygroup= is mandatory siince this macro (like nearly
all of them) was written in support of clinical trials programming in which
"by group" variables are nearly always present.