Date:         Wed, 22 Aug 2007 15:15:52 -0400
Reply-To:     Annie Lee <hummingbird10111@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Annie Lee <hummingbird10111@HOTMAIL.COM>
Subject:      array question

Hi,

I have a dataset with doctor id, proceduredate, procedure number.
What is the best way to have the following results?
Thank you.


Data:

doc1 doc2 doc3 doc4  pdate1  pdate2  pdate3 pdate4 proc1 proc2 proc3 proc4

 1    2            070531  070602                 101   102
 3    4    5   6   060304  030309  060305  060307 201   202    203     204
 1    7    8       060911  060912  060910         301   302    303


Results:

doc   date   proced

1     070531  101
1     060911  301
2     070602  102
3     060304  201
4     030309  202
5     060305  203
6     060307  204
7     060912  302
8     060910  303