Date: Wed, 12 Jan 2011 08:23:21 -0800
Reply-To: Steve Steve <steve11145@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Steve Steve <steve11145@YAHOO.COM>
Subject: Transpose by SQL
Content-Type: text/plain; charset=iso-8859-1
How to do the following by SQL, please?
Thanks.
datahave;
inputpat id name $ val $;
cards;
101 1 AE AAA
101 1 ME BBBB
101 1 DD CC
101 2 AE XXXXX
101 2 ME YY
101 2 DD ZZZZZZ
;
Ideal output
Patid AE ME DD
1011 AAA BBBB CC
1012 XXXXX YY ZZZZZZ
| 
