Generating a complex table of drug, disease, and phase

• Trying to create a table which lists the drugs and diseases for a given phase or combination of phases of a clinical trial (I, II, II).
• Data structure: Each observation has a given drug, disease, and phase. For each drug, there could be multiple diseases and/or phases.

• testData.csv: Sample data

• Possible Solution 1 (Theresa Scott):
  • Drug.Phase.Disease.nw: Sweave file containing R code
  • Drug.Phase.Disease.pdf: Resulting pdf file containing generated table
  • Drug.Phase.Disease.2.tex: Modified .tex file --- includes more explicit formatting of table
  • Drug.Phase.Disease.2.pdf: Resulting pdf file containing modified generated table

• Possible Solution 2 (Jeremy Stephens):
  • drugs.r: R Code
  • Will produce the following data frame (newx) based on the test data:

   Drug Phase                             Disease
1     A   III                      Healthy Normal
2     B    II                Rheumatoid Arthritis
3     B     I Healthy Normal,Rheumatoid Arthritis
4     C     I                      Osteoarthritis
5     D    II                          Depression
6     D   III                      Healthy Normal
7     E     I                       Venous Ulcers
8     F     I                       Venous Ulcers
9     G    II                             Anxiety
10    G   III                          Depression
11    G     I                      Healthy Normal
12    H    II                Rheumatoid Arthritis
13    I    II                              Asthma
14    I     I                        Hypertension
15    J    II                      Osteoarthritis
16    K     I                              Asthma
17    K   III           Chronic Pulmonary Disease
18    K    II                              Asthma
19    L   III                     Prostate cancer
20    L    II                     Prostate cancer
21    M     I       Obsessive Compulsive Disorder
22    M   III                                ADHD
23    M    II       Obsessive Compulsive Disorder
24    N   III                            Diabetes

    I    II    II
Drug

Phase    Drug    Disease
I    A    ..., ...
     B       ..., ...
     C       etc.
II   D
     E
     F
III  G
     H
     I

• Possible Solution 3 (Svetlana Eden):
  • solCathySvetl.s: make it work in windows the same way as in linux