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:
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
select st, email into :st, :email