Setup

Summarizing Free-Text Adverse Event Data

data adverse;
input subjectid $ 1-7 ae $ 9-41;
datalines;
100-101 HEDACHE
100-105 HEADACHE
100-110 MYOCARDIAL INFARCTION
200-004 MI
300-023 BROKEN LEG
400-010 HIVES
500-001 LIGHTHEADEDNESS/FACIAL LACERATION
;
run; 

proc print noobs;
run;

proc freq data = adverse;
title "***********************************Summarizing Free-Text AE (Adverse Event)****************************************";
tables ae;
run;
subjectid ae
100-101 HEDACHE
100-105 HEADACHE
100-110 MYOCARDIAL INFARCTION
200-004 MI
300-023 BROKEN LEG
400-010 HIVES
500-001 LIGHTHEADEDNESS/FACIAL LACERATION


***********************************Summarizing Free-Text AE (Adverse Event)****************************************

ae Frequency Percent Cumulative
Frequency 		Cumulative
Percent
BROKEN LEG 1 14.29 1 14.29
HEADACHE 1 14.29 2 28.57
HEDACHE 1 14.29 3 42.86
HIVES 1 14.29 4 57.14
LIGHTHEADEDNESS/FACIAL LACERATION 1 14.29 5 71.43
MI 1 14.29 6 85.71
MYOCARDIAL INFARCTION 1 14.29 7 100.00

Summarizing Coded Adverse Event Data

data adverse;
label aecode = "Adverse Event Code"
ae_verbatim = "AE Verbatim CRF text"
ae_pt = "AE preferred term";
input subjectid $ 1-7 aecode $ 9-16
ae_verbatim $ 18-39 ae_pt $ 40-60;
datalines;
100-101 10019211 HEDACHE               HEADACHE
100-105 10019211 HEADACHE              HEADACHE
100-110 10028596 MYOCARDIAL INFARCTION MYOCARDIAL INFARCTION
200-004 10028596 MI                    MYOCARDIAL INFARCTION
300-023 10061599 BROKEN LEG            LOWER LIMB FRACTURE
400-010 10046735 HIVES                 URTICARIA
500-001 10013573 LIGHTHEADEDNESS       DIZZINESS
500-001 10058818 FACIAL LACERATION     SKIN LACERATION
;
run;

proc print noobs;
run;

proc freq data = adverse;
title "***********************************Summarizing Coded AE (Adverse Event) Data****************************************";
tables ae_pt;
run;
aecode ae_verbatim ae_pt subjectid
10019211 HEDACHE HEADACHE 100-101
10019211 HEADACHE HEADACHE 100-105
10028596 MYOCARDIAL INFARCTION MYOCARDIAL INFARCTION 100-110
10028596 MI MYOCARDIAL INFARCTION 200-004
10061599 BROKEN LEG LOWER LIMB FRACTURE 300-023
10046735 HIVES URTICARIA 400-010
10013573 LIGHTHEADEDNESS DIZZINESS 500-001
10058818 FACIAL LACERATION SKIN LACERATION 500-001


***********************************Summarizing Coded AE (Adverse Event) Data****************************************

AE preferred term
ae_pt Frequency Percent Cumulative
Frequency 		Cumulative
Percent
DIZZINESS 1 12.50 1 12.50
HEADACHE 2 25.00 3 37.50
LOWER LIMB FRACTURE 1 12.50 4 50.00
MYOCARDIAL INFARCTION 2 25.00 6 75.00
SKIN LACERATION 1 12.50 7 87.50
URTICARIA 1 12.50 8 100.00