Date:         Wed, 19 Oct 2005 10:48:18 -0700
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: ````````````````````
Comments: To: Meg <napu1975@HOTMAIL.COM>

Meg - why not use a subject line "Basic Proc Transpose Question" or the
like?

tx

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Meg
Sent: Wednesday, October 19, 2005 10:40 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: ````````````````````

HI all.  I've been programming for quite awhile, but when it comes to
transposing data (something I do often)...I can never grasp fully this
proc and always have trouble with it..  So if you could help, it would
be great.

My data looks like this:

ID  RX_ID  date      quantity_pills  day_supply
1   1      8/1/00    30              30
1   1      9/1/00    30              30
1   2      9/6/00    60              30
1   2     10/6/00    60              30

I would like to have one line per RX num, so the data would look like
this

ID  RX_ID  date1  qty day_supply1  date2  qty2  day_supply2
1   1      8/1/00 30  30           9/1/00 30    30
1   2      9/6/00 60  30          10/6/00 60    30

Any help you can provide would be much appreciated