124.INPUT | PROC FREQ | TABLES | IF THEN STATEMENTS

       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

Comments