Date:         Wed, 14 Sep 2005 16:31:03 -0400
Reply-To:     saslist <saslist@COMCAST.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         saslist <saslist@COMCAST.NET>
Subject:      Proc SQL transpose

I could do this with proc transpose but would like a SQL solution if one
exists. I have:
MA EMAIL1MA
MA EMAIL2MA
MA EMAIL3MA
ME EMAIL1ME
ME EMAIL2ME
ME EMAIL3ME


but would like ...

MA "EMAIL1MA" "EMAIL2MA" "EMAIL3MA"
ME "EMAIL1ME" "EMAIL2ME" "EMAIL3ME"

I thought the following would do it but I am getting all the emails for each
state:

proc sql;
select st, email into :st, :email
from test;
quit;

TIA