%let gpath='.'; %let dpi=200; ods html close; ods listing gpath=&gpath image_dpi=&dpi; /*--Sample data (reduced columns)--*/ data sample; input AESOC $ 1-53 AEPT $ 54-98 RR P_RR; datalines; BLOOD AND LYMPHATIC SYSTEM DISORDERS Agranulocytosis 0.33 0.3148786413 BLOOD AND LYMPHATIC SYSTEM DISORDERS Anaemia 1.3436 0.2280680306 BLOOD AND LYMPHATIC SYSTEM DISORDERS Eosinophilia 1.584 0.4145931863 BLOOD AND LYMPHATIC SYSTEM DISORDERS Erythropenia 2.97 0.3197423745 BLOOD AND LYMPHATIC SYSTEM DISORDERS Iron Deficiency Anaemia 0.495 0.2401452656 BLOOD AND LYMPHATIC SYSTEM DISORDERS Leukocytosis 8.9101 0.0464665798 BLOOD AND LYMPHATIC SYSTEM DISORDERS Leukopenia 1.782 0.2923841772 BLOOD AND LYMPHATIC SYSTEM DISORDERS Neutropenia 0.495 0.4067545386 BLOOD AND LYMPHATIC SYSTEM DISORDERS Pancytopenia 2.97 0.3219117272 BLOOD AND LYMPHATIC SYSTEM DISORDERS Thrombocythaemia 0.33 0.3121842641 CARDIAC DISORDERS Acute Myocardial Infarction 1.98 0.4208333427 CARDIAC DISORDERS Arrhythmia 1.4143 0.3143466968 CARDIAC DISORDERS Arteriosclerosis Coronary Artery 0.495 0.5576818581 CARDIAC DISORDERS Atrial Fibrillation 0.9039 0.7356136775 CARDIAC DISORDERS Atrial Flutter 0.1414 0.0816047121 CARDIAC DISORDERS Bundle Branch Block Right 0.8901 0.025975207 CARDIAC DISORDERS Cardiac Failure 0.9281 0.8346033439 CARDIAC DISORDERS Cardiac Failure Congestive 1.485 0.5368072613 CARDIAC DISORDERS Cardiogenic Shock 0.198 0.1551386279 CARDIAC DISORDERS Coronary Artery Disease 1.584 0.2473978765 CARDIAC DISORDERS Extrasystoles 0.5775 0.2407608216 CARDIAC DISORDERS Mitral Valve Incompetence 0.792 0.7271243808 CARDIAC DISORDERS Myocardial Infarction 0.54 0.215995664 CARDIAC DISORDERS Myocardial Ischaemia 1.2375 0.6515736336 CARDIAC DISORDERS Sinus Bradycardia 0.2475 0.1757549055 CARDIAC DISORDERS Supraventricular Extrasystoles 0.396 0.2507472288 CARDIAC DISORDERS Tachycardia 1.2729 0.6303008251 EAR AND LABYRINTH DISORDERS Deafness Unilateral 4.95 0.159309738 EAR AND LABYRINTH DISORDERS Ear Pain 0.6188 0.3941259365 EAR AND LABYRINTH DISORDERS Hypoacusis 0.55 0.275446407 EAR AND LABYRINTH DISORDERS Tinnitus 1.155 0.7125759319 ENDOCRINE DISORDERS Goitre 0.88 0.7917211399 ENDOCRINE DISORDERS Hyperthyroidism 0.5657 0.3560080097 ENDOCRINE DISORDERS Hypothyroidism 1.1647 0.6412939681 ENDOCRINE DISORDERS Thyroiditis 6.9301 0.084701416 EYE DISORDERS Conjunctivitis 1.3394 0.3555350147 EYE DISORDERS Conjunctivitis Allergic 2.31 0.210855982 EYE DISORDERS Eye Haemorrhage 4.95 0.1047447545 EYE DISORDERS Eye Pain 1.98 0.3239054265 EYE DISORDERS Glaucoma 0.675 0.2341704745 EYE DISORDERS Keratoconjunctivitis Sicca 3.96 0.1830405926 EYE DISORDERS Visual Acuity Reduced 0.44 0.1590844192 GASTROINTESTINAL DISORDERS Abdominal Pain Upper 0.9664 0.8743987392 GASTROINTESTINAL DISORDERS Colitis 1.98 0.2543971528 GASTROINTESTINAL DISORDERS Diverticulum 0.77 0.6019334766 GASTROINTESTINAL DISORDERS Dry Mouth 0.693 0.4528565301 GASTROINTESTINAL DISORDERS Flatulence 0.693 0.1905783219 GASTROINTESTINAL DISORDERS Gastric Polyps 0.66 0.6463699768 GASTROINTESTINAL DISORDERS Gastric Ulcer 0.66 0.5160244598 GASTROINTESTINAL DISORDERS Gastrooesophageal Reflux Disease 0.825 0.5210541755 GASTROINTESTINAL DISORDERS Haematochezia 0.198 0.0995753444 GASTROINTESTINAL DISORDERS Haemorrhoids 0.7748 0.4125481894 GASTROINTESTINAL DISORDERS Hiatus Hernia 1.3436 0.3971137024 GASTROINTESTINAL DISORDERS Hyperchlorhydria 0.11 0.0442998399 GASTROINTESTINAL DISORDERS Irritable Bowel Syndrome 0.825 0.6514020473 GASTROINTESTINAL DISORDERS Oesophagitis 1.98 0.1622595266 GASTROINTESTINAL DISORDERS Periodontitis 0.2829 0.0921100566 GASTROINTESTINAL DISORDERS Stomach Discomfort 0.594 0.4701055328 GASTROINTESTINAL DISORDERS Toothache 0.198 0.0197110756 GASTROINTESTINAL DISORDERS Vomiting 0.9609 0.8686066329 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Asthenia 0.6233 0.1202125134 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Influenza Like Illness 0.594 0.3062677146 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Local Swelling 2.475 0.2618987455 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Malaise 1.3613 0.5036977992 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Oedema Peripheral 0.9526 0.8006977584 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Pain 1.32 0.4634454407 GENERAL DISORDERS AND ADMINISTRATION SITE CONDITIONS Pyrexia 1.122 0.7435940934 HEPATOBILIARY DISORDERS Cholelithiasis 1.265 0.4505128911 HEPATOBILIARY DISORDERS Hepatic Steatosis 1.32 0.6051366816 IMMUNE SYSTEM DISORDERS Drug Hypersensitivity 1.65 0.4877812755 INFECTIONS AND INFESTATIONS Diverticulitis 0.7425 0.4962979657 INFECTIONS AND INFESTATIONS Ear Infection 1.815 0.231821959 INFECTIONS AND INFESTATIONS Fungal Skin Infection 0.09 0.0245078539 INFECTIONS AND INFESTATIONS Gastroenteritis 0.8972 0.6683875626 INFECTIONS AND INFESTATIONS Gastroenteritis Viral 0.7615 0.5141223575 INFECTIONS AND INFESTATIONS Herpes Zoster 0.7169 0.2387433031 INFECTIONS AND INFESTATIONS Laryngitis 0.63 0.3333811942 INFECTIONS AND INFESTATIONS Localised Infection 0.8486 0.7671078012 INFECTIONS AND INFESTATIONS Lower Respiratory Tract Infection 0.6828 0.1824205212 INFECTIONS AND INFESTATIONS Onychomycosis 0.72 0.4760656342 INFECTIONS AND INFESTATIONS Otitis Media 0.33 0.1526073972 INFECTIONS AND INFESTATIONS Pyelonephritis 0.1414 0.0324796911 INFECTIONS AND INFESTATIONS Respiratory Tract Infection 1.4231 0.2723690156 INFECTIONS AND INFESTATIONS Respiratory Tract Infection Viral 0.7425 0.5790808219 INFECTIONS AND INFESTATIONS Rhinitis 1.125 0.6841668407 INFECTIONS AND INFESTATIONS Sinusitis 0.9379 0.7797056546 INFECTIONS AND INFESTATIONS Tracheitis 3.96 0.0594592557 1 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Back Injury 0.66 0.4259000244 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Excoriation 1.5557 0.3552027384 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Femur Fracture 0.792 0.6210532684 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Foot Fracture 0.726 0.4156206662 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Humerus Fracture 0.825 0.5792032912 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Joint Injury 0.5657 0.1908350303 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Joint Sprain 1.54 0.146208831 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Lumbar Vertebral Fracture 0.4714 0.0438641557 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Muscle Strain 2.2275 0.0517765512 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Post-Traumatic Pain 1.4143 0.4782663204 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Procedural Pain 0.63 0.1698073379 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Skin Laceration 0.495 0.1888344299 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Thoracic Vertebral Fracture 0.6406 0.2433700522 INJURY, POISONING AND PROCEDURAL COMPLICATIONS Wound 1.21 0.6698783855 INVESTIGATIONS Blood Cholesterol Increased 8.91 0.0117906386 INVESTIGATIONS Blood Pressure Increased 0.8486 0.674561908 INVESTIGATIONS Weight Decreased 0.9138 0.8210610531 METABOLISM AND NUTRITION DISORDERS Anorexia 2.2275 0.1701144856 METABOLISM AND NUTRITION DISORDERS Diabetes Mellitus 1.1385 0.6686225042 METABOLISM AND NUTRITION DISORDERS Glucose Tolerance Impaired 0.495 0.3093142609 METABOLISM AND NUTRITION DISORDERS Hyperlipidaemia 0.5241 0.109081222 METABOLISM AND NUTRITION DISORDERS Hypokalaemia 3.96 0.0208538568 METABOLISM AND NUTRITION DISORDERS Type 2 Diabetes Mellitus 0.81 0.637335401 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Arthralgia 1.0055 0.944342722 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Arthritis 0.6188 0.2269744035 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Bursitis 1.6088 0.2836170752 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Foot Deformity 1.485 0.4489322069 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Joint Range Of Motion Decreased 0.0521 0.0025295164 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Joint Swelling 0.5331 0.0519091515 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Muscle Spasms 1.026 0.8895964188 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Muscular Weakness 2.64 0.1352278667 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Musculoskeletal Chest Pain 1.08 0.792470126 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Myalgia 0.9617 0.86949156 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Neck Pain 1.375 0.1368218963 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Osteochondrosis 0.7071 0.5511522841 MUSCULOSKELETAL AND CONNECTIVE TISSUE DISORDERS Spinal Osteoarthritis 0.7425 0.2633009587 NEOPLASMS BENIGN, MALIGNANT AND UNSPECIFIED Basal Cell Carcinoma 1.65 0.2280045653 NEOPLASMS BENIGN, MALIGNANT AND UNSPECIFIED Benign Neoplasm Of Thyroid Gland 2.97 0.1609401123 NEOPLASMS BENIGN, MALIGNANT AND UNSPECIFIED Lung Neoplasm Malignant 7.92 0.0202393187 NEOPLASMS BENIGN, MALIGNANT AND UNSPECIFIED Uterine Leiomyoma 1.386 0.5746990151 NERVOUS SYSTEM DISORDERS Carpal Tunnel Syndrome 1.17 0.6999761615 NERVOUS SYSTEM DISORDERS Cerebrovascular Accident 1.485 0.3814726058 NERVOUS SYSTEM DISORDERS Memory Impairment 0.8858 0.7143846752 NERVOUS SYSTEM DISORDERS Paraesthesia 1.2229 0.5336887039 NERVOUS SYSTEM DISORDERS Radiculopathy 1.7325 0.3736804453 NERVOUS SYSTEM DISORDERS Syncope 0.7838 0.4225563004 PSYCHIATRIC DISORDERS Anxiety 1.485 0.0982279028 PSYCHIATRIC DISORDERS Insomnia 0.946 0.7911351204 PSYCHIATRIC DISORDERS Sleep Disorder 3.2175 0.030094171 RENAL AND URINARY DISORDERS Dysuria 0.3494 0.0199275109 RENAL AND URINARY DISORDERS Pollakiuria 0.495 0.1497843968 RENAL AND URINARY DISORDERS Renal Failure Chronic 14.8501 0.0084001402 REPRODUCTIVE SYSTEM AND BREAST DISORDERS Breast Pain 0.2475 0.055286265 REPRODUCTIVE SYSTEM AND BREAST DISORDERS Fibrocystic Breast Disease 3.465 0.0980924111 RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS Asthma 1.1984 0.5556299808 RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS Chronic Obstructive Pulmonary Disease 0.8663 0.7806905098 RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS Dysphonia 1.98 0.2023077388 RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS Epistaxis 2.5457 0.0288840825 RESPIRATORY, THORACIC AND MEDIASTINAL DISORDERS Pharyngolaryngeal Pain 0.6011 0.0914236418 SKIN AND SUBCUTANEOUS TISSUE DISORDERS Alopecia 0.7816 0.4715786881 SKIN AND SUBCUTANEOUS TISSUE DISORDERS Ecchymosis 5.94 0.0602811515 SKIN AND SUBCUTANEOUS TISSUE DISORDERS Pruritus 0.7034 0.1548440156 SKIN AND SUBCUTANEOUS TISSUE DISORDERS Rash 1.4204 0.1892661599 SKIN AND SUBCUTANEOUS TISSUE DISORDERS Skin Ulcer 1.98 0.130949523 SKIN AND SUBCUTANEOUS TISSUE DISORDERS Urticaria 0.66 0.3574165938 VASCULAR DISORDERS Hypertension 1.0093 0.9180264231 VASCULAR DISORDERS Hypertensive Crisis 0.7425 0.6952655981 ; run; /*ods html;*/ /*proc print;run;*/ /*ods html close;*/ /*--Define Format with Unicode for the left and right arrows--*/ proc format;; value $txt "P" = "Favors Placebo (*ESC*){Unicode '2192'x}" "T" = "(*ESC*){Unicode '2190'x} Favors Treatment"; run; /*--Add axis annotation text to data--*/ data sample2; set sample end=last; if p_rr < 0.05 and rr > 1 then label=aept; output; if last then do; ylbl=1.0; xlbl=0.3; text="T"; output; ylbl=1.0; xlbl=3; text="P"; output; end; run; %let inset1=527/1287 (40.9%); %let inset2=513/1300 (39.5%); /*--Create Volcano Plot--*/ ods graphics / reset width=6in height=4in maxlegendarea=100 imagename='Volcano_RR'; title 'P-risk (Odds Ratio) Plot of Treatment Emergent Adverse Events at PT Level'; proc sgplot data=sample2; format aesoc $10. text $txt.; label p_rr='Fisher Exact p-value'; label rr='Odds Ratio'; scatter x=rr y=p_rr / group=aesoc datalabel=label name='a'; refline 1 / axis=x lineattrs=(pattern=shortdash); refline 0.05 / axis=y lineattrs=(pattern=shortdash); inset ("Placebo:" = "n/N(%)=&inset1" "Treatment:" = "n/N(%)=&inset2") / noborder position=topleft; text x=xlbl y=ylbl text=text / position=bottom contributeoffsets=(ymax); yaxis reverse type=log values=(1.0 0.1 0.05 0.01 0.001) offsetmin=0.1; xaxis type=log values=(0.1 1 2 5 10) valueshint; keylegend 'a' / across=1 position=right valueattrs=(size=6); run;