data ae; label subjid ='Subject Number' trt ='Treatment, 1=Control, 2=Active' aebodsys='Body System of Event' aedecod ='Preferred Term' aerel ='Relatedness, Y=Related, N=Not Related' aeser ='Seriousness, Y=Yes, N=No' aetoxgrd='AE Toxicity Grade' death ='Death, 1=Yes' aestdy ='Start Day of AE Relative to First Dose' aeendy ='End Day of AE Relative to First Dose' lstfdy ='Day of Last Follow-up' ; input subjid $ 1-3 trt 5 aebodsys $ 7-33 aedecod $ 34-58 aerel $ 59 aeser $ 62 aetoxgrd 65 death 68 aestdy 70-72 aeendy 73-76 lstfdy 77-79; cards; 001 2 Nervous system disorders Dizziness Y N 1 . 3 4 56 002 1 Cardiac disorders Cardiomyopathy N N 2 . 5 6 78 002 1 Nervous system disorders Headache N N 2 . 12 13 78 002 1 Vascular disorders Malignant hypertension N N 2 . 2 . 78 002 1 Cardiac disorders Cardiac valve disease Y N 2 . 2 34 78 002 1 Nervous system disorders Headache Y Y 3 . 7 8 78 002 1 Vascular disorders Hypertension Y N 2 . 3 4 78 007 2 Infections and infestations Bronchitis Y N 1 . 4 16 92 012 2 Infections and infestations Viral infection Y N 1 . 2 9 45 020 2 Eye disorders Conjunctivitis N N 1 . 17 21 83 021 2 Infections and infestations Subcutaneous abscess N N 2 . 45 . 92 021 2 Gastrointestinal disorders Constipation N N 2 . 23 24 92 021 2 Renal and urinary disorders Renal failure acute N N 2 . 43 50 92 021 2 Infections and infestations Sepsis Y Y 4 . 56 . 92 031 1 Gastrointestinal disorders Hypoaesthesia oral Y N 3 . 3 10 68 032 1 Infections and infestations Tooth abscess N N 2 . 2 7 78 038 1 Hepatobiliary disorders Bile duct stone N Y 2 . 33 45 90 040 2 Nervous system disorders Headache N N 1 . 12 13 65 041 2 Nervous system disorders Dizziness Y N 1 . 11 12 65 052 1 Infections and infestations Sinusitis N N 1 . 21 34 96 053 1 Infections and infestations Bronchitis N N 2 . 4 5 55 053 1 Infections and infestations Sinusitis N N 2 . 34 . 55 064 2 Nervous system disorders Syncope N N 2 . 23 . 87 064 2 Cardiac disorders Myocardial infarction N Y 2 . 45 47 87 065 1 Gastrointestinal disorders Paraesthesia oral Y N 1 1 2 6 20 071 2 Infections and infestations Sinusitis N N 2 . 3 16 87 077 1 Nervous system disorders Headache N N 2 . 56 67 83 083 2 Infections and infestations Nasopharyngitis N N 1 . 32 . 89 085 1 Cardiac disorders Atrial fibrillation N N 2 . 23 24 65 086 2 Infections and infestations Appendicitis N N 2 . 20 27 77 087 1 Eye disorders Ocular hyperaemia N N 2 . 22 56 90 087 1 Eye disorders Eye swelling N N 2 . 12 34 90 088 1 Eye disorders Eye swelling Y N 1 . 56 57 94 091 1 Infections and infestations Bronchitis N N 1 . 4 10 89 091 1 Cardiac disorders Atrial fibrillation N Y 3 . 28 30 89 092 1 Infections and infestations Urinary tract infection N N 1 . 23 26 71 093 1 Infections and infestations Oral herpes N N 2 . 12 17 99 093 1 Nervous system disorders Headache N N 1 . 3 5 99 095 2 Infections and infestations Laryngitis N N 1 . 66 75 89 095 2 Nervous system disorders Headache N N 1 . 88 89 89 097 1 Infections and infestations Nasopharyngitis N N 1 . 45 54 88 097 1 Nervous system disorders Syncope N N 2 . 23 56 88 099 1 Infections and infestations Diverticulitis N N 2 . 4 9 59 099 1 Nervous system disorders Syncope N N 2 . 21 . 59 103 2 Gastrointestinal disorders Abdominal pain upper Y N 1 . 32 33 78 105 1 Infections and infestations Sinusitis N N 2 . 66 . 89 105 1 Infections and infestations Nasopharyngitis N N 1 . 45 65 89 ; Required output should be like the following table: Adverse event Treatment 1 Treatment 2 (n=17) (n=13) Atrial fibrillation 2 (11.7) 0 Bile duct stone 1 (5.88) 0 Bronchitis 2 (11.7) 1(7.69) . . . . . . . Thank you in advance
... View more