Date:         Tue, 23 Jan 2007 08:19:22 -0800
Reply-To:     prasad_prabhud@HOTMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         prasad_prabhud@HOTMAIL.COM
Organization: http://groups.google.com
Subject:      Help with the data
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

I have following data

data a;
  input id  fld;
  cards;
1  123^238^765
2  100^268
3  234^345^379^876^789
4  287
5  398^123^345^654


I would like the following output
1    123
1    238
1    765
2    100
2    268
3    234
3    345
3    379
3    876
3    789
4    287
5    398
5    123
5    345
5    654



I would appreciate any help in this