Clinwright Public work of Clinwright examples · free Start free

14-5.01

Incidence of Treatment Emergent Adverse Events by Treatment Group

Made 2026-10-17 from uploaded data.

CDISCPILOT01

Table 14-5.01

Incidence of Treatment Emergent Adverse Events by Treatment Group

Safety Analysis Set

Fisher's Exact p-values
Placebo (N=86)Xanomeline Low (N=84)Xanomeline High (N=84)Placebo vs. Low DosePlacebo vs. High Dose
ANY BODY SYSTEM65 (75.6%) [281]77 (91.7%) [412]76 (90.5%) [433]0.0070.014
CARDIAC DISORDERS12 (14.0%) [26]13 (15.5%) [30]15 (17.9%) [30]0.8310.534
ATRIAL FIBRILLATION1 (1.2%) [1]1 (1.2%) [1]3 (3.6%) [5]>0.9990.365
ATRIAL FLUTTER0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [2]0.4940.494
ATRIAL HYPERTROPHY1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
ATRIOVENTRICULAR BLOCK FIRST DEGREE1 (1.2%) [1]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
ATRIOVENTRICULAR BLOCK SECOND DEGREE1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BRADYCARDIA1 (1.2%) [4]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BUNDLE BRANCH BLOCK LEFT1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BUNDLE BRANCH BLOCK RIGHT1 (1.2%) [2]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
CARDIAC DISORDER0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
CARDIAC FAILURE CONGESTIVE1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
MYOCARDIAL INFARCTION4 (4.7%) [4]2 (2.4%) [4]4 (4.8%) [8]0.682>0.999
PALPITATIONS0 (0.0%) [0]2 (2.4%) [2]0 (0.0%) [0]0.243>0.999
SINUS ARRHYTHMIA1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
SINUS BRADYCARDIA2 (2.3%) [2]7 (8.3%) [10]8 (9.5%) [12]0.0970.056
SUPRAVENTRICULAR EXTRASYSTOLES1 (1.2%) [2]1 (1.2%) [2]1 (1.2%) [1]>0.999>0.999
SUPRAVENTRICULAR TACHYCARDIA0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
TACHYCARDIA1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
VENTRICULAR EXTRASYSTOLES0 (0.0%) [0]2 (2.4%) [4]1 (1.2%) [1]0.2430.494
VENTRICULAR HYPERTROPHY1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
WOLFF-PARKINSON-WHITE SYNDROME0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
CONGENITAL, FAMILIAL AND GENETIC DISORDERS0 (0.0%) [0]1 (1.2%) [1]2 (2.4%) [2]0.4940.243
VENTRICULAR SEPTAL DEFECT0 (0.0%) [0]1 (1.2%) [1]2 (2.4%) [2]0.4940.243
EAR AND LABYRINTH DISORDERS1 (1.2%) [2]2 (2.4%) [2]1 (1.2%) [1]0.618>0.999
CERUMEN IMPACTION0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
EAR PAIN1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
VERTIGO0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [1]0.4940.494
EYE DISORDERS2 (2.3%) [5]2 (2.4%) [2]1 (1.2%) [2]>0.999>0.999
CONJUNCTIVAL HAEMORRHAGE0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
CONJUNCTIVITIS1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
EYE ALLERGY1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
EYE PRURITUS1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
EYE SWELLING1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
VISION BLURRED0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [2]0.4940.494
GASTROINTESTINAL DISORDERS17 (19.8%) [26]14 (16.7%) [22]20 (23.8%) [36]0.6920.580
ABDOMINAL DISCOMFORT0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
ABDOMINAL PAIN1 (1.2%) [1]3 (3.6%) [3]1 (1.2%) [2]0.365>0.999
CONSTIPATION1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
DIARRHOEA9 (10.5%) [10]4 (4.8%) [5]4 (4.8%) [4]0.2480.248
DYSPEPSIA1 (1.2%) [2]1 (1.2%) [2]0 (0.0%) [0]>0.999>0.999
DYSPHAGIA0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
FLATULENCE1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
GASTROINTESTINAL HAEMORRHAGE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
GASTROOESOPHAGEAL REFLUX DISEASE1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
GLOSSITIS1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
HIATUS HERNIA1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
NAUSEA3 (3.5%) [3]3 (3.6%) [5]6 (7.1%) [13]>0.9990.326
RECTAL HAEMORRHAGE0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
SALIVARY HYPERSECRETION0 (0.0%) [0]0 (0.0%) [0]4 (4.8%) [5]>0.9990.057
STOMACH DISCOMFORT0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
VOMITING3 (3.5%) [3]3 (3.6%) [4]7 (8.3%) [9]>0.9990.208
GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS21 (24.4%) [46]47 (56.0%) [118]40 (47.6%) [124]<0.0010.002
APPLICATION SITE BLEEDING0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
APPLICATION SITE DERMATITIS5 (5.8%) [9]9 (10.7%) [15]7 (8.3%) [12]0.2770.563
APPLICATION SITE DESQUAMATION0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
APPLICATION SITE DISCHARGE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
APPLICATION SITE DISCOLOURATION0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
APPLICATION SITE ERYTHEMA3 (3.5%) [3]12 (14.3%) [20]15 (17.9%) [23]0.0150.002
APPLICATION SITE INDURATION1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
APPLICATION SITE IRRITATION3 (3.5%) [7]9 (10.7%) [18]9 (10.7%) [16]0.0780.078
APPLICATION SITE PAIN0 (0.0%) [0]0 (0.0%) [0]2 (2.4%) [2]>0.9990.243
APPLICATION SITE PERSPIRATION0 (0.0%) [0]0 (0.0%) [0]2 (2.4%) [3]>0.9990.243
APPLICATION SITE PRURITUS6 (7.0%) [10]22 (26.2%) [32]22 (26.2%) [35]0.0010.001
APPLICATION SITE REACTION1 (1.2%) [2]0 (0.0%) [0]1 (1.2%) [1]>0.999>0.999
APPLICATION SITE SWELLING0 (0.0%) [0]1 (1.2%) [1]2 (2.4%) [3]0.4940.243
APPLICATION SITE URTICARIA0 (0.0%) [0]2 (2.4%) [2]1 (1.2%) [1]0.2430.494
APPLICATION SITE VESICLES1 (1.2%) [2]4 (4.8%) [5]6 (7.1%) [6]0.2080.062
APPLICATION SITE WARMTH0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
ASTHENIA1 (1.2%) [2]0 (0.0%) [0]1 (1.2%) [1]>0.999>0.999
CHEST DISCOMFORT0 (0.0%) [0]0 (0.0%) [0]2 (2.4%) [2]>0.9990.243
CHEST PAIN0 (0.0%) [0]0 (0.0%) [0]2 (2.4%) [2]>0.9990.243
CHILLS1 (1.2%) [3]1 (1.2%) [2]1 (1.2%) [1]>0.999>0.999
FATIGUE1 (1.2%) [2]5 (6.0%) [5]5 (6.0%) [5]0.1150.115
FEELING ABNORMAL0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
FEELING COLD0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
INFLAMMATION0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
MALAISE0 (0.0%) [0]1 (1.2%) [2]2 (2.4%) [3]0.4940.243
OEDEMA0 (0.0%) [0]2 (2.4%) [2]0 (0.0%) [0]0.243>0.999
OEDEMA PERIPHERAL2 (2.3%) [3]1 (1.2%) [1]2 (2.4%) [3]>0.999>0.999
PAIN0 (0.0%) [0]1 (1.2%) [2]1 (1.2%) [1]0.4940.494
PYREXIA2 (2.3%) [2]0 (0.0%) [0]1 (1.2%) [1]0.497>0.999
SECRETION DISCHARGE0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
SUDDEN DEATH0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
SWELLING0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
ULCER0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
HEPATOBILIARY DISORDERS1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
HYPERBILIRUBINAEMIA1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
IMMUNE SYSTEM DISORDERS0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
HYPERSENSITIVITY0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
INFECTIONS AND INFESTATIONS16 (18.6%) [35]9 (10.7%) [16]13 (15.5%) [20]0.1940.685
BRONCHITIS1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
CELLULITIS0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
CERVICITIS1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
CYSTITIS1 (1.2%) [1]0 (0.0%) [0]1 (1.2%) [1]>0.999>0.999
EAR INFECTION2 (2.3%) [4]0 (0.0%) [0]0 (0.0%) [0]0.4970.497
GASTROENTERITIS VIRAL1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
HORDEOLUM0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
INFLUENZA1 (1.2%) [2]1 (1.2%) [1]1 (1.2%) [1]>0.999>0.999
LOCALISED INFECTION1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
LOWER RESPIRATORY TRACT INFECTION0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [2]>0.9990.494
NASOPHARYNGITIS2 (2.3%) [4]4 (4.8%) [9]6 (7.1%) [8]0.4410.166
PNEUMONIA0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
RHINITIS0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
UPPER RESPIRATORY TRACT INFECTION6 (7.0%) [12]1 (1.2%) [2]3 (3.6%) [5]0.1170.496
URINARY TRACT INFECTION2 (2.3%) [4]0 (0.0%) [0]1 (1.2%) [1]0.497>0.999
VAGINAL MYCOSIS1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
VIRAL INFECTION0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
INJURY, POISONING AND PROCEDURAL COMPLICATIONS4 (4.7%) [9]5 (6.0%) [12]5 (6.0%) [8]0.7450.745
CONTUSION1 (1.2%) [1]1 (1.2%) [3]2 (2.4%) [3]>0.9990.618
EXCORIATION2 (2.3%) [3]1 (1.2%) [2]1 (1.2%) [1]>0.999>0.999
FACIAL BONES FRACTURE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
FALL1 (1.2%) [2]2 (2.4%) [2]1 (1.2%) [1]0.618>0.999
HIP FRACTURE1 (1.2%) [2]0 (0.0%) [0]2 (2.4%) [2]>0.9990.618
JOINT DISLOCATION0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
SKIN LACERATION1 (1.2%) [1]2 (2.4%) [2]0 (0.0%) [0]0.618>0.999
WOUND0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
INVESTIGATIONS10 (11.6%) [19]6 (7.1%) [7]6 (7.1%) [8]0.4320.432
BIOPSY0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
BIOPSY PROSTATE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
BLOOD ALKALINE PHOSPHATASE INCREASED1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BLOOD CHOLESTEROL INCREASED0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
BLOOD CREATINE PHOSPHOKINASE INCREASED1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BLOOD GLUCOSE INCREASED0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [2]0.4940.494
BLOOD URINE PRESENT1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BODY TEMPERATURE INCREASED0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
CYSTOSCOPY1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
ELECTROCARDIOGRAM ST SEGMENT DEPRESSION4 (4.7%) [4]1 (1.2%) [2]0 (0.0%) [0]0.3680.121
ELECTROCARDIOGRAM T WAVE AMPLITUDE DECREASED1 (1.2%) [1]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
ELECTROCARDIOGRAM T WAVE INVERSION2 (2.3%) [3]1 (1.2%) [1]1 (1.2%) [1]>0.999>0.999
HEART RATE INCREASED1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
HEART RATE IRREGULAR1 (1.2%) [4]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
NASAL MUCOSA BIOPSY0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
WEIGHT DECREASED0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [2]>0.9990.494
METABOLISM AND NUTRITION DISORDERS6 (7.0%) [8]1 (1.2%) [1]2 (2.4%) [4]0.1170.278
DECREASED APPETITE1 (1.2%) [2]0 (0.0%) [0]1 (1.2%) [2]>0.999>0.999
DEHYDRATION1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
DIABETES MELLITUS1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
FOOD CRAVING1 (1.2%) [1]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
HYPONATRAEMIA1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
INCREASED APPETITE1 (1.2%) [2]0 (0.0%) [0]1 (1.2%) [2]>0.999>0.999
MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS4 (4.7%) [6]7 (8.3%) [10]7 (8.3%) [10]0.3670.367
ARTHRALGIA1 (1.2%) [1]2 (2.4%) [4]1 (1.2%) [1]0.618>0.999
ARTHRITIS0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
BACK PAIN1 (1.2%) [2]1 (1.2%) [1]3 (3.6%) [4]>0.9990.365
FLANK PAIN0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
MUSCLE SPASMS0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [2]0.4940.494
MUSCULAR WEAKNESS0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
MYALGIA0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
PAIN IN EXTREMITY1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
SHOULDER PAIN1 (1.2%) [2]2 (2.4%) [2]0 (0.0%) [0]0.618>0.999
NEOPLASMS BENIGN, MALIGNANT AND UNSPECIFIED (INCL CYSTS AND POLYPS)0 (0.0%) [0]2 (2.4%) [3]1 (1.2%) [1]0.2430.494
COLON CANCER0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
MALIGNANT FIBROUS HISTIOCYTOMA0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
PROSTATE CANCER0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
NERVOUS SYSTEM DISORDERS8 (9.3%) [11]20 (23.8%) [40]25 (29.8%) [41]0.0130.001
AMNESIA0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [2]>0.9990.494
BALANCE DISORDER0 (0.0%) [0]1 (1.2%) [3]0 (0.0%) [0]0.494>0.999
BURNING SENSATION0 (0.0%) [0]0 (0.0%) [0]2 (2.4%) [2]>0.9990.243
COGNITIVE DISORDER0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
COMPLEX PARTIAL SEIZURES0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
COORDINATION ABNORMAL0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
DIZZINESS2 (2.3%) [3]8 (9.5%) [13]11 (13.1%) [15]0.0560.009
HEADACHE3 (3.5%) [3]3 (3.6%) [4]5 (6.0%) [8]>0.9990.493
HEMIANOPIA HOMONYMOUS0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
HYPERSOMNIA0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
LETHARGY0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [1]0.4940.494
PARAESTHESIA0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
PARAESTHESIA ORAL0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
PARKINSON'S DISEASE1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
PAROSMIA0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [2]>0.9990.494
PARTIAL SEIZURES WITH SECONDARY GENERALISATION0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
PSYCHOMOTOR HYPERACTIVITY1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
SOMNOLENCE2 (2.3%) [3]3 (3.6%) [5]1 (1.2%) [1]0.680>0.999
STUPOR0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
SYNCOPE0 (0.0%) [0]4 (4.8%) [6]3 (3.6%) [4]0.0570.118
SYNCOPE VASOVAGAL0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
TRANSIENT ISCHAEMIC ATTACK0 (0.0%) [0]2 (2.4%) [3]1 (1.2%) [1]0.2430.494
PSYCHIATRIC DISORDERS10 (11.6%) [12]10 (11.9%) [14]8 (9.5%) [11]>0.9990.804
AGITATION2 (2.3%) [2]2 (2.4%) [2]1 (1.2%) [1]>0.999>0.999
ANXIETY0 (0.0%) [0]3 (3.6%) [4]0 (0.0%) [0]0.118>0.999
COMPLETED SUICIDE1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
CONFUSIONAL STATE2 (2.3%) [2]3 (3.6%) [3]1 (1.2%) [1]0.680>0.999
DELIRIUM0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
DELUSION1 (1.2%) [1]0 (0.0%) [0]1 (1.2%) [1]>0.999>0.999
DEPRESSED MOOD0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
DISORIENTATION1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
HALLUCINATION0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
HALLUCINATION, VISUAL0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
INSOMNIA2 (2.3%) [3]0 (0.0%) [0]2 (2.4%) [2]0.497>0.999
IRRITABILITY1 (1.2%) [2]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
LIBIDO DECREASED0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
LISTLESS0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
NIGHTMARE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
RESTLESSNESS0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
RENAL AND URINARY DISORDERS4 (4.7%) [5]3 (3.6%) [3]3 (3.6%) [4]>0.999>0.999
CALCULUS URETHRAL0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
DYSURIA1 (1.2%) [1]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
INCONTINENCE0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
MICTURITION URGENCY1 (1.2%) [1]1 (1.2%) [1]1 (1.2%) [2]>0.999>0.999
NEPHROLITHIASIS1 (1.2%) [1]0 (0.0%) [0]1 (1.2%) [1]>0.999>0.999
POLLAKIURIA1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
REPRODUCTIVE SYSTEM AND BREAST DISORDERS2 (2.3%) [4]0 (0.0%) [0]1 (1.2%) [1]0.497>0.999
BENIGN PROSTATIC HYPERPLASIA1 (1.2%) [2]0 (0.0%) [0]1 (1.2%) [1]>0.999>0.999
PELVIC PAIN1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS8 (9.3%) [12]9 (10.7%) [14]10 (11.9%) [22]0.8030.626
ALLERGIC GRANULOMATOUS ANGIITIS0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
COUGH1 (1.2%) [1]5 (6.0%) [7]5 (6.0%) [7]0.1150.115
DYSPHONIA0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
DYSPNOEA1 (1.2%) [1]1 (1.2%) [1]1 (1.2%) [1]>0.999>0.999
EMPHYSEMA1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
EPISTAXIS0 (0.0%) [0]1 (1.2%) [1]2 (2.4%) [2]0.4940.243
HAEMOPTYSIS1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
NASAL CONGESTION3 (3.5%) [3]1 (1.2%) [1]3 (3.6%) [4]0.621>0.999
PHARYNGEAL ERYTHEMA0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [2]>0.9990.494
PHARYNGOLARYNGEAL PAIN0 (0.0%) [0]1 (1.2%) [1]1 (1.2%) [1]0.4940.494
POSTNASAL DRIP1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
PRODUCTIVE COUGH0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
RALES1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
RESPIRATORY TRACT CONGESTION0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
RHINORRHOEA0 (0.0%) [0]1 (1.2%) [2]1 (1.2%) [2]0.4940.494
SKIN AND SUBCUTANEOUS TISSUE DISORDERS20 (23.3%) [45]39 (46.4%) [111]40 (47.6%) [104]0.0020.001
ACTINIC KERATOSIS0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
ALOPECIA1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
BLISTER0 (0.0%) [0]5 (6.0%) [8]1 (1.2%) [2]0.0280.494
COLD SWEAT1 (1.2%) [3]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
DERMATITIS CONTACT0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
DRUG ERUPTION1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
ERYTHEMA8 (9.3%) [12]14 (16.7%) [22]14 (16.7%) [22]0.1750.175
HYPERHIDROSIS2 (2.3%) [2]4 (4.8%) [5]8 (9.5%) [10]0.4410.056
PRURITUS8 (9.3%) [11]21 (25.0%) [31]26 (31.0%) [38]0.008<0.001
PRURITUS GENERALISED0 (0.0%) [0]1 (1.2%) [4]1 (1.2%) [1]0.4940.494
RASH5 (5.8%) [9]13 (15.5%) [18]9 (10.7%) [15]0.0480.277
RASH ERYTHEMATOUS0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
RASH MACULO-PAPULAR0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
RASH PRURITIC0 (0.0%) [0]1 (1.2%) [2]2 (2.4%) [3]0.4940.243
SKIN EXFOLIATION0 (0.0%) [0]1 (1.2%) [2]0 (0.0%) [0]0.494>0.999
SKIN IRRITATION3 (3.5%) [4]6 (7.1%) [13]5 (6.0%) [8]0.3260.493
SKIN ODOUR ABNORMAL0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
SKIN ULCER1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
URTICARIA0 (0.0%) [0]1 (1.2%) [3]1 (1.2%) [2]0.4940.494
SOCIAL CIRCUMSTANCES0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
ALCOHOL USE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
SURGICAL AND MEDICAL PROCEDURES2 (2.3%) [2]1 (1.2%) [1]2 (2.4%) [2]>0.999>0.999
ACROCHORDON EXCISION0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
CATARACT OPERATION1 (1.2%) [1]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
EYE LASER SURGERY1 (1.2%) [1]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
SKIN LESION EXCISION0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494
VASCULAR DISORDERS3 (3.5%) [7]3 (3.6%) [3]1 (1.2%) [1]>0.9990.621
HOT FLUSH0 (0.0%) [0]1 (1.2%) [1]0 (0.0%) [0]0.494>0.999
HYPERTENSION1 (1.2%) [2]1 (1.2%) [1]0 (0.0%) [0]>0.999>0.999
HYPOTENSION2 (2.3%) [3]1 (1.2%) [1]0 (0.0%) [0]>0.9990.497
ORTHOSTATIC HYPOTENSION1 (1.2%) [2]0 (0.0%) [0]0 (0.0%) [0]>0.999>0.999
WOUND HAEMORRHAGE0 (0.0%) [0]0 (0.0%) [0]1 (1.2%) [1]>0.9990.494

Note: Treatment emergent events are defined as events which start on or after the start of treatment.

Note: Adverse events are coded using MedDRA.

Note: Percentages are based on the number of subjects in the safety population within each treatment group.

Note: P-values are based on Fisher's Exact test for the comparison of placebo versus each active treatment group.

Note: The column [AE] represents the total number of times an event was recorded.

Program: t-14-5-01.sas

Program t-14-5-01.sas

Version 1, written from Clinwright's patterns, 2026-10-17, checks passed.

/*==== 00-header ====*/
/*----------------------------------------------------------------------------
  Output  : Table 14-5.01 / Incidence of Treatment Emergent Adverse Events by Treatment Group / Safety Analysis Set
  Program : t-14-5-01.sas   Reporting effort : CSR
  ADaM    : /work/adam (ADSL, ADADAS, ADCIBC, ADLBC, ADLBH, ADNPIX, ADTTE, ADVS, ADAE, ADCM, ADMH, ADEX)
  The header and the report step follow from the shell. The sections between
  them make WORK.FINAL, one record per row of the table, in order:
    _page     the page (1 unless the output is paged); _pagelbl its heading or empty
    _ord      the row's order; _indent the label's indentation (0 = flush left)
    _rowid    the uuid of the shell row it shows (WORK._SHELL); one shell row may
              have several (a category per value); a blank row's is blank-<n>
    _kind     label | stat | blank
    rowlabel  the row's label, as text
    col1      Placebo|(N=xx)
    col2      Xanomeline Low|(N=xx)
    col3      Xanomeline High|(N=xx)
    col4      Placebo|vs.|Low Dose
    col5      Placebo|vs.|High Dose
  and set the big N of the column headers:
    &_bign1    Placebo|(N=xx)
    &_bign2    Xanomeline Low|(N=xx)
    &_bign3    Xanomeline High|(N=xx)
  /work/_lib/clinwright.sas has %ls_bign, %ls_count, %ls_stats, %ls_npct, %ls_num.
----------------------------------------------------------------------------*/
libname adam "/work/adam" access=readonly;
%include "/work/_lib/clinwright.sas";
%ls_setup;

/* The shell's rows, in order, with each column's value pattern (_xx1-_xx5). */
data work._shell;
  length _page 8 _pagelbl $200 _ord 8 _indent 8 _rowid $36 _kind $5 _var $32 rowlabel $200 _xx1 $40 _xx2 $40 _xx3 $40 _xx4 $40 _xx5 $40;
  _page = 1; _pagelbl = '';
  _ord=1; _indent=0; _rowid='f5e77b02-db7a-4d93-a9e2-a62a4fc4dd91'; _kind='stat'; _var=''; rowlabel='ANY BODY SYSTEM'; _xx1='xx (xx.x%) [xx]'; _xx2='xx (xx.x%) [xx]'; _xx3='xx (xx.x%) [xx]'; _xx4='x.xxx'; _xx5='x.xxx'; output;
  _ord=2; _indent=0; _rowid='blank-2'; _kind='blank'; _var=''; rowlabel=''; _xx1=''; _xx2=''; _xx3=''; _xx4=''; _xx5=''; output;
  _ord=3; _indent=0; _rowid='874fb9e0-866f-4cf2-a78d-41639e32f8cf'; _kind='stat'; _var=''; rowlabel='[System Organ Class]'; _xx1='xx (xx.x%) [xx]'; _xx2='xx (xx.x%) [xx]'; _xx3='xx (xx.x%) [xx]'; _xx4='x.xxx'; _xx5='x.xxx'; output;
  _ord=4; _indent=1; _rowid='51422807-260c-40a0-8d88-d8146361a8ef'; _kind='stat'; _var=''; rowlabel='[Preferred Term]'; _xx1='xx (xx.x%) [xx]'; _xx2='xx (xx.x%) [xx]'; _xx3='xx (xx.x%) [xx]'; _xx4='x.xxx'; _xx5='x.xxx'; output;
run;

/*==== 10-data ====*/
/* Made from the output's analysis: the records of ADAE with TRTEMFL = 'Y' of the subjects of ADSL with SAFFL = 'Y', by TRT01A. */
/* The population's subjects, in each column they count in. */
data work._popc;
  set adam.adsl(where=(saffl = 'Y'));
  if trt01a in ('Placebo') then do; _col = 1; output; end;
  if trt01a in ('Xanomeline Low Dose') then do; _col = 2; output; end;
  if trt01a in ('Xanomeline High Dose') then do; _col = 3; output; end;
  keep usubjid _col;
run;
data work._pop1; set adam.adsl(where=(saffl = 'Y')); keep usubjid trt01a; run;
proc sort data=work._pop1; by usubjid; run;
/* The records of ADAE with TRTEMFL = 'Y', of the population's subjects, in each column. */
proc sort data=adam.adae(keep=usubjid saffl aedecod aebodsys trtemfl where=(TRTEMFL = 'Y')) out=work._rec; by usubjid; run;
data work._an;
  merge work._rec(in=_r) work._pop1(in=_p);
  by usubjid;
  if _r and _p;
  if trt01a in ('Placebo') then do; _col = 1; output; end;
  if trt01a in ('Xanomeline Low Dose') then do; _col = 2; output; end;
  if trt01a in ('Xanomeline High Dose') then do; _col = 3; output; end;
run;
data work._cols; do _col = 1 to 5; output; end; run;
%ls_bign(data=work._popc, trt=_col, values=1|2|3|4|5|1|2|3, names=_lsn1 _lsn2 _lsn3 _lsn4 _lsn5 _bign1 _bign2 _bign3);

/* Subjects and records per column. */
proc sort data=work._an(keep=usubjid _col) out=work._u; by _col usubjid; run;
data work._c;
  set work._u;
  by _col usubjid;
  retain _n _e;
  if first._col then do; _n = 0; _e = 0; end;
  _e = _e + 1;
  if first.usubjid then _n = _n + 1;
  if last._col then output;
  keep _col _n _e;
run;
proc transpose data=work._c out=work._tn(drop=_name_) prefix=_n; id _col; var _n; run;
proc transpose data=work._c out=work._te(drop=_name_) prefix=_e; id _col; var _e; run;
data work._z; _z = 1; run;
data work._g0;
  merge work._z work._tn work._te;
  array _nn{5} _n1-_n5;
  array _ee{5} _e1-_e5;
  do _i = 1 to 5; _nn{_i} = sum(_nn{_i}, 0); _ee{_i} = sum(_ee{_i}, 0); end;
  _tot = sum(of _n1-_n5);
  drop _i _z;
run;
/* ANY BODY SYSTEM: any. */
data work._f; set work._g0; do _col = 1 to 5; output; end; run;
data work._pp4;
  set work._g0;
  array _px{5} _n1-_n5;
  %ls_pcounts(p=_p4, x=_px, cols=1 2, test=fisher);
  keep _p4;
run;
data work._f; if _n_ = 1 then set work._pp4; set work._f; run;
data work._pp5;
  set work._g0;
  array _px{5} _n1-_n5;
  %ls_pcounts(p=_p5, x=_px, cols=1 3, test=fisher);
  keep _p5;
run;
data work._f; if _n_ = 1 then set work._pp5; set work._f; run;
data work._k1;
  length _rowid $36 _label _pagelbl $200 _v $200;
  set work._f;
  array _nn{5} _n1-_n5;
  array _ee{5} _e1-_e5;
  _rowid = 'f5e77b02-db7a-4d93-a9e2-a62a4fc4dd91';
  _page = 1;
  _pagelbl = '';
  _k0 = 1;
  _k1 = 0; _k2 = 0;
  _k3 = 0; _k4 = 0;
  _label = '';
  if _col = 1 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 2 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 3 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 4 then _v = ifc(missing(_p4), '', ifc(round(sum(_p4, 0), 0.001) < 0.001, '<0.001', ifc(round(sum(_p4, 0), 0.001) > 0.999, '>0.999', strip(put(round(sum(_p4, 0), 0.001), 32.3)))));
  else if _col = 5 then _v = ifc(missing(_p5), '', ifc(round(sum(_p5, 0), 0.001) < 0.001, '<0.001', ifc(round(sum(_p5, 0), 0.001) > 0.999, '>0.999', strip(put(round(sum(_p5, 0), 0.001), 32.3)))));
  keep _rowid _label _page _pagelbl _k0 _k1 _k2 _k3 _k4 _col _v;
run;
/* Per value of aebodsys: subjects and records per column. */
proc sort data=work._an(keep=usubjid _col aebodsys where=(not missing(aebodsys))) out=work._u; by aebodsys _col usubjid; run;
data work._c;
  set work._u;
  by aebodsys _col usubjid;
  retain _n _e;
  if first._col then do; _n = 0; _e = 0; end;
  _e = _e + 1;
  if first.usubjid then _n = _n + 1;
  if last._col then output;
  keep aebodsys _col _n _e;
run;
proc transpose data=work._c out=work._tn(drop=_name_) prefix=_n; by aebodsys; id _col; var _n; run;
proc transpose data=work._c out=work._te(drop=_name_) prefix=_e; by aebodsys; id _col; var _e; run;
data work._g1;
  merge work._tn work._te; by aebodsys;
  array _nn{5} _n1-_n5;
  array _ee{5} _e1-_e5;
  do _i = 1 to 5; _nn{_i} = sum(_nn{_i}, 0); _ee{_i} = sum(_ee{_i}, 0); end;
  _tot = sum(of _n1-_n5);
  drop _i;
run;
proc sort data=work._g1; by  aebodsys; run;
data work._g1;
  set work._g1;
  _o1 = _n_;
run;
/* [System Organ Class]: npct of AEBODSYS. */
data work._f; set work._g1; do _col = 1 to 5; output; end; run;
proc sort data=work._f; by aebodsys _col; run;
data work._pp4;
  set work._g1;
  array _px{5} _n1-_n5;
  %ls_pcounts(p=_p4, x=_px, cols=1 2, test=fisher);
  keep aebodsys _p4;
run;
proc sort data=work._pp4; by aebodsys; run;
data work._f; merge work._f(in=_in) work._pp4; by aebodsys; if _in; run;
data work._pp5;
  set work._g1;
  array _px{5} _n1-_n5;
  %ls_pcounts(p=_p5, x=_px, cols=1 3, test=fisher);
  keep aebodsys _p5;
run;
proc sort data=work._pp5; by aebodsys; run;
data work._f; merge work._f(in=_in) work._pp5; by aebodsys; if _in; run;
data work._k2;
  length _rowid $36 _label _pagelbl $200 _v $200;
  set work._f;
  array _nn{5} _n1-_n5;
  array _ee{5} _e1-_e5;
  _rowid = '874fb9e0-866f-4cf2-a78d-41639e32f8cf';
  _page = 1;
  _pagelbl = '';
  _k0 = 3;
  _k1 = _o1; _k2 = 0;
  _k3 = 0; _k4 = 0;
  _label = strip(aebodsys);
  if _col = 1 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 2 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 3 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 4 then _v = ifc(missing(_p4), '', ifc(round(sum(_p4, 0), 0.001) < 0.001, '<0.001', ifc(round(sum(_p4, 0), 0.001) > 0.999, '>0.999', strip(put(round(sum(_p4, 0), 0.001), 32.3)))));
  else if _col = 5 then _v = ifc(missing(_p5), '', ifc(round(sum(_p5, 0), 0.001) < 0.001, '<0.001', ifc(round(sum(_p5, 0), 0.001) > 0.999, '>0.999', strip(put(round(sum(_p5, 0), 0.001), 32.3)))));
  keep _rowid _label _page _pagelbl _k0 _k1 _k2 _k3 _k4 _col _v;
run;
/* Per value of aebodsys and aedecod: subjects and records per column. */
proc sort data=work._an(keep=usubjid _col aebodsys aedecod where=(not missing(aebodsys) and not missing(aedecod))) out=work._u; by aebodsys aedecod _col usubjid; run;
data work._c;
  set work._u;
  by aebodsys aedecod _col usubjid;
  retain _n _e;
  if first._col then do; _n = 0; _e = 0; end;
  _e = _e + 1;
  if first.usubjid then _n = _n + 1;
  if last._col then output;
  keep aebodsys aedecod _col _n _e;
run;
proc transpose data=work._c out=work._tn(drop=_name_) prefix=_n; by aebodsys aedecod; id _col; var _n; run;
proc transpose data=work._c out=work._te(drop=_name_) prefix=_e; by aebodsys aedecod; id _col; var _e; run;
data work._g2;
  merge work._tn work._te; by aebodsys aedecod;
  array _nn{5} _n1-_n5;
  array _ee{5} _e1-_e5;
  do _i = 1 to 5; _nn{_i} = sum(_nn{_i}, 0); _ee{_i} = sum(_ee{_i}, 0); end;
  _tot = sum(of _n1-_n5);
  drop _i;
run;
proc sort data=work._g2; by aebodsys aedecod; run;
data work._g2;
  set work._g2;
  by aebodsys;
  retain _r;
  if first.aebodsys then _r = 0;
  _r = _r + 1;
  _o2 = _r;
  drop _r;
run;
proc sort data=work._g2; by aebodsys; run;
proc sort data=work._g1(keep=aebodsys _o1) out=work._gp; by aebodsys; run;
data work._g2; merge work._g2(in=_in) work._gp; by aebodsys; if _in; run;
/* [Preferred Term]: npct of AEDECOD. */
data work._f; set work._g2; do _col = 1 to 5; output; end; run;
proc sort data=work._f; by aebodsys aedecod _col; run;
data work._pp4;
  set work._g2;
  array _px{5} _n1-_n5;
  %ls_pcounts(p=_p4, x=_px, cols=1 2, test=fisher);
  keep aebodsys aedecod _p4;
run;
proc sort data=work._pp4; by aebodsys aedecod; run;
data work._f; merge work._f(in=_in) work._pp4; by aebodsys aedecod; if _in; run;
data work._pp5;
  set work._g2;
  array _px{5} _n1-_n5;
  %ls_pcounts(p=_p5, x=_px, cols=1 3, test=fisher);
  keep aebodsys aedecod _p5;
run;
proc sort data=work._pp5; by aebodsys aedecod; run;
data work._f; merge work._f(in=_in) work._pp5; by aebodsys aedecod; if _in; run;
data work._k3;
  length _rowid $36 _label _pagelbl $200 _v $200;
  set work._f;
  array _nn{5} _n1-_n5;
  array _ee{5} _e1-_e5;
  _rowid = '51422807-260c-40a0-8d88-d8146361a8ef';
  _page = 1;
  _pagelbl = '';
  _k0 = 3;
  _k1 = _o1; _k2 = 4;
  _k3 = _o2; _k4 = 0;
  _label = strip(aedecod);
  if _col = 1 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 2 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 3 then _v = strip(ifc(missing(_nn{_col}), '-', %ls_num(_nn{_col}, 0))) || ' (' || strip(ifc(missing(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .)), '-', %ls_num(ifn(input(symget(cats('_lsn', _col)), 8.) > 0, 100 * _nn{_col} / max(input(symget(cats('_lsn', _col)), 8.), 1), .), 1))) || '%) [' || strip(ifc(missing(_ee{_col}), '-', %ls_num(_ee{_col}, 0))) || ']';
  else if _col = 4 then _v = ifc(missing(_p4), '', ifc(round(sum(_p4, 0), 0.001) < 0.001, '<0.001', ifc(round(sum(_p4, 0), 0.001) > 0.999, '>0.999', strip(put(round(sum(_p4, 0), 0.001), 32.3)))));
  else if _col = 5 then _v = ifc(missing(_p5), '', ifc(round(sum(_p5, 0), 0.001) < 0.001, '<0.001', ifc(round(sum(_p5, 0), 0.001) > 0.999, '>0.999', strip(put(round(sum(_p5, 0), 0.001), 32.3)))));
  keep _rowid _label _page _pagelbl _k0 _k1 _k2 _k3 _k4 _col _v;
run;

data work._cells; set work._k1 work._k2 work._k3; run;
proc sort data=work._cells; by _page _pagelbl _k0 _k1 _k2 _k3 _k4 _rowid _label _col; run;
proc transpose data=work._cells out=work._wide(drop=_name_) prefix=col;
  by _page _pagelbl _k0 _k1 _k2 _k3 _k4 _rowid _label;
  id _col;
  var _v;
run;
proc sort data=work._wide; by _rowid; run;
proc sort data=work._shell(drop=_page _pagelbl) out=work._rows; by _rowid; run;
data work._inst;
  merge work._wide(in=_w) work._rows(in=_s);
  by _rowid;
  if _w and _s;
  if _label ne '' then rowlabel = _label;
run;
data work._fixed;
  set work._shell;
  if _rowid not in ('f5e77b02-db7a-4d93-a9e2-a62a4fc4dd91' '874fb9e0-866f-4cf2-a78d-41639e32f8cf' '51422807-260c-40a0-8d88-d8146361a8ef');
  _k0 = _ord; _k1 = 0; _k2 = 0; _k3 = 0; _k4 = 0;
run;
data work.final;
  length col1 col2 col3 col4 col5 $200 _pagelbl $200;
  set work._inst work._fixed;
run;
proc sort data=work.final; by _page _k0 _k1 _k2 _k3 _k4; run;
data work.final;
  set work.final;
  _ord = _n_;
  keep _page _pagelbl _ord _indent _rowid _kind rowlabel col1 col2 col3 col4 col5;
run;

/*==== 90-report ====*/
/* 90-report: from the shell; the titles, columns, headers and footnotes are not changed here. */
%ls_need(_bign1 _bign2 _bign3);
%ls_final_check(columns=_page _pagelbl _ord _indent _rowid _kind rowlabel col1 col2 col3 col4 col5);
proc sort data=work.final out=work._report; by _page _ord; run;
data work._report;
  set work._report;
  /* Two spaces per step of indentation: the label column keeps leading spaces (asis=on). */
  if _indent > 0 then rowlabel = repeat(' ', 2 * _indent - 1) || rowlabel;
run;
%let _lspaged = 0;
proc sql noprint; select count(*) into :_lspaged trimmed from work._report where _pagelbl ne ''; quit;

options orientation=landscape;
ods listing close;
ods rtf file="/work/out/t-14-5-01.rtf" style=journal;
title1 j=l "CDISCPILOT01" j=r "Page ~{thispage} of ~{lastpage}";
title2 j=c "Table 14-5.01";
title3 j=c "Incidence of Treatment Emergent Adverse Events by Treatment Group";
title4 j=c "Safety Analysis Set";
footnote1 j=l "Note: Treatment emergent events are defined as events which start on or after the start of treatment.";
footnote2 j=l "Note: Adverse events are coded using MedDRA.";
footnote3 j=l "Note: Percentages are based on the number of subjects in the safety population within each treatment group.";
footnote4 j=l "Note: P-values are based on Fisher's Exact test for the comparison of placebo versus each active treatment group.";
footnote5 j=l "Note: The column [AE] represents the total number of times an event was recorded.";
footnote6 j=l "Program: t-14-5-01.sas";
%macro _ls_report;
proc report data=work._report nowd split='|' missing style(report)={width=100%};
  column _page _pagelbl _ord _indent _kind rowlabel col1 col2 col3 ("Fisher's Exact|p-values" col4 col5);
  define _page / order order=internal noprint;
  define _pagelbl / order noprint;
  define _ord / order order=internal noprint;
  define _indent / display noprint;
  define _kind / display noprint;
  define rowlabel / display "" style(column)={cellwidth=40% asis=on} style(header)={just=l};
  define col1 / display "Placebo|(N=&_bign1.)" style(column)={cellwidth=12% just=c} style(header)={just=c};
  define col2 / display "Xanomeline Low|(N=&_bign2.)" style(column)={cellwidth=12% just=c} style(header)={just=c};
  define col3 / display "Xanomeline High|(N=&_bign3.)" style(column)={cellwidth=12% just=c} style(header)={just=c};
  define col4 / display "Placebo|vs.|Low Dose" style(column)={cellwidth=12% just=c} style(header)={just=c};
  define col5 / display "Placebo|vs.|High Dose" style(column)={cellwidth=12% just=c} style(header)={just=c};
  %if &_lspaged > 0 %then %do;
  compute before _pagelbl / style={just=l};
    line _pagelbl $200.;
  endcomp;
  %end;
  break after _page / page;
run;
%mend _ls_report;
%_ls_report;
ods rtf close;
ods listing;
%ls_final_export;