Date:         Wed, 15 Feb 2006 12:33:47 -0500
Reply-To:     Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@BLUEYONDER.CO.UK>
Subject:      Re: Combining multiple observations into one observation.
Comments: To: tanwanzang@YAHOO.COM

ok
since you want to use sql,  be as interesting as the data step
UPDATE statement, with some kind of sql UPDATE TABLE process

I'm not sure that that is possible as elegantly as the UPDATE
statement in a data step.

Good Luck

peter


On Wed, 15 Feb 2006 08:44:36 -0800, tanwan <tanwanzang@YAHOO.COM> wrote:

>And some SQL flavour:
>
>proc sql;
>create table colapsd as select id,
>   max(SAT_MATH) as SAT_MATH,
>   max(SAT_VERBAL) as SAT_VERBAL,
>   max(ACT_COMP) as ACT_COMP
>   from xx
>group by ID;
>quit;