- Get link
- X
- Other Apps
INPUT | PROC FREQ | TABLES | IF THEN STATEMENTS
/* Identify and replace missing values in AESEV and AESER using IF-THEN-ELSE .*/
/* Use PROC FREQ to check missing values.*/
DATA AE;
INPUT USUBJID AEDECOD$ AESEV$ AESER$;
DATALINES;
101 HEADACHE MILD Y
102 NAUSEA . N
103 . SEVERE Y
104 VOMITING MODERATE .
;
RUN;
PROC PRINT;RUN;
OUTPUT:
Obs | USUBJID | AEDECOD | AESEV | AESER |
---|---|---|---|---|
1 | 101 | HEADACHE | MILD | Y |
2 | 102 | NAUSEA | N | |
3 | 103 | SEVERE | Y | |
4 | 104 | VOMITING | MODERATE |
PROC FREQ DATA=AE NLEVELS;
TABLES AEDECOD AESEV AESER / MISSING;
RUN;
OUTPUT:
The FREQ Procedure
Number of Variable Levels | |||
---|---|---|---|
Variable | Levels | Missing Levels | Nonmissing Levels |
AEDECOD | 4 | 1 | 3 |
AESEV | 4 | 1 | 3 |
AESER | 3 | 1 | 2 |
AEDECOD | Frequency | Percent | Cumulative Frequency |
Cumulative Percent |
---|---|---|---|---|
1 | 25.00 | 1 | 25.00 | |
HEADACHE | 1 | 25.00 | 2 | 50.00 |
NAUSEA | 1 | 25.00 | 3 | 75.00 |
VOMITING | 1 | 25.00 | 4 | 100.00 |
AESEV | Frequency | Percent | Cumulative Frequency |
Cumulative Percent |
---|---|---|---|---|
1 | 25.00 | 1 | 25.00 | |
MILD | 1 | 25.00 | 2 | 50.00 |
MODERATE | 1 | 25.00 | 3 | 75.00 |
SEVERE | 1 | 25.00 | 4 | 100.00 |
AESER | Frequency | Percent | Cumulative Frequency |
Cumulative Percent |
---|---|---|---|---|
1 | 25.00 | 1 | 25.00 | |
N | 1 | 25.00 | 2 | 50.00 |
Y | 2 | 50.00 | 4 | 100.00 |
DATA AE;
SET AE;
IF AEDECOD = '' THEN AEDECOD='UNKNOWN';
IF AESEV = '' THEN AESEV='UNKNOWN';
IF AESER = '' THEN AESER='N';
RUN;
PROC PRINT;RUN;
OUTPUT:
Obs | USUBJID | AEDECOD | AESEV | AESER |
---|---|---|---|---|
1 | 101 | HEADACHE | MILD | Y |
2 | 102 | NAUSEA | UNKNOWN | N |
3 | 103 | UNKNOWN | SEVERE | Y |
4 | 104 | VOMITING | MODERATE | N |
PRACTICE AND COMMENT YOUR CODE:
-->PLEASE FOLLOW OUR BLOG FOR MORE UPDATES.
TO FOLLOW OUR TELEGRAM CHANNEL CLICK HERE
- Get link
- X
- Other Apps
Comments
Post a Comment