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