Thank you Steven W. Bradley I was able to do what was needed but now I have
a new opportunity.
Could someone please help me understand why it is important to have multiple
observations at different rates with the same id when you reshape wide. The
error below was generated when I tried to reshape.
note: j = 0/10 1-2/10 1/10 10/10 2-3/10 2/10 3-4/10 3-5/10 3-6/10 3-7/10
3/10
4-10/10 4-5/10 4-6/10 4-8/10 4/10 5-6/10 5-7/10 5/10 6-10/10 6-7/10 6/10
7-1
0/10 7-8/10 7-9/10 7/10 8-10/10 8-9/10 8/10 9/10 ? MIN PAIN MORE PAIN PAIN
BE
TTER PAIN CONTROLLED PAIN WORSENED RESONABLY CNTRD SEVERE INCREASE
SEVERE/MOR
E PAI SIG MORE PAIN SVR MORE PAIN UNCNTRD PAIN UNCONTRLD PAIN UNRESPONSIVE
WE
LL CONTROLLED WORSE WORSE PAIN WORSENING PAIN)
rate not unique within id;
there are multiple observations at the same rate within id.
Type "reshape error" for a listing of the problem observations.
r(9);
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
